Tata Consultancy Services - ETL Informatica Developer

Data Engineer is needed in Charlotte, United States.

Client: Tata Consultancy Services

Location: Charlotte, NC

Contract: undefined

Job Description

The role is for a Technical Lead in Technology with expertise in Informatica development. The position requires the individual to handle both development and production responsibilities, working with a variety of tools and technologies to ensure high-performance data integration and pipeline management.

Requirements

Must Have Technical/Functional Skills:

• Primary Skill: Informatica Developer
• Secondary: Informatica, IDMC, Hadoop, and Oracle
• Experience: Minimum 10 years

Desired Candidate Profile:

• Qualifications: Bachelor of Computer Science

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 Production 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.

Additional Information

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

Location: Charlotte, NC

Job Function: TECHNOLOGY

Job Id: 421151

Desired Skills: Informatica | ETL Testing

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