About the role
Informatica Developer / ETL Developer
Design, develop, and maintain ETL pipelines using Informatica PowerCenter (or IICS/IDMC), ensuring high data quality, performance tuning, and collaboration with stakeholders to support data warehousing and analytics efforts +15ResumeCat+15Expertia+15Reddit.
Key Responsibilities- Develop ETL workflows, mappings, sessions, and task flows in Informatica PowerCenter or Cloud Expertia++3Jooble+3.
- Extract, transform, and load data from sources (Oracle, SQL Server, flat files, Hadoop, cloud storage, etc.) into target systems or data warehouses iitjobs+4ResumeCat++4.
- Perform data profiling, cleansing, and validation to ensure data accuracy and integrity Indeed+8Institute of Data+8Expertia+8.
- Optimize ETL processes and SQL for performance (e.g., session tuning or SQL query optimization) Jooble+7Adaface+7Virtusa+7.
- Implement error handling, recovery strategies, and monitor workflows in production .
- Collaborate with business/data analysts, architects, and engineers to gather requirements and translate them into data solutions Reddit+15ResumeCat+15Indeed+15.
- Write and maintain technical documentation (HLDs, LLDs, technical spec, and unit-test cases) .
- Troubleshoot production issues and provide timely support .
- Stay current with evolving Informatica capabilities and best practices Reddit+15Jooble+15iitjobs+15.
- Bachelor’s degree in Computer Science, IT, or related field iitjobs.
- 3+ years of ETL development experience using Informatica PowerCenter or Cloud products Reddit+15Jooble+15Virtusa+15.
- Strong SQL skills and experience with databases like Oracle, SQL Server, DB2 Reddit+11ResumeCat+11Virtusa+11.
- Experience in data warehousing, data modeling (e.g., star/snowflake schemas) Reddit+12ResumeCat+12Institute of Data+12.
- Proficiency in performance tuning—ETL mappings and SQL .
- Familiarity with UNIX/Linux shell scripting for task automation Jooble+3ResumeCat+3Virtusa+3.
- Excellent analytical, problem-solving, and communication skills .
- Experience with cloud ETL integration (e.g., Snowflake, Databricks, AWS S3) .
- Knowledge of Big Data/BDM, Hadoop, Spark, Hive, etc. Reddit.
- Familiarity with scheduling tools like Control-M, Autosys, Airflow .
- Certification in Informatica (PowerCenter, IICS, IDMC) or in data governance Reddit+7iitjobs+7Expertia+7.
- Shell scripting or Python skills for automation .
- Experience in Unix/Linux, and optionally PLSQL/Oracle tuning .