ETL Informatica Developer

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

Job summary

Tata Consultancy Services is seeking an experienced Informatica Developer to lead ETL development and data integration efforts for complex environments in North Carolina. You will design robust mappings and workflows using Informatica PowerCenter and Informatica Cloud, optimize SQL/PLSQL queries, and ensure high-volume data ingestion with performance tuning.

Responsibilities include production monitoring, incident resolution, deployments across environments, and maintaining procedures.

Qualifications

• Minimum 10 years of experience in ETL development and data integration.

Responsibilities

• ETL Pipeline Development: Design, build, and deploy robust mappings and workflows using Informatica PowerCenter and Informatica Cloud.
• Data Integration & Modeling: Develop and optimize SQL/PLSQL; work with Oracle, Teradata, or SQL Server.
• Performance Tuning: Troubleshoot bottlenecks; tune queries and mappings for high-volume ingestion.
• Monitor production environments, respond to alerts, and resolve issues; track incidents against SLAs.
• Debug Informatica, Spark, Oracle and Shell scripts; analyze logs and resolve issues.
• Maintain and update operating procedures; provide performance reports.
• Assist with deployments and migrations across Dev/SIT/UAT/Prod environments.

Skills

Informatica Developer

Informatica

IDMC

Hadoop

Oracle

Education

Bachelor of Computer Science

Tools

Informatica PowerCenter

Informatica Cloud

SQL

PL/SQL

Unix/Linux

Python

Shell

Spark

Jira

ServiceNow

Splunk

Datadog

Job description

Must Have Technical/Functional Skills

Primary Skill: Informatica Developer

Secondary: Informatica, IDMC, Hadoop and Oracle

Experience: Minimum 10 years

Roles & 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

Qualifications

BACHELOR OF COMPUTER SCIENCE