FREE ACCESS
5,000–10,000 jobs/day
See all jobs on Scoutfield
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.

Consultant, DB2, Oracle
Expleo Group. Develop, maintain, and support management reporting systems, with data sourced from DB2 Mainframe and a reporting layer in Oracle.
Core Competencies
Role fitCore Competencies
Use this summary to align your resume positioning with the role.
Demonstrates expertise in developing and maintaining management reporting systems using DB2 Mainframe and Oracle, with a strong focus on SQL, PL/SQL, and batch processing. Proficient in ensuring data quality and consistency through effective incident resolution and information consolidation.
Highest-signal resume keywords
DB2 MainframeOraclePL/SQLBatch ProcessingControl-M
ATS Keywords
Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
SQLStored ProceduresQuery OptimizationManagement ReportingData ModelingETL ToolsIncident AnalysisData IntegrationJCLBatch Scheduling
Tools & Technologies
Control-MFile-AIDEndevorChangeman
Industry Keywords
Banking SectorManagement IndicatorsInformation ConsolidationReconciliation WorkflowsPeriod-End Closing
Tech Stack
Tools & technologiesETLOracleSQL
About the role
Key responsibilities & impact- Develop, maintain, and support management reporting systems, with data sourced from DB2 Mainframe and a reporting layer in Oracle.
- Develop and maintain management indicators, reports, and queries using SQL and PL/SQL directly on the Oracle database.
- Monitor and ensure the execution of overnight batch processes, ensuring process completion and the availability of management information.
- Manage and monitor the scheduling and execution of batch processes, including JCL and tools such as Control-M or equivalent.
- Analyze and resolve technical incidents related to data processing, batch operations, and information availability.
- Support information consolidation and reconciliation processes, ensuring data consistency and quality.
Requirements
What you’ll need- Strong experience with DB2 Mainframe, including SQL, stored procedures, and query optimization.
- Strong experience with Oracle and PL/SQL, particularly in building and maintaining reporting layers directly in the database.
- Experience building management indicators, reports, and queries.
- Experience with high-volume batch data processing.
- Knowledge of JCL and batch scheduling and monitoring tools, such as Control-M or equivalent.
- Experience analyzing and resolving incidents associated with batch processes and reporting systems.
- Knowledge of information consolidation and reconciliation.
- Experience with ETL tools and data integration between DB2 Mainframe and Oracle.
- Knowledge of tools supporting Mainframe environments, particularly File-AID and Endevor/Changeman.
- Knowledge of data modeling.
- Knowledge of management reporting and business indicators in the banking sector.
- Understanding of consolidation and reconciliation workflows and the dependencies of overnight batch processes.
- Knowledge of the impact of batch processes on period-end closing and the availability of management information.
Benefits
Comp & perks- Hybrid workplace
- Permanent employment