Job Description

Job Type: Fulltime

Location: Phoenix, Arizona, United States, United States (Onsite)

Experience: 10+years

• 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.

#LI-RJ2

Salary Range - $130,000-$150,000 a year