Role: IBM DataStage Consultant
Location: Columbus, Ohio (Remote)
Duration: Long term
Description: An IBM DataStage Consultant is responsible for designing, developing, and maintaining ETL (Extract, Transform, Load) processes using IBM DataStage to support enterprise data integration and analytics. The role combines technical expertise in DataStage with strong problem-solving and communication skills to deliver scalable, reliable data solutions.
Key Responsibilities:
ETL Development & Maintenance:
- Design, build, and optimize ETL pipelines using IBM DataStage.
- Ensure data accuracy, consistency, and performance across systems.
Data Integration:
- Integrate data from multiple sources (databases, cloud platforms, APIs).
- Support migration and transformation initiatives for enterprise data warehouses.
Performance Tuning:
- Monitor ETL jobs, troubleshoot failures, and optimize performance.
- Implement best practices for scalability and reliability.
Collaboration:
- Work with business analysts, data architects, and stakeholders to translate requirements into technical solutions.
- Provide technical guidance and support to junior developers.
Documentation & Compliance:
- Maintain technical documentation for ETL processes.
- Ensure compliance with data governance and security standards.
Required Skills
Core Technical Skills:
- IBM DataStage (parallel and server jobs).
- Strong SQL and database knowledge (Oracle, DB2, SQL Server).
- Scripting (Unix/Linux shell scripting).
Cloud & Modern Tools:
- Familiarity with AWS, Azure, or Google Cloud for data integration.
- Knowledge of scheduling tools (Control-M, Autosys).
Additional Competencies
- Performance tuning and debugging.
- Risk management and reliability engineering.
- Strong communication and documentation skills.