Lead Data Warehouse & ETL Architect (Informatica, Oracle, with German)
⚲ Gdańsk, Kraków, Poznań, Warszawa, Wrocław
Do uzgodnienia
Wymagania
- Informatica PowerCenter
- Oracle
- SQL
- PL/SQL
- Python
- Java
- Bash
- PowerShell
Opis stanowiska
Nasze wymagania:
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)
Mile widziane:
Experience in regulated financial environments (e.g. BAIT, MaRisk)
Experience with change and release management processes
Knowledge of automotive, banking or leasing domains
O projekcie:
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.
Zakres obowiązków:
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
Oferujemy:
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.
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)
Mile widziane:
Experience in regulated financial environments (e.g. BAIT, MaRisk)
Experience with change and release management processes
Knowledge of automotive, banking or leasing domains
O projekcie:
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.
Zakres obowiązków:
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
Oferujemy:
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.
🔍 Dekoder Ogłoszenia
🔴
Lead Data Warehouse & ETL Architect
Chociaż tytuł sugeruje rolę architekta, może oznaczać głównie pracę deweloperską z elementami projektowymi, a nie strategiczne kierowanie architekturą.
🔴
Strong expertise in Informatica PowerCenter
Może oznaczać, że firma mocno stawia na konkretne, być może starsze, narzędzie, zamiast na szersze kompetencje architektoniczne.
🟡
Practical experience with Python, Java and Shell Scripting
Wymagane są umiejętności skryptowe, które mogą być wykorzystywane do automatyzacji zadań lub integracji, a niekoniecznie do tworzenia złożonych aplikacji.
🟡
Experience working in enterprise-scale production DWH environments
Oznacza pracę z dużymi, złożonymi systemami, co może wiązać się z presją i koniecznością rozwiązywania trudnych problemów pod presją czasu.
🔴
Strong sense of ownership and accountability
Może oznaczać, że oczekuje się od pracownika samodzielności i brania pełnej odpowiedzialności za powierzone zadania, nawet jeśli brakuje jasnych wytycznych.