ETL (Informatica) Lead/Architect

• 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

Do you have experience in Version control systems?, Must Have Technical/Functional Skills ETL Architect with Informatica expertise to design, develop, and optimize enterprise data integration solutions..

• Strong experience with Informatica PowerCenter

• Experience with Informatica IDMC and Google Cloud Platform (GCP)

• Expertise in ETL/ELT architecture and data warehousing concepts

• Strong SQL and database development skills

• Experience with databases such as:

Oracle Database Microsoft SQL Server DB2 Yellowbrick BigQuery

• Knowledge of data modeling techniques (Star Schema, Snowflake Schema)

• Experience with cloud platforms:

Google Cloud Informatica IDMC

• Familiarity with Unix/Linux shell scripting

• Knowledge of scheduling tools

• Understanding of DevOps, CI/CD, and version control

(part of Tata group) 3.93.9 out of 5 stars Phoenix, AZ $100,000 - $120,000 a year, Pulled from the full job description

• Pet insurance
• Health insurance
• Vision insurance
• Dental insurance
• Commuter assistance, Base Salary Range : $100,000 to $120,000 Per Annum TCS Employee Benefits Summary: Discretionary Annual Incentive. Comprehensive Medical Coverage: Medical & Health, Dental & Vision, Disability Planning & Insurance, Pet Insurance Plans. Family Support: Maternal & Pa rental Leaves. Insurance Options: Auto & Home Insurance, Identity Theft Protection. Convenience & Professional Growth: Commuter Benefits & Certification & Training Reimbursement. Time Off: Vacation, Time Off, Sick Leave & Holidays. Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.