Data Integration Lead

Lead the migration of SSIS or any other ETL tool to Informatica Cloud Services (IICS / IDMC).

Participates in ETL Design of new or changing mappings and workflows with the team and prepares technical specifications.

Analyzing data integration requirements, analyzing data sources and targets, business rules, and transformation logic.

Oversee the integration of various data sources using ETL processes.

Perform data analysis and profiling to identify data quality issues and develop strategies for data cleansing and transformation.

Collaborate with cross-functional teams to understand and address data requirements.

Ensure data accuracy and consistency across all systems.

Essential Skills -

10+ years of experience in Informatica ETL Design and Architecture, Data Analysis & Data Management.

Demonstrated expertise in designing and implementing data architecture solutions using Informatica Cloud and Azure.

Implemented an Informatica based ETL solution fulfilling stringent performance requirements.

Experience in designing and implementing ETL processes; understanding of data models and data flows.

SQL Server working experience including designing, optimizing complex SQL queries and correlated sub-queries on large scale data tables.

Should have hands-on working experience in Informatica Cloud Services (IICS / IDMC) components - Data Integration, Application Integration, Data Quality.

Experience in implementing ETL data pipelines for moving data from on-premises to Azure Data Lake.

Experience in MDM and its implementations.

Experience in leading technical development teams.

Experience in with Agile project methodologies.

Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.