Develop complex Informatica ETL mappings and workflows extracting data from various heterogeneous source systems like Flat files, DB2, and Postgres SQL. Create reusable transformations, mapplets, workflows, worklets using Informatica PowerCenter.
Numbers & Facts
Location
Jersey City, NJ (Remote)
Description
Develop complex Informatica ETL mappings and workflows extracting data from various heterogeneous source systems like Flat files, DB2, and Postgres SQL
Create reusable transformations, mapplets, workflows, worklets using Informatica PowerCenter
Implementing versioning of the ETL repository and supporting code as necessary
Usage of AI Tool to generate ETL mappings
Data Conversion experience is preferred
Performance tuning as needed
Extensive knowledge of coding languages, including Python and SQL
Proficiency in warehousing architecture techniques, including MOLAP, ROLAP, ODS, DM, and EDW
Proven work experience as an ETL developer
Strong project management skills
Ability to analyze a company’s big-picture data needs
Clear communication skills
Ability to troubleshoot and solve complex technical problems