ETL Developer

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.

Qualifications

• Must Have Technical/Functional Skills: PL/SQL, UNIX Shell Script (Bash, Korn), Core Java, Perl. Informatica ETL development.

Pay

Base Salary Range : $100,000 to $125,000 Per Annum

Benefits

• 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