DataStage Developer

Job Description

Role : DataStage Developer

\n

Location: Addison, TX / Charlotte, NC

\n

Duration: Fulltime Role

\n

\n

DataStage Developer

\n

Primary Skills

\n

\n
• IBM DataStage

\n

• Oracle Database

\n

• SQL and PL/SQL

\n

• Stored procedures

\n

• Performance tuning

\n

\n

Secondary Skills

\n

\n
• CockroachDB

\n

• Agile/Scrum methodology

\n

• JIRA and defect tracking tools

\n

• Application support and incident management

\n

• BFSI domain knowledge

\n

\n

Required Qualifications

\n

\n
• 15+ years of industry experience in database development, data engineering, and enterprise data integration.

\n

• Senior-level, hands-on experience designing and developing database applications and data-intensive solutions using RDBMS technologies such as Oracle, DB2, and SingleStore (MemSQL).

\n

• Significant experience with enterprise data modeling, logical and physical data design, and database architecture.

\n

• Extensive experience and deep expertise with Oracle Database, including SQL, PL/SQL, stored procedures, performance tuning, query optimization, indexing, and partitioning strategies.

\n

• Significant experience and proficiency with IBM DataStage ETL development, data integration, data transformation, and data migration initiatives.

\n

• Strong background in data engineering, ETL design, data movement, and large-scale data processing solutions.

\n

• Extensive experience with stored procedures, SQL, and PL/SQL development, including performance optimization and troubleshooting of complex database workloads.

\n

• Experience with database modernization and migration projects involving large-scale enterprise data platforms.

\n

• Strong understanding of Change Data Capture (CDC), data integration, and data synchronization patterns.

\n

• Experience working in Linux/Unix environments, including shell scripting for automation, deployment, and operational support.

\n

• Experience with Python-based scripting for data processing, automation, and operational tooling.

\n

• Working knowledge of Splunk and Dynatrace for database monitoring, log analysis, troubleshooting, and performance monitoring.

\n

• Knowledge of Oracle GoldenGate, IBM IIDR, or similar data replication technologies is a plus.

\n

• Experience with CockroachDB or other distributed SQL databases is a plus.

\n

\n