SQL Developer

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

Benefits offered by this job

Discretionary Annual Incentive

Comprehensive Medical Coverage

Family Support: Parental Leaves

Auto & Home Insurance options

Commuter Benefits

Certification & Training Reimbursement

Vacation, Time Off, Holidays

401K Plan

Performance Bonus

Job summary

Tata Consultancy Services in Charlotte, NC is seeking an experienced SQL Developer with Informatica expertise to design, develop, and support enterprise data integration and data warehousing solutions.

The ideal candidate will have hands‑on SQL development, ETL processes, data modeling, and Informatica PowerCenter/IDMC within a large‑scale enterprise environment.

Qualifications

• Minimum 10 years of experience in SQL development and data warehousing.
• Hands-on experience with ETL processes using Informatica PowerCenter/IDMC.
• Strong analytical, modeling, and design skills for enterprise data solutions.

Responsibilities

• Design, develop, test, and maintain complex SQL queries, stored procedures, functions, and views.
• Develop and support ETL workflows using Informatica PowerCenter and IDMC.
• Translate business requirements into technical data solutions.
• Perform ETL from multiple source systems and optimize performance.
• Collaborate with analysts, data architects, and application teams.
• Implement data validation, reconciliation, and quality checks.
• Support deployments and resolve production incidents.
• Create technical design docs and runbooks.
• Participate in data migration, modernization, and cloud initiatives.
• CI/CD deployments and Git/Bitbucket experience.

Skills

SQL

PL/SQL

Informatica

Education

Bachelor of Computer Science

Tools

Git/Bitbucket

Job description

Job Description

Must Have Technical/Functional Skills

Primary Skill: SQL ,PL/SQL

Secondary: Informatica

Experience: Minimum 10 years

Roles & Responsibilities

We are seeking an experienced SQL Developer with Informatica expertise to design, develop, and support enterprise data integration and data warehousing solutions. The ideal candidate should have strong hands‑on experience in SQL development, ETL processes, data modeling, and Informatica PowerCenter/IDMC within a large-scale enterprise environment.

Key Responsibilities

• Design, develop, test, and maintain complex SQL queries, stored procedures, functions, views, and database objects.
• Develop and support ETL workflows using Informatica PowerCenter and/or Informatica Intelligent Data Management Cloud (IDMC).
• Analyze business requirements and translate them into technical data solutions.
• Perform data extraction, transformation, and loading (ETL) activities from multiple source systems.
• Optimize database performance through query tuning and indexing strategies.
• Troubleshoot ETL failures, data quality issues, and performance bottlenecks.
• Collaborate with business analysts, data architects, and application teams to deliver data integration solutions.
• Implement data validation, reconciliation, and quality checks.
• Support production deployments and resolve production incidents.
• Create and maintain technical design documentation and operational runbooks.
• Participate in data migration, modernization, and cloud transformation initiatives.
• CI/CD deployments
• Experience in Git/Bitbucket

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

Qualifications

BACHELOR OF COMPUTER SCIENCE