Post Job Free
Sign in

Data Integration Lead

Company:
Avance Consulting
Location:
Phoenix, AZ
Posted:
May 21, 2025
Apply

Description:

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.

Roles & Responsibilities:

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.

Please send your resume to

Apply