Tata Consultancy Services
Phoenix, United States
Salary : 15,500 - 19000
- 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