Informatica Lead with Data Integration

Position: Informatica Lead with lead Data Integration

Location: Phoenix, AZ or Remote

Duration: Fulltime Permanent

Onsite/Remote

Years of exp Required: 9-14 Years

Must Have Technical/Functional 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.

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.
• (Optional) Work on Tableau integration and API-based custom reporting solutions.