Informatica ETL Lead Architect — Cloud Data Warehouse

Tata Consultancy Services; Phoenix (AZ); Presencial; USD 100.000 - 125.000; Jornada completa

Ventajas ofrecidas por este puesto de trabajo

Annual Incentive

Medical Coverage

Family Leave

Insurance Options

Commuter Benefits

Training Reimbursement

Paid Time Off

401K Plan

Performance Bonus

Descripción de la vacante

Tata Consultancy Services is seeking an ETL (Informatica) Lead/Architect to design, develop, and optimize enterprise data integration solutions. The role requires deep Informatica PowerCenter expertise and strong SQL skills to support data warehousing initiatives.

You will lead architectural design, collaborate with DBAs and product teams, and guide migration and modernization efforts across on-prem and cloud environments.

Formación

• 8+ years of ETL/architect experience.
• Expert in Informatica PowerCenter and IDMC.
• Strong SQL and database development skills.
• Experience with Oracle, SQL Server, DB2, Yellowbrick, and BigQuery.
• Familiarity with Unix/Linux shell scripting.
• Knowledge of scheduling tools and DevOps practices.
• Understanding of data warehousing concepts.

Responsabilidades

• Design and implement scalable ETL solutions using Informatica PowerCenter.
• Develop enterprise data integration architecture and data migration strategies.
• Analyze source systems and create efficient data mapping and transformation logic.
• Build and maintain data pipelines for data warehouses and analytics platforms.
• Optimize ETL performance, scalability, and reliability.
• Collaborate with Product Teams, DBAs, and application teams.
• Implement data quality, governance, and security standards.
• Troubleshoot ETL failures, data discrepancies, and production issues.
• Create technical design documents, architecture diagrams, and best practices.
• Lead code reviews, deployment planning, and ETL framework improvements.
• Support cloud migration and modernization initiatives.

Conocimientos

ETL Architecture

Data Warehousing

SQL & DB Development

Unix/Linux scripting

DevOps / CI-CD

Version Control

Cloud platforms

Herramientas

Informatica PowerCenter

Informatica IDMC

Google Cloud Platform

BigQuery

Oracle Database

Microsoft SQL Server

DB2

Yellowbrick

Descripción del empleo

Tata Consultancy Services is seeking an ETL (Informatica) Lead/Architect to design, develop, and optimize enterprise data integration solutions. The role requires deep Informatica PowerCenter expertise and strong SQL skills to support data warehousing initiatives.

You will lead architectural design, collaborate with DBAs and product teams, and guide migration and modernization efforts across on-prem and cloud environments.