Amandeep Singh - Data Engineer/Analyst

Q: Where is Amandeep based?

Amandeep is based in Chandigarh, India and can operate in on-site , hybrid , and remote work models.

Q: What languages does Amandeep speak?

Amandeep speaks the following languages: English (Intermediate), Dutch (Elementary) .

Q: How many years of experience does Amandeep have?

Amandeep has at least 11 years of experience. During this time, Amandeep has worked in at least 7 different roles and for 2 different companies . The average length of individual experience is 2 years and 7 months . Note that Amandeep may not have shared all experience and actually has more experience.

Q: What is Amandeep's latest experience?

Amandeep's most recent position is Data Engineer/Analyst at Advance Delivery Consulting .

Q: What companies has Amandeep worked for in recent years?

In recent years, Amandeep has worked for Advance Delivery Consulting and Infosys Technologies .

Q: Which industries is Amandeep most experienced in?

Amandeep is most experienced in industries like Information Technology , Professional Services , and Insurance .

Q: Which business areas is Amandeep most experienced in?

Amandeep is most experienced in business areas like Business Intelligence , Information Technology , and Quality Assurance .

Q: Which industries has Amandeep worked in recently?

Amandeep has recently worked in industries like Professional Services and Information Technology .

Q: Which business areas has Amandeep worked in recently?

Amandeep has recently worked in business areas like Business Intelligence , Information Technology , and Quality Assurance .

Recommended expert

Chandigarh, India

Check rate

Experience

May 2023 - Present

3 years 3 months

Australia

Data Engineer/Analyst

Advance Delivery Consulting

Phase 1 of the migration project involved archiving and purging data from the HAMBS database (SQL Server) based on membership and claims cutoff dates to comply with Australian GDPR requirements. Created SQL scripts for archiving and purging data.
Phase 2 was migrating data from the HAMBS database to the CIVICA database (both SQL Server).
Analyzed the HAMBS SQL Server tables for data discovery and to identify potential data quality issues before migration.
Mapped data lineage between CIVICA and HAMBS tables and worked with business analysts to prepare mapping sheets.
Created and executed SSIS ETL packages to migrate data from HAMBS to CIVICA tables.
Optimized SQL query performance.
Supported and fixed Jira tickets logged by business users after data migration.

Jan 2022 - May 2023

1 year 5 months

United Kingdom

Onshore ETL Developer

Infosys Technologies

Worked with business analysts and designers to understand requirements and build ETL pipelines in Azure Data Factory and Python.
Created mapping data flows and triggers in Azure Data Factory to schedule pipelines.
Integrated and transformed data from various sources and loaded it into Azure SQL Database.
Optimized pipeline performance.
Built tools for promoting code to higher environments and supported production incidents and defects.
Deployed code to higher environments.
Ran a proof of concept to migrate existing applications to Azure Cloud by building data pipelines in Azure Data Factory.
Set up self-hosted integration runtime services to move data between Azure cloud and on-premises databases.
Implemented CI/CD pipelines in Azure DevOps.

Apr 2020 - Dec 2021

1 year 9 months

Netherlands

Offshore – Informatica BDM Lead Developer

Infosys Technologies

Designed data models in SAP PowerDesigner based on business requirements.
Developed ETL mappings, workflows, and applications in Informatica BDM.
Deployed data model DDLs in Hive.
Built data audit framework scripts for deployment to higher environments and for scheduling batches.
Performed unit testing, created test documentation for ETLs, and worked with testers on ELT FAT fixes.
Ran a proof of concept to test various table file and compression formats in Hive for performance optimization.
Converted legacy ETL mappings from the native Informatica engine to run on the Hadoop Spark engine to improve performance.
Tuned and optimized performance.

Feb 2019 - Mar 2020

1 year 2 months

Australia

Offshore – SQL and SSIS Developer, Data Analyst

Infosys Technologies

Phase 1 of the migration project involved archiving and purging data from the HAMBS database (SQL Server) based on membership and claims cutoff dates to meet Australian GDPR requirements. Created SQL scripts for archiving and purging.
Phase 2 was migrating data from the HAMBS database to the CIVICA database (both SQL Server).
Analyzed HAMBS SQL Server tables to discover data and spot potential quality issues before migration.
Mapped data lineage between CIVICA and HAMBS tables and worked with business analysts to create mapping sheets.
Built and executed SSIS ETL packages to move data from HAMBS to CIVICA tables.
Optimized SQL query performance.
Supported and fixed issues logged by application users after migration.

Nov 2017 - Jan 2019

1 year 3 months

United Kingdom

Informatica Offshore Lead

Infosys Technologies

Developed ETL mappings, sessions, and workflows in Informatica PowerCenter for CIDA data loads to feed the data warehouse on Oracle.
Worked closely with data architects on design.
Tuned and optimized performance.
Ran unit testing and prepared test cases and test data.
Added new data sources and business logic to existing Informatica mappings.
Handled and resolved defects tracked in Quality Center.
Responded to business queries and performed data analysis.
Led a team of five offshore Informatica developers.
Ran a proof of concept for Informatica BDM as part of CBL's migration strategy to Informatica 10.1/BDM.

Mar 2017 - Nov 2017

9 months

United States

Informatica and SAP HANA Developer

Infosys Technologies

Worked on change requests related to Informatica ETL for populating sales, order, and inventory reports.
Handled business queries and incidents opened by end users.
Migrated existing reports from Informatica to SAP HANA by rewriting code and implementing existing logic in SAP HANA.
Created ETL mappings and workflows, and developed equivalent information models in SAP HANA.
Scheduled Informatica jobs for batch loads.
Performed performance tuning and code push-down to source and target databases (including Teradata).
Created and maintained aggregated tables in Teradata, which were populated through ETL and formed the basis for final reports.

