ETL Developer

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

Job Description

Role - ETL Developer

Experience Required - 7+ Years

Must Have Technical/Functional Skills

PL/SQL, UNIX Shell Script (Bash, Korn), Core Java, Perl. Informatica ETL development.

Roles & 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.

Base Salary Range : $100,000 to $125,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 & Parental 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.