No. of Resource:- 01
Availability:- Immediate
Location:- Dubai
Industry:- Real Estate
Email:- hr@staffconnect.ae
WhatsApp:- +971 529421270
Job Description:
Experienced Informatica IDMC Developer with 6+ years in data integration and real-time data solutions. Skilled in designing end-to-end data pipelines using IDMC for effective migration and transformation across cloud platforms. The ideal candidate will have in-depth knowledge of Informatica Intelligent Data Management Cloud (IDMC), specifically Cloud Data Integration (CDI) and Cloud Data Integration – Real-Time (CDIR)/Cloud Mass Ingestion (CMI). A strong foundation in Data Warehousing concepts and proficiency in Snowflake and SQL is essential. Strong team player with agile experience, delivering timely, high-impact data solutions.
Technical Skills:
⦁ Tools: Informatica Cloud Data Integration, Real-Time Integration (CDIR)
⦁ Data Warehousing: Snowflake, DataLake
⦁ Programming: SQL, PL/SQL, Python
⦁ Data Management: Storage management, quality monitoring, governance
⦁ Modeling: Dimensional modeling, star/snowflake schema
⦁ Other Tools: Git, JIRA, Confluence
Core Competencies:
⦁ Builds and optimizes ETL/ELT pipelines with IDMC and Snowflake for batch and real-time transformations.
⦁ Design, develop, and implement ETL/ELT processes using Informatica IDMC tools (CDI, CDIR/CMI).
⦁ Extract data from various sources, including relational databases, APIs, and flat files.
⦁ Collaborate with stakeholders to gather requirements and translate them into robust ETL workflows.
⦁ Integrate and transform data to populate Snowflake data warehouses and other storage systems.
⦁ Leverage Oracle Fusion data extraction techniques for seamless integration.
⦁ Maintain and optimize ETL performance, including error handling and data quality assurance.
⦁ Document technical specifications, workflows, and processes for future reference.
⦁ Collaborate with cross-functional teams to ensure alignment with business objectives.
⦁ Proficient in troubleshooting and optimizing data pipelines for performance and reliability.
Professional Experience:
1. Informatica Developer
⦁ Developed ELT processes using IDMC to integrate data into Snowflake.
⦁ Implemented storage management for Azure Blob and Snowflake, enhancing data security.
⦁ Established automated data quality monitoring for accuracy and completeness.
2. Real-Time/Near-Realtime Data Integration Specialist
⦁ Led Snowflake projects with real-time data pipelines and IDMC integration.
⦁ Built data quality frameworks and automated cleansing routines.
⦁ Managed real-time and batch data flows, ensuring data consistency for analytics.