ETL Developer(Informatica & IDMC)
Summary
Builds and maintains ETL/ELT pipelines using Informatica PowerCenter and IDMC, ensuring data flows smoothly into warehouses and cloud platforms.
- Location: Gurugram/Noida
- JD:
- Required Skills:
- Hands-on experience with Informatica PowerCenter and Informatica Intelligent Data Management Cloud (IDMC/IICS).
- Experience in designing, developing, and maintaining ETL/ELT pipelines using IDMC services such as Data Integration, Mass Ingestion, Cloud Data Integration, Cloud Application Integration, and Data Quality.
- Exposure to cloud platforms like AWS, Azure, or GCP.
- Strong SQL skills with experience in writing complex queries and performance tuning.
- Solid understanding of data warehousing concepts and dimensional modeling.
- Strong hold on end-to-end data flow understanding.
- Implement data validation, reconciliation, and error-handling mechanisms.
- Experience with job scheduling tools and UNIX/Linux shell scripting.
- Familiarity with version control systems (Git/SVN) and Agile methodologies.
-
Excellent problem-solving and analytical skills.
Preferred Skills:
- Experience in cloud data migration and modernization projects using Informatica IDMC.
- Integration experience with BI tools like Power BI.
- Knowledge of big data technologies (Hadoop, PySpark).
- Experience with Python or Java for scripting and automation.
- Understanding of metadata management, data lineage, and data governance concepts.
- Exposure to Informatica Data Quality (IDQ), Master Data Management (MDM), and Cloud Data Governance & Catalog (CDGC) within the IDMC ecosystem