Engineer

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: $110,000 - $120,000 a year

</div

Role: Engineer

Desired skills: Informatica | Unix

Qualifications: BACHELOR OF COMPUTER SCIENCE

• Experience: 15 - 17 Years

• Job function: TECHNOLOGY

• Location: Addison, TX

Salary range: $110,000–$120,000

Apply by: 2026-09-14 00:00:00