Data Warehouse & ETL Architect — Informatica PowerCenter

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

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.