Seeking an experienced ETL Developer with 5+ years of expertise in Informatica development and ETL processes, including migration from Talend or DataStage to Informatica. Must have a strong understanding of data warehousing concepts, data lake house architecture, and hands-on experience with Amazon Redshift. The role involves designing, developing, and optimizing ETL workflows using Informatica PowerCenter and/or Cloud, writing complex SQL queries, and ensuring performance, scalability, and data integrity. Proficiency in troubleshooting, performance tuning, and issue resolution is required.
Experience in migrating the ETL from Talend or Datastage to Informatica.
Good understanding of Data warehousing.
Good knowledge on Redshift as the database.
Extensive experience in writing and optimizing complex SQL queries, primarily in Amazon Redshift.
Minimum of 5+ relevant years of experience in Informatica development and ETL processes.
Strong expertise in designing, developing, and maintaining ETL workflows and processes using Informatica PowerCenter and/or Cloud.
Deep understanding of data warehousing concepts, including architecture, design, and implementation.
Solid experience with data lake house architecture and its integration with ETL processes.
Ability to work with and support complex data systems, ensuring performance, scalability, and data integrity.
Proficiency in troubleshooting, performance tuning, and resolving issues within ETL
workflows.
Informatica ETL developer(Informatica ETL, SQL, Migration, Redshift),ETL Migration, Data Warehousing, Amazon Redshift, Informatica Development, ETL Processes, Informatica PowerCenter, Informatica Cloud, Complex SQL Queries, Data Lake House Architecture, Performance Tuning, Troubleshooting