Must Have Skills
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 settings.
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.