EverestDX - Informatica Developer - ETL/SQL

EverestDX Inc; Hyderabad; On-site; INR 800,000 - 1,600,000; Full time

Job summary

EverestDX Inc in Hyderabad, India seeks an Informatica ETL specialist to design and optimize ETL workflows and lead data migrations from on‑premises to cloud.

Candidate should demonstrate hands‑on ETL/SQL experience, knowledge of PowerCenter/IDMC/IICS, and familiarity with cloud platforms. Strong data analysis and documentation skills are required.

Qualifications

• Hands-on experience with Informatica PowerCenter, IDMC and IICS.
• Strong SQL querying and database management.
• Experience in data migration projects (on‑premise to cloud).
• Strong data analysis skills for large datasets and ensuring accuracy.
• Solid understanding of ETL design & development concepts.
• Familiarity with cloud platforms (AWS, Azure).
• Experience with version control tools (Git) and deployment processes.
• Experience with data lakes, data warehousing, or big data platforms.
• Familiarity with Agile methodologies.
• Knowledge of other ETL tools.

Responsibilities

• Hands-on experience on ETL and SQL.
• Design, develop, and optimize ETL workflows using Informatica PowerCenter.
• Implement cloud-based ETL solutions using Informatica IDMC and IICS.
• Should have expertise on all transformations in Power Center and IDMC/IICS.
• Should have experience or knowledge on the PC to IICS migration using CDI PC tool or some other tool.
• Lead data migration projects, transitioning data from on‑premise to cloud environments.
• Write complex SQL queries and perform data validation and transformation.
• Conduct detailed data analysis to ensure accuracy and integrity of migrated data.
• Troubleshoot and optimize ETL processes for performance and error handling.
• Collaborate with cross‑functional teams to gather requirements and design solutions.
• Create and maintain documentation for ETL processes and system configurations.
• Implement industry best practices for data integration and performance tuning.

Skills

Informatica PowerCenter

IDMC

IICS

SQL

Data migration (on‑prem to cloud)

Data analysis

ETL design & development

Cloud AWS/Azure

Git

Tools

CDI PC tool

Job description

We are working on an opportunity where we require few Informatica candidates.

Responsibilities

• Candidate should have hands-on experience on ETL and SQL.
• Design, develop, and optimize ETL workflows using Informatica PowerCenter.
• Implement cloud-based ETL solutions using Informatica IDMC and IICS.
• Should have expertise on all transformations in Power Center and IDMC/IICS.
• Should have experience or knowledge on the PC to IICS migration using CDI PC tool or some other tool.
• Lead data migration projects, transitioning data from on‑premise to cloud environments.
• Write complex SQL queries and perform data validation and transformation.
• Conduct detailed data analysis to ensure accuracy and integrity of migrated data.
• Troubleshoot and optimize ETL processes for performance and error handling.
• Collaborate with cross‑functional teams to gather requirements and design solutions.
• Create and maintain documentation for ETL processes and system configurations.
• Implement industry best practices for data integration and performance tuning.

Required Skills

• Hands‑on experience with Informatica Power Center, IDMC and IICS.
• Strong expertise in writing complex SQL queries and database management.
• Experience in data migration projects (on‑premise to cloud).
• Strong data analysis skills for large datasets and ensuring accuracy.
• Solid understanding of ETL design & development concepts.
• Familiarity with cloud platforms (AWS, Azure).
• Experience with version control tools (e.g., Git) and deployment processes.

Preferred Skills

• Experience with data lakes, data warehousing, or big data platforms.
• Familiarity with Agile methodologies.
• Knowledge of other ETL tools.