Lead Data Warehouse & ETL Architect (Informatica, Oracle) with German

Capgemini; Wrocław; On-site; PLN 120,000 - 180,000; Full time

Benefits offered by this job

Medical care

Private life insurance

Multisport card

Therapeutic support

Job summary

Capgemini in Wroclaw seeks a senior ETL/Data Warehouse professional to design, develop and optimize ETL processes using Informatica PowerCenter and maintain enterprise-grade DW environments. You will work with SQL/PL-SQL, Python, Java and Shell scripts, while collaborating with business and IT teams to deliver robust data solutions.

The role emphasizes ETL architecture improvements, data modeling, and strong problem-solving with a focus on production reliability and stakeholder communication.

Qualifications

• Experience with Informatica PowerCenter.
• Advanced Oracle SQL/PL-SQL knowledge.
• Experience with Python, Java and Shell Scripting.
• Understanding of ETL design principles and Data Warehouse architecture.
• Data modeling experience and PowerDesigner.
• Familiarity with Agile, JIRA and Kanban.
• Knowledge of software testing methodologies and regression testing.
• Experience in enterprise-scale production DWH environments.
• Analytical mindset and problem-solving skills.
• Ownership and accountability.
• Excellent communication and stakeholder management.
• Ability to collaborate with cross-functional and international teams.

Responsibilities

• Design, develop and optimize ETL processes using Informatica PowerCenter.
• Support, maintain and enhance enterprise-scale Data Warehouse environments.
• Develop and maintain SQL, PL/SQL, Python, Java and Shell scripts.
• 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.
• Contribute to data modeling and Data Warehouse architecture design.

Skills

Informatica PowerCenter

Oracle SQL PL/SQL

Python

Java

Shell Scripting

ETL design principles

Data Warehouse architecture

Data modeling

PowerDesigner

Agile

JIRA

Kanban

Software testing methodologies

DWH production environments

Analytical mindset

Ownership & accountability

Communication & stakeholders

Cross-functional collaboration

International teams

Tools

Informatica PowerCenter

PowerDesigner

JIRA

Job description

Our Team:

Within our Insights & Data, we design and deliver modern data platforms, advanced analytics solutions and enterprise-scale data ecosystems. Our teams combine deep technical expertise with business understanding to help clients turn data into actionable insights and strategic advantage.

• 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

Your profile

• Strong expertise in Informatica PowerCenter


• Advanced knowledge of Oracle databases, SQL and PL/SQL


• Practical experience with Python, Java and Shell Scripting


• Solid understanding of ETL design principles, batch processing and Data Warehouse architecture


• Experience with data modeling and modeling tools such as PowerDesigner


• Familiarity with Agile ways of working and tools such as JIRA and Kanban


• Knowledge of software testing methodologies and regression testing


• Experience working in enterprise-scale production DWH environments


• Analytical mindset with strong problem-solving skills


• Strong sense of ownership and accountability


• Excellent communication and stakeholder management skills


• Ability to collaborate effectively with cross-functional and international teams

Nice to have

• Experience in regulated financial environments (e.g. BAIT, MaRisk)


• Experience with change and release management processes


• Knowledge of automotive, banking or leasing domains

What You'll love about working here

• Well-being culture: medical care with Medicover, private life insurance, and Multisport card. But we went one step further by creating our own Capgemini Helpline offering therapeutical support if needed and the educational podcast 'Let's talk about wellbeing' which you can listen to on Spotify.


• Access to over 70 training tracks with certification opportunities (e.g., GenAI, Excel, Business Analysis, Project Management) on our NEXT platform. Dive into a world of knowledge with free access to Education First languages platform, Pluralsight, TED Talks, Coursera and Udemy Business materials and trainings.


• Continuous feedback and ongoing performance discussions thanks to our performance management tool GetSuccess


• supported by a transparent performance management policy.


• Enjoy hybrid working model that fits your life - after completing onboarding, connect work from a modern office with ergonomic work from home, thanks to home office package (including laptop, monitor, and chair). Ask your recruiter about the details.

Get to know us

Capgemini is committed to diversity and inclusion, ensuring fairness in all employment practices. We evaluate individuals based on qualifications and performance, not personal characteristics, striving to create a workplace where everyone can succeed and feel valued.

Do you want to get to know us better? Check our Instagram — @capgeminipl or visit our Facebook profile — Capgemini Polska.