MDI Data Integration Engineer - IMB
Deutsche Bank
Pune, Maharashtra, India
JOB DESCRIPTION Role Description Our Technology Data and Innovation (TDI) teams are responsible for the bank's complete information technology (IT) infrastructure as well as for developing, implementing and protecting the software required to support the bank's entire business. We move more than €1.6 trillion through the bank's platforms every day. Every day, we enable millions of customers to use our broad range of banking services across all contact channels. Within Shared Applications we deliver applications and technology to support all areas of the bank with standardized central solutions. Senior Engineer - ETL_Informatica (Techlead/Platform Engineer) Deutsche Bank is looking for experienced Senior Informatica ETL Developers within our Private Banking Shared Applications division. Like the name implies, the role requires the candidate to display a high degree of personal ownership for the assigned application(s). He or she should be well organized and be capable to set individual and group priorities. Within the Shared Applications area team work and cross domain communication and cooperation are the primary keys to our success. 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 Develop, maintain, and support ETL processes using Informatica PowerCenter, including mappings, workflows, and sessions. Create and maintain documentation for ETL processes, including technical specifications, data mappings, and test plans Improve existing data designs and design new databases and data models, including relational table structures, using Unix Shell Scripting, Oracle and SQL Server Manage the requirements gathering, development and rollout of major projects on the solution platform Drive and develop new data import/export or other transformation exercises Provide ad-hoc support for advanced strategic data analysis initiatives Act as the go-to expert on all underlying transformation logic against data in the data Integration platform Support business user questions about the data and provide documentation and training when and where necessary Support campaign and report developers with data inquiries or new data requests Drive and participate in all Integration topics Leads in writing and reviewing software functional specifications and design reviews Provides input to continuously improve ETL process discipline and resulting output quality Your skills and experience Knowledge in one or more of the technologies utilized in the MDI department (Informatica Power Center, Unix, Oracle , Automic Scheduler) Agile experience or related training Bank-related knowledge Maven Experience, Atlassian tools (JIRA, Confluence, BitBucket) Basic Qualifications: 10+ years overall experience with at least 6 years relevant experience. Good experience in Leading and Managing different teams Experience with file transfer protocols and system connectivity both midrange and mainframe. Prior knowledge of Informatica Power Adaptors in desirable. Strong knowledge of Oracle or other rational databases including fundamental SQL Experience with Informatica or other ETL Platform Experience with data design Experience with large volume batch processing and performance optimization Experience with job scheduling design and implementation, preferably with Automic First experience with Cloud technologies or strong willingness to familiarize yourself with them Experience in automation of deployments and tests Understanding in a DevOps context desirable Strong understanding of architecture patterns, typical integration patterns, code conventions or other best practices Knowledge working/supporting UNIX-based IT Landscapes Ability to prioritize and manage time to deliver on commitments A passion for constantly learning and applying new technologies and applications in a constantly evolving environment Fluent in English (written & spoken) 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 Please visit our company website for further information: https://www.db.com/company/company.htm 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. We welcome applications from talented people from all cultures, countries, races, genders, sexual orientations, disabilities, beliefs and generations and are committed to providing a working environment free from harassment, discrimination and retaliation. Visit Inside Deutsche Bank to discover more about the culture of Deutsche Bank including Diversity, Equity & Inclusion, Leadership, Learning, Future of Work and more besides.