Profileimage by AMANDEEP SINGH Informatica PowerCenter and BDM data engineer from



Last update: 06.09.2022

Informatica PowerCenter and BDM data engineer

Graduation: Bachelor of Engineering in Computer Science
Hourly-/Daily rates: show
Languages: English (Native or Bilingual) | Hindi (Native or Bilingual)




- Data engineer with over 10 years of work experience and expertise of working in datawarehousing and reporting projects and using ETL tools like Informatica 
- Worked on both Informatica PowerCenter and Informatica BDM
- Strong SQL skills
- Exposure of working in Big data environment
- Exposure of working in Agile projects
- Good knowledge of cloud and Azure
- Worked on SAP HANA and SAP BO

Project history

09/2020 - 09/2020
Onshore developer - Informatica BDM, Hive, Teradata
Customer : Nationwide Building Society(UK)
Role : Onshore developer - Informatica BDM, Hive, Teradata
Project Name : BCBS 239
Project Type : Development
Industry : Banking
Tools : Informatica BDM, Teradata, Hive

* Liaised with business analysts and designers to develop prototype ETL mappings in Informatica
BDM for calculation of regulatory metrics.
* Industrialized the prototype mappings.
* The mappings involved moving the date from Hadoop HDFS to Teradata layers.
* For mappings involving Hadoop HDFS to Teradata data movement, optimized the code by making it
Blaze engine compatible.
* For mappings involving data movement from one layer of Teradata to another, optimized the code
by making it pushdown compatible.
* Created applications for code promotions to higher environments.
* Supported and worked on production incidents and defects.
* Code propagation to higher environments.

09/2020 - 09/2020
Informatica offshore lead
Close Brothers Limited
Project Name : CIDA reporting
Project Type : Development
Industry : Banking
Tools : Informatica PowerCenter, SAP BO

* Developing ETL mappings, sessions and workflow in Informatica Power Center for
CIDA data loads.
* Closely working with data architects on design aspects.
* Performance tuning and optimization.
* Unit testing and preparation of test cases and test data.
* Incorporating any new data sources and/or business logic into existing Informatica mappings.
* Working on and closing defects raised in Quality Center.
* Handling business queries and data analysis.
* Leading a team of 5 Informatica developers at offshore.
* Did POC on Informatica BDM, as part of CBL's strategy for migrating to Informatica 10.1/BDM.

09/2020 - 09/2020
Informatica and SAP HANA developer
John Deere
Project Name : CGC reporting (Sales, Order and Inventory dashboards)
Project Type : Development cum support
Industry : Manufacturing
Tools : Informatica PowerCenter, SAP HANA


* Worked on change requests related to Informatica ETL for populating Sales, Order and inventory
* Worked on business queries and incidents opened by end users.
* Project involved migrating exisiting reports from Informatica to SAP HANA, by re-writing the
existing code and implementing existing logic in SAP HANA.
* Created ETL mappings and workflows, and also created equivalent information models in SAP
* Scheduled Informatica jobs for batch loads.
* Performance tuning and code push down to source and target databases (both in Teradata).
* Created and maintained aggregated tables in Teradata (target database), which were populated
through ETL and on which the final reports were based.

09/2020 - 09/2020
SQL developer
Nationwide Building Society
Project Name : CAW reporting
Project Type : Development and support
Industry : Banking
Tools : SQL server, Unix


* Worked on production incidents and change requests related to Nationwide's SQL server based
CAW reporting platform.
* Monitored and support daily batch loads.
* Analysed the data and responded to business queries raised.
* Created SQL stored procedures to populate work and final tables.
* Supported deployment activities.
* Analysed the logged data defects in Quality Centre.
* Scheduled daily batch loads.
* Created DDL for table created in SQL server.

Local Availability

Only available for the countries India
Flexible for relocating.
Profileimage by AMANDEEP SINGH Informatica PowerCenter and BDM data engineer from Informatica PowerCenter and BDM data engineer