Apr 2015 - Feb 2017

1 year 11 months

United Kingdom

SQL Developer

Infosys Technologies

Worked on production incidents and change requests related to Nationwide’s SQL Server–based CAW reporting platform.
Monitored and supported daily batch loads.
Analyzed data and responded to business queries.
Created SQL stored procedures to populate work and final tables.
Supported deployment activities.
Analyzed logged data defects in Quality Centre.
Scheduled daily batch loads and created DDL for tables in SQL Server.

Industry Experience

See where this freelancer has spent most of their professional time.

Experienced in Information Technology, Professional Services, and Insurance.

Information Technology

Professional Services

Insurance

Business Area Experience

See which departments and functions this freelancer has contributed to most.

Experienced in Business Intelligence, Information Technology, and Quality Assurance.

Business Intelligence

Information Technology

Quality Assurance

Summary

Over 13 years of experience in data engineering and ETL, with strong hands-on experience in Informatica BDM, Azure Data Factory, and SSIS.

Involved in various parts of data warehousing and data lake development, including gathering requirements, design, development, testing, deployment, and maintenance.

Solid understanding and experience in the full lifecycle of data warehousing and data lake projects. End-to-end data engineering and data architecture management.

Building data-driven ETL pipelines and data flows on Azure Cloud. Good understanding of Azure DevOps and CI/CD pipelines.

Experience working in Agile projects and big data environments.

Strong and extensive experience working with SQL and writing SQL queries.

Skills

Etl - Informatica Bdm, Informatica Powercenter, Ssis, Azure Data Factory
Sql Databases - Sql Server, Oracle, Teradata, Sap Hana, Informix Db
Nosql Databases - Mongodb
Cloud Technologies - Microsoft Azure Cloud (Azure Sql Database, Azure Data Lake, Azure Data Factory, Azure Databricks, Azure Devops, Azure Synapse)
Strong Sql And Advanced Sql Knowledge
Data Visualization - Power Bi, Sap Business Objects
Programming Languages - Python (With Pyspark)
Others - Hive, Jira, Confluence, Unix

Languages

English

Intermediate

Dutch

Elementary

Education

Oct 2004 - Jun 2008

Panjab University

Bachelor of Engineering, Computer Science and Engineering · Computer Science and Engineering · Chandigarh, India

Certifications & licenses

Infosys Certified Agile Developer

Microsoft Certified: Azure Data Engineer Associate (DP-203)

Microsoft Certified: Power BI Data Analyst Associate (PL-300)

Statistics

Experience

Total positions 7

Experience in Information Technology 8 y

Avg length 1 y 7 m

Longest experience 3 y 2 m

Global Experience

Countries worked in 4 (United Kingdom, Australia, Netherlands, United States)

Primary country United Kingdom

Expertise

Recent roles Data Engineer/Analyst, Onshore ETL Developer, Offshore – Informatica BDM Lead Developer

Main industries Information Technology, Professional Services, Insurance

Main business areas Business Intelligence, Information Technology, Quality Assurance

Qualifications

Highest degree Bachelor

Certifications earned 3

Profile

Created

November 2025

Need a freelancer? Find your match in seconds.

Try FRATCH GPT

Frequently asked questions

Have questions? Find more information here.

Where is Amandeep based?

Amandeep is based in Chandigarh, India and can operate in on-site, hybrid, and remote work models.

What languages does Amandeep speak?

Amandeep speaks the following languages: English (Intermediate), Dutch (Elementary).

How many years of experience does Amandeep have?

Amandeep has at least 11 years of experience. During this time, Amandeep has worked in at least 7 different roles and for 2 different companies. The average length of individual experience is 2 years and 7 months. Note that Amandeep may not have shared all experience and actually has more experience.

What roles would Amandeep be best suited for?

Based on recent experience, Amandeep would be well-suited for roles such as: Data Engineer/Analyst, Onshore ETL Developer, Offshore – Informatica BDM Lead Developer.

What is Amandeep's latest experience?

Amandeep's most recent position is Data Engineer/Analyst at Advance Delivery Consulting.

What companies has Amandeep worked for in recent years?

In recent years, Amandeep has worked for Advance Delivery Consulting and Infosys Technologies.

Which industries is Amandeep most experienced in?

Amandeep is most experienced in industries like Information Technology, Professional Services, and Insurance.

Which business areas is Amandeep most experienced in?

Amandeep is most experienced in business areas like Business Intelligence, Information Technology, and Quality Assurance.

Which industries has Amandeep worked in recently?

Amandeep has recently worked in industries like Professional Services and Information Technology.

Which business areas has Amandeep worked in recently?

Amandeep has recently worked in business areas like Business Intelligence, Information Technology, and Quality Assurance.

What is Amandeep's education?

Amandeep holds a Bachelor in Computer Science and Engineering from Panjab University.

Does Amandeep have any certificates?

Amandeep has 3 certificates. These include: Infosys Certified Agile Developer, Microsoft Certified: Azure Data Engineer Associate (DP-203), and Microsoft Certified: Power BI Data Analyst Associate (PL-300).

What is the availability of Amandeep?

Amandeep is immediately available full-time for suitable projects.

What is the rate of Amandeep?

Amandeep's rate depends on the specific project requirements. Please use the Meet button on the profile to schedule a meeting and discuss the details.