Production Engineer ETL

DB Global Technology is Deutsche Bank’s technology centre in Central and Eastern Europe. Since its set-up in 2013, Bucharest Technology Centre (BEX) has constantly proven its capacity to deliver global technology products and services, playing a dynamic role in the Bank’s technology transformation.

We have a robust, hands-on engineering culture dedicated to continuous learning, knowledge-sharing, technical skill development and networking. We are an essential part of the Bank’s technology platform and develop applications for many important business areas.

The ETL Engineer provides critical production support for Deutsche Bank's data integration landscape, ensuring the stability, performance, and integrity of data pipelines. This role is responsible for the timely investigation and resolution of ETL job failures, debugging complex data flows, and contributing to the continuous improvement of system reliability. Using a core stack including Informatica, Oracle, and Linux, the Engineer will apply their technical expertise within established support processes (Incident, Problem, Change Management) to ensure the uninterrupted flow of data that underpins our business operations.

Responsibilities

• Acts as the primary technical resource for monitoring, analysing, and resolving production incidents related to ETL workflows and jobs, ensuring adherence to SLAs.

• Performs deep-dive analysis of Informatica workflows and Oracle SQL queries to debug data processing failures and identify root causes.
• Manages and resolves incidents using the ServiceNow ticketing system, ensuring clear and consistent communication with stakeholders.
• Runs and monitors existing data reconciliation jobs and scripts, investigating and escalating any data integrity discrepancies.
• Contributes to Root Cause Analysis (RCA) by providing detailed technical analysis of recurring incidents to support the identification of underlying problems.
• Proactively monitors critical ETL jobs and data feeds, identifying potential performance bottlenecks or failure points.
• Shows enthusiasm for identifying and suggesting improvements for existing production processes, particularly through automation of manual tasks.
• Acts as a Site Reliability Engineer (SRE), focusing on enhancing monitoring, alerting, and system reliability.
• Develops, tests, and deploys code fixes for ETL mappings, workflows, and database objects as part of the Problem Management process.
• Maintains and contributes to the Knowledge Management database, documenting new issue resolutions and standard operating procedures.
• Assesses technical changes for potential impact on production ETL processes and data dependencies.

Skills

• Minimum 5+ years of hands-on experience in ETL development and/or production support, primarily with Informatica PowerCenter.
• Proven ability to work in a fast-paced, mission-critical environment with a constant focus on delivery and service stability.
• Previous experience in the banking/financial services industry is a significant added advantage.
• Experience working within an ITIL-based framework, with a solid understanding of Incident, Problem, and Change Management processes.
• Demonstrated history of working in a delivery model based on agreed Service Level Agreements (SLAs).
• Informatica: Strong hands-on experience with Informatica PowerCenter client tools (Designer, Workflow Manager, Workflow Monitor). Ability to read, understand, and debug complex mappings and workflows.
• Oracle: Proficiency in writing and analysing complex SQL queries, including multi-table joins, subqueries, and analytical functions. Ability to read and understand PL/SQL code and basic query execution plans.
• Linux/Shell Scripting: Solid understanding of basic Linux commands for file manipulation, searching logs and checking processes. Ability to read and understand existing shell scripts.
• Scheduling: Experience working with enterprise schedulers like Control-M or Autosys to monitor job flows, investigate failures, and understand dependencies.
• Ticketing: Proficiency in using ServiceNow or a similar ITSM tool for incident and change management.
• Proven skills in debugging ETL failures, analysing session/workflow logs, and identifying data or environmental issues.
• Preferable Knowledge: Basic understanding of scripting with Python or advanced Shell scripting.
• Version Control: Familiarity with using version control systems like GitHub or SVN for code management.
• Project Management: Awareness of agile methodologies and experience with tools like JIRA.
• Cloud: Foundational knowledge of a major cloud provider (e.g., GCP, AWS, Azure) and familiarity with cloud storage concepts (e.g., GCS, S3).
• Familiarity with performance tuning concepts for ETL mappings and database queries.
• Solid understanding of fundamental Data Warehousing concepts (e.g., Star/Snowflake schemas, Fact/Dimension tables, Slowly Changing Dimensions - SCDs).

Well-being & Benefits

Emotionally and mentally balanced: we support you in dealing with life crises, maintaining stability through illness, and maintaining good mental health

• Empowering managers who value your ideas and decisions. Show your positive attitude, determination, and open-mindedness.

• A professional, passionate, and fun workplace with flexible Work from Home options.

• A modern office with fun and relaxing areas to boost creativity.

• Continuous learning culture with coaching and support from team experts.

Physically thriving we support you managing your physical health by taking appropriate preventive measures and providing a workplace that helps you thrive

• Private healthcare and life insurance with premium benefits for you and discounts for your loved ones.

Socially connected: we strongly believe in collaboration, inclusion and feeling connected to open new perspectives and strengthen our self-confidence and wellbeing.

• Enjoy retailer discounts, cultural and CSR activities, employee sport clubs, workshops, and more.

Financially secure: we support you in meeting personal financial goals during your active career and for the future

• Competitive income, performance-based promotions, and a sense of purpose.

• 24 days holiday, loyalty days, up to 3 health days, bank holidays (including weekdays for weekend bank holidays).

We strive for a culture in which we are empowered to excel together every day. This includes acting responsibly, thinking commercially, taking initiative and working collaboratively.

Together we share and celebrate the successes of our people. Together we are Deutsche Bank Group.

We welcome applications from all people and promote a positive, fair and inclusive work environment.