Data Scientist

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

Benefits offered by this job

Discretionary Annual Incentive

Comprehensive Medical Coverage

401K Plan

Certification & Training Reimbursement

Job summary

Tata Consultancy Services Limited, located in Charlotte, NC, seeks an experienced Informatica Developer/Data Engineer to design, build, and optimize ETL pipelines for high-volume data ingestion. The role emphasizes performance tuning, data modeling, and hands-on SQL across Oracle/Teradata/SQL Server, with production support responsibilities.

The candidate should have at least 10 years of experience, strong scripting abilities (Python, Shell), and familiarity with monitoring tools and cloud

Qualifications

• Minimum 10 years of experience in Informatica development and data integration.
• Strong SQL/PLSQL skills and data modeling experience.
• Experience with performance tuning for high-volume data ingestion.

Responsibilities

• ETL Pipeline Development: design and deploy mappings, sessions, and workflows with Informatica PowerCenter and Informatica Cloud.
• Data Integration: optimize SQL queries across Oracle, Teradata, SQL Server.
• Prod support: monitor environments, resolve incidents, RCA-driven improvements.
• Code deployments and migrations across Dev/SIT/UAT/Prod environments.
• Automation: Python/Shell scripting and Unix/Linux proficiency.

Skills

Informatica Developer

Informatica

IDMC

Hadoop

Oracle

Education

Bachelor of Computer Science

Tools

Jira

ServiceNow

Python

Shell

UNIX/Linux

Job description

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-$145,000 a year

Location

Charlotte, NC

Function

TECHNOLOGY

Role

Data Scientist

ID

430943

Skills

Data Science

Salary Range

$100,000 - $145,000

Desired Candidate Profile

Qualifications

BACHELOR OF COMPUTER SCIENCE