Eisen:

• 5+ years of experience in Informatica PowerCenter development.
• 2+ years of hands-on experience with Informatica IDMC (IICS) including EC2.
• Strong experience using Snowflake.
• Strong expertise in Oracle SQL / PL/SQL.
• Proficiency in AWS services related to containerization (e.g., ECS, EKS, Fargate) and storage (S3).
• Experience with Infrastructure as Code (IaC) using Terraform.
• Knowledge of DevOps CI/CD principles and tools (Git, Jenkins, etc.).
• Strong problem-solving and performance tuning skills.
• Excellent communication and documentation abilities.
• Considerable experience in delivering BI projects.
• Project and Stakeholder Management -> good communication skills.
• Data Requirements Engineering.
• Expert in Data Engineering, Data Analysis (SQL) and ETL (Informatica).
• Good understanding of Data Warehouse architectures and technologies (Oracle).
• Experience in ATC tools (JIRA, Confluence).

Wensen:

• Fluent in English.
• Business proficiency of the German language is beneficial, no knockout.
• Financial service background.
• Experience in working in an agile environment.

Omschrijving:

BMW Financial Services Nederland B.V., operating as Alphabet, is a leading provider of Business Mobility in Europe, Australia and China. As such, it enables companies to manage their corporate mobility in an economical and sustainable way. Founded in 1997 as a division of BMW Group, Alphabet has extensive knowledge of international fleet management and leasing. Alphabet’s Business Mobility solutions are tailor-made to meet specific corporate requirements. Today, Alphabet manages a portfolio of over 700,000 leased cars and light commercial vehicles of all makes and is ranked fourth in the market worldwide. A significant part of the IT Department is located in Breda from where IT Services are developed and provided for various BMW entities and the European market. In this role as a Business Data Engineer, you will be responsible for designing, developing, and maintaining data integration pipelines using Informatica PowerCenter and Informatica IDMC (IICS). You will lead migration initiatives from PowerCenter to Informatica Cloud, including containerized deployment with EC2 on AWS. Your tasks will also include migrating ETL workflows from PowerCenter/Oracle to Informatica Cloud targeting Snowflake as the cloud data warehouse. You will develop and optimize complex SQL and PL/SQL procedures/functions on Oracle and translate them into Snowflake-compatible SQL where required. Collaboration with cloud infrastructure teams to provision and manage environments using Terraform scripts and AWS services (ECS/EKS, S3, Lambda, IAM) will be essential. You will automate the deployment of Informatica services and ensure high availability, scalability, and security. Participation in code reviews, performance tuning, and operational support for integration jobs will also be part of your responsibilities. Documentation of architecture, data flows, configurations, and technical processes is crucial. You will support legacy applications around DFIC, Data Warehouse, and Staging Area, aiming to retire as many objects as possible while maintaining business value.