Informatica/ IICS/ Azure data engineer

1. IDMC (Informatica Data management cloud) – Specifically IICS, CDQ, CAI

2. Azure Synapse/ SQL Server

3. Data lake/ Data warehousing

Experience : 8+ years

Required Skills : Azure Data Lake and warehousing concepts, Proficient in SQL, stored procs (Sql Server/ Synapse), ETL experience using Informatica IDMC products like cloud data integration, cloud data quality, CAI, CMI etc.; data governance experience, experience with best practices for auditing, exception handling, scalable data flow creation; experience in cloud technology (preferred is Azure), Github and Jira experience

Nice to have skills : Python, Databricks and experience working with HDFS and Hive, Snowflake

Roles & Responsibilities : * Strong in Informatica cloud product like IICS, CDQ, CAI etc. and SQL (Synapse/ SQL Server). Data migration will be to Azure cloud so prior knowledge or hands on with cloud will be an added advantage** Requirement analysis for Data Integration** Design ETL design documents and develop jobs as per the requirement** Design the incremental and historical load strategy** Ensures adherence to Chubb standards, policies and quality compliance, enterprise metadata definition** Coordinates with ETL Lead and performs following activities: Build ETL components and Unit testing & Support System integration testing** Issue Clarification & Resolution** Unit test cases preparation and testing** Test case results** Update JIRA at the user story level every day and drive it to completion** Resolve all the technical impediments like requirement dependency, data dependency, environments down, etc.** UAT / QA support

Last updated on Aug 3, 2023