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.