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

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

Miejsce pracy: Kraków

Technologies we use

Expected

• Informatica PowerCenter
• Oracle
• SQL
• PL/SQL
• Python
• Java
• Bash
• PowerShell

Optional

• PowerShell

Operating system

• Windows

About the project

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.

Your 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

Our requirements

• 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
• Strong documentation skills
• Strong English language skills
• German language at B2 level (or higher)

Optional

• Experience in regulated financial environments (e.g. BAIT, MaRisk)
• Experience with change and release management processes
• Knowledge of automotive, banking or leasing domains

What we offer

• 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.

Benefits

• sharing the costs of sports activities
• private medical care
• life insurance
• no dress code
• parking space for employees
• extra social benefits
• redeployment package
• employee referral program
• charity initiatives
• access to courses e.g. Excel, VBA, RPA, Customer Care
• unlimited access to Udemy Business
• free chat/call with a therapist

Recruitment stages

• Interview with the recruiter
• Competency Tests/Language Verification
• Video call with a manager
• Final Decision

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.

Capgemini Polska

Capgemini is the business transformation partner for enterprises in the age of AI. We help organizations imagine and build an intelligent, sustainable future, combining AI, technology and human ingenuity to transform how they operate, innovate and grow. With unique end-to-end capabilities spanning strategy, technology, engineering and intelligent operations, we bring together deep industry expertise and market-leading capabilities in AI, cloud and data to turn ambition into measurable business outcomes at scale. Supported by a robust ecosystem of partners and nearly 60 years of expertise, Capgemini is a responsible and diverse global organization of over 410,000 team members in more than 50 countries. The Group reported 2025 revenues of €22.5 billion.

Make it real |

I agree to the processing of personal data provided in this document for realising the recruitment process pursuant to the Personal Data Protection Act of 10 May 2018 (Journal of Laws 2018, item 1000) and in agreement with Regulation (EU) 2016/679 of the European Parliament and of the Council of 27 April 2016 on the protection of natural persons with regard to the processing of personal data and on the free movement of such data, and repealing Directive 95/46/EC (General Data Protection Regulation).