5.0 - 10.0 years

8 - 12 Lacs

chennai, bengaluru

Work from Office

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.

Posted 2 days ago

Apply

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.