Etl Developer

Role & responsibilities

• Performing

  data migration activities

  using Informatica (ETL tools), participating in multiple workshops to understand data structures, and analyse new system data requirements.
• Understanding source and target applications, and how the migration will fit into the new system.
• Working closely with Data, Business, and Technology teams to create, unit test and support integration workflows and mappings using IICS/IDMC. This includes, but not limited to, use of mapplets, rule specifications, joins, task flows, and parameters within Data Quality, and ETL frameworks.
• Working with Data Analysts to understand source systems data quality issues and the technical requirements of the source to target mappings; designing jobs with Informatica best practices (including but not limited to performance, efficiency, scalability, re-usability, transformations).
• Ensure data accuracy, integrity, and security in all data integration activities.
• Write T-SQL queries and scripts for data transformation and validation; performance tuning and optimization of ETL processes.
• Develop shell scripts for automation and orchestration.
• Document technical mappings, mapplets and rules in detail, as required..

Preferred candidate profile

• 5+ yrs experience understanding of ETL concepts and methodologies; and a strong functional understanding of RDBMS.
• Proficient in T-SQL & Python for data manipulation and validation; and experience with performance tuning / optimization of ETL processes.
• Excellent problem-solving and troubleshooting skills.
• Experience using, configuring, and scheduling Control-M jobs.
• Experience in large data migration programs is highly desired.
• Experience in financial services is highly desired, in particular, retail & business banking product data, and data models.
• Ability to work collaboratively, and independently, with various teams in a dynamic development environment and determine solutions that meet business, technology, and data requirements.
• 5+ years of experience on ETL Tools like Informatica cloud, IICS & Informatica PowerCenter is highly desired. ETL tool certifications preferred.