Technology Specialist -Senior Data Engineer

Job Title- Technology Specialist -Senior Data Engineer

Location- Pune, India

Role Description

Our Data Strategy team which is part of DWS Global Technology is looking for a experienced Data Engineer to further develop the data strategy program. This program is a strategic program for DWS, where all of the core data domains of Asset Management are consolidated, harmonized and exposed to the end consumer in a consistent manner.

Data engineer is a central part of the data strategy who needs to own the backend systems for data management. Responsible for develop to productionize data solutions to meet business goals. Senior data engineer works with business analyst and development team to develop required data solutions using expertise in RDBMS technologies.

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

• Working with the development team to meet the agreed project delivery goals using agile delivery model.
• End to end ownership from development to production for the given code based artifacts.
• Production of code based assets within the context of agile delivery (helping define and meet epics, stories, acceptance criteria)
• Working with project stakeholders like BA, Architects, delivery leads in understanding and planning of the database related deliveries
• Responsible for the design, development and QA of those assets and outputs
• Ensure compliance to coding guidelines and standards in the area of SQL database objects and contributing for enhancing the same
• Perform review of component integration testing, unit testing and code review
• Working with data architect and supporting data model design.
• Enforcement of NFRs, architectural / development standards and principles
• Working with central DBA teams in monitoring and planning of effective resource utilization of database server

Your skills and experience

• Good understanding of Microsoft SQL server database, 10+ years of experience in working with MS SQL Server
• Experience of working in different data models like Normalized, Star Schema, Data Vault etc
• Expertise in writing complex Stored Procedure, functions, triggers, index etc
• Knowledge of different database objects like index, cursor, Store Procedure, functions etc.
• Experience in using code versioning tools like git for DB objects and automated deployment of the same using SDLC tools
• Worked with large databases storing millions of records.
• Performance tuning experience of MS SQL server.
• Experienced in using of the data model using tools such as Power Designer and enhancing and supporting the same.
• Good to have experience of working in investment banking domain.

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