The Role
Designs, develops, optimizes, and supports ETL and data integration processes using IBM DataStage and Oracle Database 19c. Responsibilities include creating complex SQL queries, managing data transformations, validating data quality, troubleshooting processing issues, tuning performance, monitoring scheduled jobs, and supporting production ETL applications across enterprise systems.
Summary Generated by Built In
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.
Skills Required
- At least 3–5 years of experience in data engineering, ETL development, or data integration
- Hands-on experience with IBM DataStage for ETL development, job design, scheduling, and troubleshooting
- Proficiency with 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 developing and optimizing complex SQL queries for large datasets
- Familiarity with data warehouse concepts, dimensional modeling, and enterprise data integration patterns
- Experience with version control, deployment processes, and production support for ETL applications
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Your trusted business partner for IT solutions and services. Questronix has grown to be one of the largest IT solutions and service providers and systems integrator in the Philippines since 1987 that has earned awards and certificates through its focused professional team of experts
