Consultor DB2 & Oracle

Expleo Group; Lisboa; Presencial; EUR 40 000 - 60 000; Tempo integral

Resumo da oferta

Expleo Group in Lisbon is seeking a skilled DB2 Mainframe/ETL developer to support batch processing environments. You will design and optimize SQL, develop stored procedures, and build robust reporting solutions.

You will work with JCL, Control-M, and high-volume batch processing, ensuring data availability and system reliability, while delivering KPI dashboards and complex SQL queries.

Qualificações

• Strong experience with DB2 Mainframe, including SQL development, stored procedures, and query optimization.
• Solid knowledge of Oracle PL/SQL, with experience developing and maintaining reporting solutions directly within the database.
• Experience designing and developing management reports, KPIs, dashboards, and complex SQL queries.
• Experience with high-volume batch processing in enterprise environments.
• Knowledge of JCL and batch scheduling/monitoring tools such as Control-M.

Responsabilidades

• Strong experience with DB2 Mainframe, including SQL development, stored procedures, and query optimization.
• Solid knowledge of Oracle PL/SQL, with experience developing and maintaining reporting solutions directly within the database.
• Experience designing and developing management reports, KPIs, dashboards, and complex SQL queries.
• Experience with high-volume batch processing in enterprise environments.
• Knowledge of JCL and batch scheduling/monitoring tools such as Control-M (or equivalent).

Conhecimentos

DB2 Mainframe

SQL development

Stored procedures

Query optimization

Oracle PL/SQL

Reporting solutions

KPIs dashboards

Batch processing

JCL

Control-M

Descrição da oferta de emprego

Expleo is a trusted partner for your innovation journey. As a global engineering, technology and consulting service provider, we are ideally positioned to help you achieve your ambitions and future-proof your business. With a smart blend of bold thinking and reliable execution, we’re able to fast-track innovation through each step of your value chain.

We are strategically positioned to build value, with global footprint across 30 countries.

We are as global and local as you need us to be, with strong best-in-class pan-European technological centres and unique best-shoring capabilities.

We leverage a network of high value-adding affiliates in consulting and industrial excellence, and leading partners across multiple sectors to provide you with the most comprehensive services and solutions in an ever-changing environment.

Responsibilities

• Strong experience with DB2 Mainframe, including SQL development, stored procedures, and query optimization.
• Solid knowledge of Oracle PL/SQL, with experience developing and maintaining reporting solutions directly within the database.
• Experience designing and developing management reports, KPIs, dashboards, and complex SQL queries.
• Experience with high-volume batch processing in enterprise environments.
• Knowledge of JCL (Job Control Language) and batch scheduling/monitoring tools such as Control-M (or equivalent).
• Strong analytical and troubleshooting skills to identify and resolve batch processing issues, ensuring data availability and system reliability.