Senior ETL Developer - Informatica & SQL

Tata Consultancy Services; Phoenix (AZ); On-site; USD 100,000 - 125,000; Full time

Job summary

Tata Consultancy Services seeks an ETL Developer with 7+ years of experience to design, build, and optimize ETL workflows using Informatica PowerCenter. You will implement PL/SQL, Unix shell scripts, and Core Java to support data integration across warehouses and marts.

Collaborate with analysts and DBAs, ensure data quality, and support deployments across development, QA, and production environments following SDLC and Agile practices.

Qualifications

• Proficient in PL/SQL development and optimisation.
• Strong UNIX shell scripting abilities (Bash, Korn).
• Experience with Java programming for ETL support and automation.
• Informatica ETL development experience in data warehousing.
• Familiarity with data warehousing and data mart concepts.

Responsibilities

• Design, develop, and maintain ETL workflows, mappings, sessions, and workflows using Informatica PowerCenter to support enterprise data integration.
• Develop and optimize PL/SQL packages, procedures, functions, and complex SQL queries to support ETL processing and business requirements.
• Extract, transform, and load data from multiple source systems into data warehouses and data marts while ensuring data accuracy and integrity.
• Perform ETL performance tuning by optimizing mappings, SQL queries, partitioning, indexing, and workflow execution.
• Collaborate with business analysts, data architects, and database teams to gather requirements and implement scalable ETL solutions.
• Develop and implement data quality validations, error handling, reconciliation, and exception management within ETL processes.
• Support ETL deployments across Development, QA, and Production environments, including code migration, testing, and production support.
• Troubleshoot ETL failures, analyze production issues, perform root cause analysis, and maintain technical documentation following SDLC and Agile methodologies.

Skills

PL/SQL

Unix shell scripting

Core Java

Perl

Tools

Informatica PowerCenter

Job description

Tata Consultancy Services seeks an ETL Developer with 7+ years of experience to design, build, and optimize ETL workflows using Informatica PowerCenter. You will implement PL/SQL, Unix shell scripts, and Core Java to support data integration across warehouses and marts.

Collaborate with analysts and DBAs, ensure data quality, and support deployments across development, QA, and production environments following SDLC and Agile practices.