Technical Architect

Location: Phoenix, AZ
Experience: 10 Years

• Business Domain Retail
• Digital Informatica Data Quality (IDQ), Informatica Cloud Data Integration (CDI)

We are seeking an experienced Technical Architect to lead the migration of SSIS or other ETL tools to Informatica Cloud Services (IICS/IDMC). The role involves designing and implementing ETL solutions, ensuring data accuracy, quality, and consistency across systems, and collaborating with cross-functional teams to address data integration requirements.

• Lead the migration of SSIS or other ETL tools to Informatica Cloud Services (IICS/IDMC).
• Design and develop ETL solutions, including new mappings and workflows.
• Analyze data integration requirements, data sources, targets, business rules, and transformation logic.
• Oversee data integration from multiple sources using ETL processes.
• Perform data analysis and profiling to identify quality issues and implement cleansing/transformation strategies.
• Collaborate with cross-functional teams to understand and address data needs.
• Ensure data accuracy, consistency, and performance optimization across systems.

• 10 years of experience in Informatica ETL Design, Data Analysis, and Data Management.
• Expertise in designing and implementing data architecture solutions using Informatica Cloud and Azure.
• Proven experience implementing high-performance ETL solutions.
• Strong knowledge of ETL process design, data models, and data flow.
• Proficiency in SQL Server, including optimizing complex queries and handling large-scale data tables.
• Hands-on experience with Informatica Cloud Services (IICS/IDMC) components Data Integration, Application Integration, and Data Quality.
• Experience in implementing ETL pipelines for on-premises to Azure Data Lake migration.
• Master Data Management (MDM) implementation experience.
• Experience leading technical development teams.
• Familiarity with Agile project methodologies.

• Strong background in MDM implementation.
• Experience managing technical development teams.
• Agile methodology expertise.