Senior DataStage Engineer: Legacy-to-Cloud Data & ETL

CSS (United States); Omaha (NE); On-site; USD 120,000 - 170,000; Full time

Job summary

Our client in Omaha, Nebraska is seeking a Senior Data Engineering Consultant to support a critical enterprise data modernization initiative onsite. The role requires hands-on expertise to optimize legacy data pipelines, enable cloud-based data platforms, and deliver scalable data delivery capabilities.

Collaboration with business and technical teams is essential. The ideal candidate will troubleshoot performance challenges, design scalable ingestion and transformation processes, and drive

Qualifications

• 8+ years of data engineering, ETL, or enterprise data integration experience.
• Strong IBM InfoSphere DataStage expertise or comparable ETL platforms.
• Experience with large-scale relational databases.
• Strong SQL development, query optimization, and database performance tuning.
• Experience supporting cloud data warehouses such as Snowflake.
• Proven experience building and supporting enterprise-scale data pipelines.
• Experience troubleshooting complex production environments and resolving critical issues.
• Ability to quickly understand legacy systems and work independently in complex environments.

Responsibilities

• Data Pipeline Optimization: analyze, troubleshoot, and optimize complex enterprise ETL/ELT workflows.
• Legacy-to-Cloud Data Integration: design and implement data movement between legacy databases and cloud platforms.
• Performance Engineering: identify bottlenecks and optimize SQL code, indexing, and processing logic.
• Stakeholder Engagement: collaborate with architects, developers, analysts, and business leaders; provide technical recommendations.
• Data Quality & Governance: develop monitoring, logging, validation, and reconciliation processes.

Skills

ETL/ELT design

SQL optimization

DataStage

Cloud DW

Data integration

Tools

IBM DB2

Snowflake

Control-M

Unix/Linux shell

Job description

Our client in Omaha, Nebraska is seeking a Senior Data Engineering Consultant to support a critical enterprise data modernization initiative onsite. The role requires hands-on expertise to optimize legacy data pipelines, enable cloud-based data platforms, and deliver scalable data delivery capabilities.

Collaboration with business and technical teams is essential. The ideal candidate will troubleshoot performance challenges, design scalable ingestion and transformation processes, and drive