Lead Data Warehouse & ETL Architect (Informatica, Oracle, with German) @ Capgemini Polska Sp. z o.o.

Capgemini Polska Sp. z o.o.; Poland; Hybrid; PLN 120,000 - 180,000; Full time

Job summary

Capgemini Polska Sp. z o.o. seeks an experienced ETL/Data Warehouse engineer to design and implement robust data integration solutions using Informatica PowerCenter and SQL-based tech stacks.

You will contribute to enterprise-scale DW environments and collaborate with cross-functional teams across borders. The role involves hands-on development in Python, Java, and Shell scripting, with a focus on ETL design principles, performance tuning, and data modeling.

Qualifications

• Experience with Informatica PowerCenter and Oracle databases.
• Strong SQL/PL-SQL, Python, Java, and Shell scripting skills.
• Knowledge of ETL, data warehouse concepts, data modeling, and Jira for agile workflows.

Responsibilities

• Design, develop and optimize ETL processes using Informatica PowerCenter and SQL-based solutions.
• Support, maintain and enhance enterprise-scale Data Warehouse environments.
• Develop and maintain solutions based on 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 and prepare technical documentation.
• Ensure solution quality through testing, validation and regression testing activities.
• Contribute to data modeling and Data Warehouse architecture design.

Skills

Informatica PowerCenter

Oracle databases

SQL

PL/SQL

Python

Java

Shell Scripting

ETL design principles

Batch processing

Data Warehouse architecture

Data modeling

PowerDesigner

JIRA

Kanban

Testing methodologies

Regression testing

English

German (B2)

Cross-functional collaboration

Documentation

Tools

JIRA

Job description

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

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

Choosing Capgemini means choosing a company where you will be empowered to shape your career in the way you’d like, where you’ll be supported and inspired bya collaborative community of colleagues around the world, and where you’ll be able to reimagine what’s possible. Join us and help the world’s leading organizationsunlock the value of technology and build a more sustainable, more inclusive world.

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.

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

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.

Capgemini is an AI-powered global business and technology transformation partner, delivering tangible business value. We imagine the future of organizations and make it real with AI, technology and people. With our strong heritage of nearly 60 years, we are a responsible and diverse group of 420,000 team members in more than 50 countries. We deliver end-to-end services and solutions with our deep industry expertise and strong partner ecosystem, leveraging our capabilities across strategy, technology, design, engineering and business operations. The Group reported 2024 global revenues of €22.1 billion.

• 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

Requirements: Informatica PowerCenter, Oracle database, SQL, Python, Java, Shell, ETL, Data warehouse, Jira, Testing Additionally: Training budget, Sport subscription, Private healthcare, International projects, Free coffee, Bike parking, Free parking, Mobile phone, In-house trainings, Modern office, No dress code.