Data Engineer - AVP

Job Title – Data Engineer - AVP

Location – Pune, India

Role Description

• We are seeking a motivated and experienced Data Engineer to join our growing data team. This role is ideal for someone passionate about building data products that make impact in people and business. You will play an important role in designing, developing, and maintaining data infrastructure and processes, ensuring the data is accurate, accessible, and aligned with the organization’s Chief Data Office data management standards and practices.
• At DWS, we’re capturing the opportunities of tomorrow. You can be part of a leading, client-committed, global Asset Manager, making an impact on individuals, communities, and the world.
• Join us on our journey, and you can shape our transformation by working side by side with industry thought-leaders and gaining new and diverse perspectives. You can share ideas and be yourself, whilst driving innovative and sustainable solutions that influence markets and behaviours for the better.

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

• Architect and maintain scalable data warehouses and ETL/ELT pipelines, leveraging platforms like Snowflake, Trino, or similar technologies.

• Develop optimized SQL scripts for complex data operations, ensuring efficiency across transactional and analytical systems.

• Design and manage data integration processes that handle varied sources and formats, supporting both on-premises and cloud environments.

• Implement data quality checks and monitoring frameworks, and maintain clear documentation of data lineage for transparency and compliance.

• Apply data modeling best practices to structure datasets for analytical and operational use cases; perform profiling to uncover data characteristics and quality issues.

• Partner with business stakeholders to gather requirements and deliver data solutions that meet strategic objectives.

• Create intuitive dashboards and reports using visualization tools to communicate insights and support decision-making.

• Contribute to Agile workflows, ensuring timely delivery of data products in a collaborative environment.

Your skills and experience

• Informatica Power Center - CDI PC, SQL or Oracle, CRON Jobs, Batch based ETL processing, ETL , Unix -KSH/BSH Scripts , Control-M Automation, Data Orchestration and Bsueinss rule validation schemas. Oracle 19, EXA CC Database and Datawarehouse, Marts and Data Agrregation Techniques, Optimization Tuning and Fragmentiation techniques, Normalization.
• Data Exception Stacking and STP Processing. SQL Server 2019, 2022 . Transaction and Data Profilers, DataObjects and Schema Transformation. File Staging Techniques ( flat file, ingesting structured and unstructured data sets ingestion)
• 3–5+ years of practical experience as a Data Engineer, working on complex data ecosystems.
• Strong background in building and maintaining data warehouses and ETL/ELT pipelines across diverse platforms and data formats (structured and semi-structured).
• Advanced proficiency in SQL for both data manipulation (DML) and schema design (DDL) in relational databases, including OLTP and OLAP systems;
• Hands-on expertise in developing ETL workflows that integrate multiple data sources, including batch and streaming ingestion, and applying robust data cleansing techniques.
• Solid understanding of data governance principles such as lineage, observability, and data quality; experience implementing data controls is highly desirable.
• Familiarity with data modeling concepts, with the ability to analyze data domains and dependencies through profiling and exploration.
• Strong communication skills and experience collaborating with stakeholders to translate business needs into technical solutions.
• Practical experience with data visualization tools (e.g., Tableau, Power BI, Looker) to present insights effectively.
• Comfortable working in Agile teams and adapting to iterative development processes.
• Good to Have
• SCD rank- ( Slowly Changing Dimension tables)
• Python knowledge for data processing ​

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.html

We at DWS are committed to creating a diverse and inclusive workplace, one that embraces dialogue and diverse views, and treats everyone fairly to drive a high-performance culture. The value we create for our clients and investors is based on our ability to bring together various perspectives from all over the world and from different backgrounds. It is our experience that teams perform better and deliver improved outcomes when they are able to incorporate a wide range of perspectives. We call this #ConnectingTheDots.