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.