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.