DataStage Developer

Role : DataStage Developer

Location: Addison, TX / Charlotte, NC

Duration: Fulltime Role

DataStage Developer

Primary Skills

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

Secondary Skills

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

Required Qualifications

\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