Job at a glance
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.