Cdwh Dev

**Job Title
- **Customer Analytics **Tribe | ETL (Informatica) Engineer

**Location
- Pune (India)**

**Role Description**

The tribe "Customer Analytics" is responsible for the creation as well as the orchestration of the digital customer communication towards our internal and external customers for the brands Deutsche Bank and Postbank within Deutsche Bank Private Bank Germany (PB GY). The tribe consists of several squads, which are responsible for the Digital Marketing Platform of PB GY on the one hand and the creation, orchestration, and playout of data-based, individualized customer communications on the other. The overall management of the Digital Marketing Platform is clustered in a Product Domain.

The squad “ **DevOps Data and Analytics Platform **” is responsible for:

- Source data from multiple operating systems
- Transform data as per business need
- Warehouse data to leverage analytics and campaign and marketing management.

The majority of the team is based in India, reporting into the German organization.

We are looking for a ETL (Informatica) Engineer to be responsible to improve our system of insights throughout the life cycle and contribute to leveraging and scaling our Digital Marketing Platform for our clients.

Your Team will focus on the delivery and maintenance of customer centric data Warehousing as well as ETL workflow development around our BI landscape. Your team will also be responsible for migration of the Informatica ETL workflows to Google Cloud.

**What we’ll offer you**

As part of our flexible scheme, here are just some of the benefits that you’ll enjoy
- Best in class leave policy
- Gender neutral parental leaves
- 100% reimbursement under childcare assistance benefit (gender neutral)
- Sponsorship for Industry relevant certifications and education
- Employee Assistance Program for you and your family members
- Comprehensive Hospitalization Insurance for you and your dependents
- Accident and Term life Insurance
- Complementary Health screening for 35 yrs. and above

**Your key responsibilities**
- You will support the existing team and actively help to expand the functionality and continuously improve the platform.
- You find new ways to work more efficiently and support the introduction of productivity-increasing measures, leaner processes, efficient tools and generally also automation, e.g. in the form of continuous delivery.
- Conversely, you also make it your task to constantly develop yourself further and are open to more modern approaches to data integration/processing.
- You get stories / requirements and develop those according to the standards your team sets out in a self-reliant manner.
- You'll collaborate with Product Owners as well as the team members in regards to design and implementation of data analytics solutions and act as support during the conception of products and solutions.

**Your skills and experience**
- Extensive experience (5+ Years ) with extract, transform, and load (ETL) tools - Informatica 9.5 mapping and workflows
- Experience in developing PowerCenter Workflows and Sessions, and Oracle database
- Experience with proficiency in PL/ SQL and Unix Shell scripting
- Familiarity with using Agile Methodology, understanding of ITIL processes in a DevOps context
- Extensive experience with Oracle Database, Good to have experience in NoSQL Database.
- Expertise in performance tuning of databases for optimal performance (creating the indexes on tables and partitioning the table for SQL tuning purpose)
- Good understanding of relational database management system (RDBMS) concepts, dimensional modelling like star schema, snowflake schema.
- Extensive experience in creating PL/SQL packages, procedures, functions, triggers, views, materialized views and exception handling for retrieving, manipulating, checking and migrating complex data sets in oracle and knowledge and experience in setup data exchange protocols
- Worked in agile environments with methodologies such as SCRUM
- Excellent command of spoken and written English
- Experienced working in distributed multi-cultural teams
- Knowledge about ETL process automation

**Nice to have**
- Knowledge in Python and BigQuery Desiable

**How we’ll support you**
- Training and development to help you excel in your career
- Coaching and support from experts in your team
- A culture of continuous learning to aid progression
- A range of flexible benefits that you can tailor to suit your needs

**About us and our teams**

Our values define the working environment we strive to create - diverse, supportive and welcoming of different views. We embrace a culture reflecting a variety of perspectives, insights and backgrounds to drive innovation. We build talented and diverse teams to drive business results and encourage our people to develop to their full potential. Talk to us about flexible work arrangements and other initiatives we offer.

Visit Inside Deutsche Bank to discover more about the culture