Senior Data Scientist — ETL & Informatica Expert

Tata Consultancy Services; Charlotte (NC); On-site; USD 100,000 - 145,000; Full time

Benefits offered by this job

Discretionary Annual Incentive

Medical Coverage

Family Support Leaves

Auto & Home Insurance

Commuter Benefits

Certification & Training Reimbursement

Vacation Time

Legal & Financial Assistance

401K Plan

Performance Bonus

College Fund

Student Loan Refinancing

Job summary

Tata Consultancy Services in Charlotte, NC seeks an experienced Informatica Developer with 10+ years in ETL and data integration. You will design and optimize data pipelines using Informatica PowerCenter and Informatica Cloud, and work with Oracle/ Teradata environments to ensure robust ingestion and performance.

Responsibilities include production monitoring, debugging across Informatica, Spark, Oracle, and shell scripts, plus deployments across Dev to Prod stacks.

Qualifications

• Minimum 10 years of experience in ETL development and data integration.
• Design, build, and deploy ETL mappings, sessions, and workflows using Informatica PowerCenter and Informatica Cloud.
• Expertise in SQL/PL-SQL, databases such as Oracle, Teradata, and SQL Server; optimize data ingestion and performance.

Responsibilities

• Monitor and troubleshoot production ETL jobs and data pipelines.
• Debug Informatica mappings, Spark tasks, Oracle scripts, and shell scripts.
• Maintain operating procedures and generate performance reports.
• Assist with deployments and migrations across Dev, SIT, UAT, Prod environments.
• Use Unix/Linux commands, SQL, and scripting (Python, Shell) for automation.
• Utilize monitoring tools (e.g., Splunk, Datadog) and ticketing systems (e.g., Jira).
• Configure session objects and optimize Spark engines for high-volume ingestion.

Skills

Informatica Developer

Informatica

IDMC

Hadoop

Oracle

Education

Bachelor of Computer Science

Tools

SQL

PL/SQL

Oracle

Teradata

SQL Server

Unix

Shell

Python

Job description

Tata Consultancy Services in Charlotte, NC seeks an experienced Informatica Developer with 10+ years in ETL and data integration. You will design and optimize data pipelines using Informatica PowerCenter and Informatica Cloud, and work with Oracle/ Teradata environments to ensure robust ingestion and performance.

Responsibilities include production monitoring, debugging across Informatica, Spark, Oracle, and shell scripts, plus deployments across Dev to Prod stacks.