* 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 - $120,000-$140,000 a year
Job Type
Fulltime role
Skills required
Azure, Agile
Location
Phoenix, Arizona
Salary
$98,425 - $118,109
Date Posted
May 29, 2025
TCS is seeking a Data Integration Lead with over 10 years of experience in Informatica ETL Design and Architecture to lead data integration projects in Phoenix, Arizona. The role involves designing ETL processes and ensuring data quality across systems.