Datastage Developer

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

Job summary

Tata Consultancy Services Limited in Charlotte, NC is seeking a seasoned DataStage Developer to design and implement robust ETL solutions using IBM DataStage and Oracle DB. The role requires deep expertise in SQL/PLSQL, data modeling, and performance tuning in large-scale enterprise environments.

Candidate will contribute to data integration initiatives, leverage CDC and data replication tools, and operate in a Linux/Unix and Python scripting environment. The position is full-time in Technology.

Qualifications

• 15+ years of experience in database development, data engineering, and enterprise data integration.
• Extensive Oracle DB expertise including SQL, PL/SQL, stored procedures, performance tuning and partitioning.
• Experienced in IBM DataStage ETL development, data integration and data migration.
• Strong data engineering background with ETL design, data movement and large-scale processing.
• Familiar with CDC, data replication, and data synchronization patterns.

Skills

DataStage

Oracle Database

SQL

PL/SQL

Stored procedures

Performance tuning

Linux/Unix scripting

Python scripting

Splunk

Dynatrace

CDC

Data modeling

Tools

CockroachDB

JIRA

Job description

DataStage Developer

Primary Skills

• IBM DataStage
• Oracle Database
• SQL and PL/SQL
• Stored procedures
• Performance tuning

Secondary Skills

• CockroachDB
• Agile/Scrum methodology
• JIRA and defect tracking tools
• Application support and incident management
• BFSI domain knowledge

Required Qualifications

• 15+ years of industry experience in database development, data engineering, and enterprise data integration.
• Senior-level, hands-on experience designing and developing database applications and data-intensive solutions using RDBMS technologies such as Oracle, DB2, and SingleStore (MemSQL).
• Significant experience with enterprise data modeling, logical and physical data design, and database architecture.
• Extensive experience and deep expertise with Oracle Database, including SQL, PL/SQL, stored procedures, performance tuning, query optimization, indexing, and partitioning strategies.
• Significant experience and proficiency with IBM DataStage ETL development, data integration, data transformation, and data migration initiatives.
• Strong background in data engineering, ETL design, data movement, and large-scale data processing solutions.
• Extensive experience with stored procedures, SQL, and PL/SQL development, including performance optimization and troubleshooting of complex database workloads.
• Experience with database modernization and migration projects involving large-scale enterprise data platforms.
• Strong understanding of Change Data Capture (CDC), data integration, and data synchronization patterns.
• Experience working in Linux/Unix environments, including shell scripting for automation, deployment, and operational support.
• Experience with Python-based scripting for data processing, automation, and operational tooling.
• Working knowledge of Splunk and Dynatrace for database monitoring, log analysis, troubleshooting, and performance monitoring.
• Knowledge of Oracle GoldenGate, IBM IIDR, or similar data replication technologies is a plus.
• Experience with CockroachDB or other distributed SQL databases is a plus.

Desired Qualifications

• Extensive experience with Oracle database design, development, performance tuning, and production support in large-scale enterprise environments.
• Experience with CockroachDB, distributed database architectures, and database migration initiatives is highly desirable.
• Experience with Agile, JIRA, and Scrum-based software development methodologies.
• Experience with data replication technologies such as IBM IIDR, Oracle GoldenGate, or equivalent CDC platforms is a plus.
• Experience supporting high-volume, mission-critical transactional systems with stringent performance and availability requirements.

Qualifications

• Knowledge and hands-on experience with Capital Markets / Primary Markets deal execution is strongly required (5+ years preferable).
• Strong understanding of New Issue, Book Building, and Syndication workflows in Fixed Income and Equities.
• Prior experience providing desk-aligned production support in a trading floor or capital markets environment.
• Excellent troubleshooting skills with the ability to resolve critical production issues quickly under pressure.
• Strong communication and relationship-building skills, with the ability to interact confidently with front-office users.
• Knowledge of bond fundamentals and capital markets execution processes is mandatory.
• Ability to document workflows, create knowledge repositories, and provide effective training.
• Highly organized and detail-oriented, with the ability to manage multiple issues and requests simultaneously.
• Prior experience with vendor platforms for deal execution, such as Ipreo, Primary Portal, or Dealogic, is a plus.

Salary Range- $110,000-$125,000 a year

Location: Charlotte, NC

Function: TECHNOLOGY

Role: Engineer

ID: 437989

Skills: DataStage

Salary Range: $110,000 - $125,000