Lead ETL & Data Warehouse Architect (Informatica/Oracle)

Capgemini; Wrocław; Hybrid; PLN 180,000 - 260,000; Full time

Benefits offered by this job

Medicover healthcare

Private life insurance

Multisport card

Hybrid work model

Job summary

Capgemini in Wrocław seeks a skilled Data Engineer to design, develop, and optimize ETL processes using Informatica PowerCenter and to maintain enterprise-scale Data Warehouse environments. You will work with SQL/PLSQL, Python, Java and Shell Scripting to deliver robust data solutions.

The role focuses on ETL architecture improvements, collaboration with cross-functional teams, and ensuring delivery quality through testing and documentation.

Qualifications

• Design, develop and optimize ETL processes using Informatica PowerCenter.
• Support, maintain and enhance enterprise-scale Data Warehouse environments.
• Develop and maintain solutions based on SQL, PL/SQL, Python, Java and Shell Scripting.
• Drive ETL architecture improvements and batch processing optimization.
• Collaborate with business stakeholders and IT teams to translate requirements into technical solutions.
• Perform root cause analysis and resolve incidents in production environments.
• Support change, release and deployment activities.
• Prepare and maintain technical documentation.
• Ensure solution quality through testing, validation and regression testing activities.
• Contribute to data modeling and Data Warehouse architecture design.

Responsibilities

• Design, develop and optimize ETL processes using Informatica PowerCenter.
• Support, maintain and enhance enterprise-scale Data Warehouse environments.
• Develop and maintain solutions based on SQL, PL/SQL, Python, Java and Shell Scripting.
• Drive ETL architecture improvements and batch processing optimization.
• Collaborate with business stakeholders and IT teams to translate requirements into technical solutions.
• Perform root cause analysis and resolve incidents in production environments.
• Support change, release and deployment activities.
• Prepare and maintain technical documentation.
• Ensure solution quality through testing, validation and regression testing activities.
• Contribute to data modeling and Data Warehouse architecture design.

Skills

Analytical mindset

Strong communication

Ownership & accountability

English proficiency

German language

Tools

Informatica PowerCenter

Oracle SQL/PLSQL

Python

Java

Shell Scripting

PowerDesigner

JIRA/Kanban

Job description

Capgemini in Wrocław seeks a skilled Data Engineer to design, develop, and optimize ETL processes using Informatica PowerCenter and to maintain enterprise-scale Data Warehouse environments. You will work with SQL/PLSQL, Python, Java and Shell Scripting to deliver robust data solutions.

The role focuses on ETL architecture improvements, collaboration with cross-functional teams, and ensuring delivery quality through testing and documentation.