Amandeep Singh

Senior Consultant at Aletha Corp
  • Claim this Profile
Contact Information
us****@****om
(386) 825-5501
Location
Scarborough, Ontario, Canada, CA
Languages
  • English -

Topline Score

Topline score feature will be out soon.

Bio

Generated by
Topline AI

5.0

/5.0
/ Based on 1 ratings
  • (1)
  • (0)
  • (0)
  • (0)
  • (0)

Filter reviews by:

Gorang Arora

I have had a pleasure of working with Amandeep for past 1.5 years. He had done an exceptional job in our project. A creative and wise colleague. Always putting his mind in building a very optimal solution to every problem in the first place. A go to person in the team. His technical skills and deep experience are always focused towards getting client satisfaction. Can work independently. I would highly recommend him for any piece of assignment.

You need to have a working account to view this content.
Join now
You need to have a working account to view this content.
Join now

Credentials

  • Snowflake Technical Sales Professional Accreditation
    Snowflake
    Dec, 2022
    - Nov, 2024
  • Astronomer Certification for Apache Airflow Fundamentals
    Astronomer
    Sep, 2022
    - Nov, 2024
  • Hands On Essentials - Data Warehouse
    Snowflake
    Apr, 2021
    - Nov, 2024
  • Oracle Database SQL Certified Expert
    Oracle
    Mar, 2016
    - Nov, 2024
  • SnowPro Core Certification
    Snowflake
    Jan, 2023
    - Nov, 2024

Experience

  • Aletha Corp
    • Canada
    • IT Services and IT Consulting
    • 1 - 100 Employee
    • Senior Consultant
      • Jan 2023 - Present

  • eClerx
    • India
    • Information Technology & Services
    • 700 & Above Employee
    • Senior Data Engineer
      • Mar 2021 - Jan 2023

      Project 1: Customer lifecycle analysis Client : Autodesk, USA Role : Cloud data engineer Duration : October 2021 – August 2022 Technologies : Snowflake, Python, Apache Airflow, GitHub, Jenkins Responsibilities: • Consolidate forums, cases and survey data of the software tools offerings from multiple sources to Snowflake for sentiment calculation and to capture customer experience for different phases • Calculate sentiments using python libraries, fastText and AWS comprehend • Responsible for writing python scripts, creating SnowPipes, utilizing copy command for loads from s3 buckets, writing Snowflake stored procedures, creating complex and normalized views • Utilizing Airflow with Astronomer for automation of load process • Fully automated process using GitHub and Jenkins Project 2: Creation of Unified Customer data lake in Snowflake Cloud Client : Avalara, USA Role : Cloud data engineer Duration : March 2021 – October 2021 Technologies : Snowflake, Python, Apache Airflow, GitLab, Jenkins Responsibilities: • Create a consolidated customer data lake in Snowflake for unified customer view • Design and develop ETL pipelines using Apache Airflow and Python to integrate various API sources such as ZoomInfo, Adobe Analytics, HG insights etc. • Writing Snowflake stored procedures, handle semi-structure data, design SnowPipes for S3 data load, optimize long running processes etc. Show less

  • Cybage Software
    • India
    • IT Services and IT Consulting
    • 700 & Above Employee
    • Data Engineer
      • Mar 2019 - Mar 2021

      Project: Enterprise Business Development Client : Athenahealth, USA Role : Cloud data engineer Duration : March 2019 – March 2021 Technologies : Snowflake, Python, IICS, SQL Server, PowerShell Responsibilities: • Migration of existing SQL server database to Snowflake cloud with ETL pipelines designed using IICS. • Design EDW in Snowflake: integrate data from Salesforce, Eloqua, Wave and other sources and post this data to the downstream Project: Enterprise Business Development Client : Athenahealth, USA Role : Cloud data engineer Duration : March 2019 – March 2021 Technologies : Snowflake, Python, IICS, SQL Server, PowerShell Responsibilities: • Migration of existing SQL server database to Snowflake cloud with ETL pipelines designed using IICS. • Design EDW in Snowflake: integrate data from Salesforce, Eloqua, Wave and other sources and post this data to the downstream

  • Capgemini
    • France
    • IT Services and IT Consulting
    • 700 & Above Employee
    • ETL Developer
      • Dec 2015 - Mar 2019

      Project: Firm Risk Management- Credit Risk Management Client : Morgan Stanley, USA Role : ETL developer Duration : December 2015 – March 2019 Technologies : DB2, SQL Server, Oracle, UNIX, Informatica, Autosys, JIRA Responsibilities: • Development work on complete cycle of SDLC methodologies from Requirement gathering to maintenance. • Migration of existing ETL code to DB2 Stored procedure for efficiency and daily batch time reduction. • Development and automation of data masking process • Writing Unix shell scripting for automation of load, for Autosys and many operational tasks to reduce manual efforts. Show less

Education

  • Loyalist College
    Cloud Computing
    2021 - 2023
  • Visvesvaraya Technological University
    Bachelor’s Degree, Computer Science
    2011 - 2015

Community

You need to have a working account to view this content. Click here to join now