- IBM InfoSphere DataStage
- ETL Development
- Data Warehousing
- SQL & PL/SQL
- Unix/Linux Shell Scripting
- Data Integration
- Data Modeling Concepts
- Performance Tuning
- DB2 / Oracle / SQL Server
- Autosys or Other Scheduling Tools
- Troubleshooting & Debugging
Roles & Responsibilities
- Design, develop, test, and deploy ETL jobs using IBM DataStage.
- Develop and maintain complex data extraction, transformation, and loading (ETL) processes.
- Analyze business requirements and convert them into technical ETL solutions.
- Integrate data from multiple heterogeneous sources into data warehouse environments.
- Optimize DataStage jobs for performance, scalability, and reliability.
- Perform unit testing, system testing, and support user acceptance testing (UAT).
- Troubleshoot production issues and implement timely fixes.
- Write and optimize SQL queries, stored procedures, and database scripts.
- Create technical design documents and maintain project documentation.
- Collaborate with business analysts, architects, and database teams for solution delivery.
- Ensure data quality, integrity, and governance standards are followed.
- Support production releases and provide post-deployment support.