Engineering - Dev (Back-End)
Description
:About International Private Bank
Deutsche Bank’s International Private Bank is one of the preeminent private banks in the Eurozone and for family entrepreneurs worldwide. It serves around 3. 4 million clients, including private clients and small and
- sized enterprises (SMEs) in Italy, Spain, Belgium and India, and wealth management clients from more than 80 locations in Germany, the rest of Europe, the Middle East and Africa (EMEA), Asia-Pacific and the Americas.
It offers
-
- worth (HNW) and
- high
- worth (UHNW) clients a broad range of traditional and alternative investment solutions, as well as comprehensive advice on all aspects of wealth management. Additionally, in Italy, Spain, Belgium and India it offers a comprehensive range of products including investment and insurance products, deposits, checking accounts, cards and other payment services as well as credit and business banking products.
Purpose of the job
The role of an ETL Developer is to analyse, design, develop and deploy ETL flows using Informatica 10 tool. Condor is a project that promotes an Advisory and Discretionary Portfolio Management solution to the top clients in DB. The solution is offered by a vendor. “In-house” we are developing the part where we bring the data from Regional Data Marts through an ETL complex process.
The role includes but not limited to:
• Technical analysis: Engineer works closely with the BA to produce the technical requirements at the beginning of the project.
• ETL Development: Engineer is responsible for analyzing business cases, designing, developing and delivering the ETL flows to accomplish business goals based on business requirements.
• Technology Support: investigate and fix production issues encountered by the underlying solution
Key Responsibilities
Understand the requirement of business processes and conduct technical analysis for development feasibility
Design, develop, test, deploy ETL flows, while applying ETL, PL/SQL best practices
Creation and upkeep of developer artefacts - PDDs, Test Scripts, JIRA tickets - post go live
Work closely with BA team to validate and sign off on all feasibility studies / Key documents, system access requirements and test case needs to in order to ensure high standard of product delivery
Provide L2 support function for all production issues raised via JIRA ensuring that an
- depth investigation of any defects / known issues is conducted prior to raising to L3 support group
Responsible for upkeep and transparency of all JIRA tickets as well as ensuring work estimations are as accurate as possible as well as providing clear updates and escalations in the daily scrum calls
Working in teams following agile development practices
Performing code reviews and reviews of technical documentation
Skills & Qualifications :
Must have skills:
Knowledge of ETL and Data Warehouse Concepts
Knowledge of SQL, PL/SQL programming language
Knowledge of Oracle database
Knowledge of Informatica/ODI/SSIS ETL tools
Knowledge of Unix Shell Scripting language
Knowledge of Git/Artifactory/Team City/Jira/Confluence
Experience with any Scheduler including Cron
Strong attention to details because analysis needs to be changed few times till when we have a finished product
Preferred skills:
Experience of Informatica Powercenter version 9. 6 or higher
Experience with Data
Warehouse concept, preferably Star Schema or Data Vault
Experience with Control-M scheduler
Soft skills:
Can handle working under pressure with tight deadlines
Good communicator and team player
Good English speak/write skills
Strong
- solving skills in innovative ways
Experience with large and complex projects in enterprise environment
Here you can find:
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.
We promote good working relationships and encourage high standards of conduct and work performance.
Fii primul, care se va înregistra la oferta de muncă respectivă!
-
De ce să cauți de muncă pe Lucrezi.ro?
În fiecare zi oferte noi de muncă Puteți alege dintr-o gamă largă de locuri de muncă: Scopul nostru este de a oferi o gamă cât mai largă de opțiuni Lasă să-ți fie trimise noile oferte prin e-mail Fii primul care răspunde la noile oferte de muncă Toate ofertele de muncă într-un singur loc (de la angajatori, agenții și alte portaluri) Toate serviciile pentru persoanele aflate în căutarea unui loc de muncă sunt gratuite Vă vom ajuta să găsiți un nou loc de muncă