ETL Developer

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.