Informatica PowerCenter and BDM data engineer

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


Responsibilities:
* 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.

Project Name : CIDA reporting
Project Type : Development
Industry : Banking
Tools : Informatica PowerCenter, SAP BO

Responsibilities:
* 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.

Project Name : CGC reporting (Sales, Order and Inventory dashboards)
Project Type : Development cum support
Industry : Manufacturing
Tools : Informatica PowerCenter, SAP HANA

Responsibilities:

* Worked on change requests related to Informatica ETL for populating Sales, Order and inventory
reports.
* 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
HANA.
* 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.

Project Name : CAW reporting
Project Type : Development and support
Industry : Banking
Tools : SQL server, Unix

Responsibilities:

* 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.