Job Description
Must Have Technical/Functional Skills
Primary Skill: ETL Informatica Powercentre/IDMC
Secondary: Unix, Autosys, Oracle
Experience: Minimum 15 years
Roles & Responsibilities
Bachelor’s or master’s degree in computer science or related field.
ETL Informatica Lead to lead the design, development, and deployment of enterprise-scale data integration solutions. The ideal candidate will have strong hands-on expertise with Informatica PowerCenter, Informatica Intelligent Data Management Cloud (IDMC), Unix, Autosys, and Oracle, and will play a key role in requirements analysis, technical design, development, testing, deployment, and production support.
Key Responsibilities
Leadership & Delivery
- Lead end-to-end ETL solution delivery, including requirement analysis, design, development, deployment, and support.
- Serve as the technical lead for Informatica initiatives and mentor ETL developers.
- Coordinate with business analysts, architects, DBAs, and cross-functional teams.
- Perform design and code reviews to ensure best practices and standards are followed.
Requirements & Design
- Collaborate with business and analytics teams to understand data requirements and source-to-target mappings.
- Design scalable, high-performance ETL architectures and workflows.
- Define error handling, logging, reconciliation, and audit mechanisms.
- Prepare and review technical design documents and mapping specifications.
Development
- Develop and optimize ETL mappings, workflows, and sessions using Informatica PowerCenter and IDMC.
- Implement complex transformations, lookups, aggregations, and incremental loads.
- Tune ETL processes for performance and scalability.
- Develop Unix shell scripts for automation, monitoring, and file handling.
Scheduling & Automation
- Manage and support job scheduling using Autosys.
- Design restartable, dependency-driven workflows.
- Ensure SLA adherence and proactive failure handling.
Database & Performance
- Strong interaction with Oracle databases for data modeling, SQL tuning, and performance optimization.
- Analyze execution plans and improve SQL and ETL efficiency.
Deployment & Support
- Support ETL deployments across DEV, QA, UAT, and PROD environments.
- Participate in release planning, production cutovers, and post-deployment validation.
Provide L2/L3 production support, including root cause analysis and issue resolution.
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 Lea ve & Holidays.
Legal & Financial Assistance: Legal Assistance, 401K Plan, Performance Bonus, College Fund, Student Loan Refinancing.
Salary Range: $120,000 - $130,000 a year
Qualifications: BACHELOR OF COMPUTER SCIENCE
US
