Job Description:

• Design, develop, and maintain data integration and ETL processes using IBM DataStage based on business and technical requirements.
• Develop, optimize, and maintain ETL jobs for extracting, transforming, and loading data across enterprise systems and databases.
• Design and optimize database queries, data structures, and data processing solutions using Oracle Database 19c.
• Perform data validation, troubleshooting, performance tuning, and error handling to ensure data accuracy, integrity, and reliability.
• Monitor and support scheduled ETL jobs, investigate data processing issues, and implement appropriate corrective actions.

Requirements

Qualifications:

• At least 3–5 years of experience in Data Engineering, ETL Development, or Data Integration.
• Strong hands-on experience with IBM DataStage for ETL development, job design, scheduling, and troubleshooting.
• Proficient in Oracle Database 19c, including SQL development, data manipulation, joins, stored procedures, and query optimization.
• Strong understanding of ETL concepts, data integration, data transformation, and data quality.
• Experience in developing and optimizing complex SQL queries for large datasets.
• Familiar with data warehouse concepts, dimensional modeling, and enterprise data integration patterns.
• Experience with version control, deployment processes, and production support for ETL applications.