ETL Informatica Developer

Must Have Technical/Functional Skills

Primary Skill: Informatica Developer

Secondary: Informatica, IDMC, Hadoop and Oracle

Experience: Minimum 10 years

Roles & Responsibilities

Development Responsibilities

· ETL Pipeline Development: Design, build, and deploy robust ETL mappings, sessions, and workflows utilizing informatica PowerCenter and Informatica Cloud.

· Data Integration & Modeling: Develop and optimize complex SQL queries and PL/SQL scripts. Work with relational databases like Oracle, Teradata, or SQL Server to ingest and integrate data.

· Performance Tuning: Troubleshoot and resolve data bottlenecks; tune SQL queries and Informatica mappings for optimal performance and high-volume data ingestion.

Manage Prod RESPONSIBILITIES

· Monitor production environments, respond to alerts, and resolve technical issues, including tracking incidents against SLAs and preventing recurring issues through RCA.

· Debug Informatica, Spark, Oracle and Shell scripting code, analyze logs, and troubleshoot hardware/software issues.

· Maintain, document, and update system operating procedures, and provide performance reports.

· Assist with code deployments and migrations through environment stacks (Dev, SIT, UAT, Prod).

· Proficiency in Unix/Linux commands, SQL for database querying, performance tuning and scripting languages (e.g., Python, Shell) for automation.

· Experience with monitoring tools (e.g., Splunk, Datadog), ticketing systems (e.g., Jira, ServiceNow), and cloud platforms.

· Configuring session objects, optimizing Spark engines, and managing file descriptors for high-volume data ingestion.

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.

Salary Range: $100,000-$125,000 a year

Role: Technical Lead

Desired skills: Informatica | ETL Testing

Qualifications: BACHELOR OF COMPUTER SCIENCE

• Experience: 10 - 15 Years

• Job function: TECHNOLOGY

• Location: Charlotte, NC

Salary range: $100,000–$125,000

Apply by: 2026-09-04 00:00:00