Data Engineer

Job Title: Data Engineer - AVP

Location: Pune, India

Role Description

• Testing ETL processes to ensure data accuracy, completeness and integrity throughout the extraction, transformation and loading processes.
• Scripting knowledge to automate the processes.
• Expert in tools like SQL, Python/Java, ETL testing frameworks, Tableau or Google looker.
• Develop and automate test scripts for ETL workflows, data pipelines to ensure database testing coverage.
• Identifying quality issues, collaborate with ETL developers, data engineers to understand data requirements.

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

• Design databases that are functional, dependable, and stable - Partner with development teams to design data management and governance protocols, manage the information lifecycle, design infrastructure, and data integration controls
• Understanding business strategy and cascades business intelligence needs to the database level Execute tests and update databases in accordance with requests.
• Develop and maintain complex models and logical database designs.
• Create and Maintaining the ETL system to ensure data accuracy and integrity throughout the ETL process including  data validation, cleansing, deduplication, and error handling to ensure reliable and usable data.
•  Monitor its performance, updating ETL scripts and workflows as business requirements change, and ensuring the system scales with data growth.
• Perform performance tuning for optimizing ETL processes for speed and efficiency, addressing bottlenecks, and ensuring the ETL system can handle the volume, velocity, and variety of data.
• Create technical and training guides.
• Support users' data management.
• Verify that all database programs adhere to the organization's and performance standards.
• Conduct research and make recommendations for fresh database services, products, and methods.

Your skills and experience

• Proven work experience (10+ years) as a Database developer. Proficient with relational databases (e.g. Oracle, SQL Server, MySQL, PostgreSQL)
• In-depth understanding of data management (e.g. permissions, recovery, security and monitoring)
• Experience in designing and implementing database structures and automating data flows and DBA tasks
• Experience with data modeling and schema design.
• Demonstrated experience in tuning database and its objects
• Understanding of database design practices, including database normalization concepts
• Familiarity with working with JavaScript, HTML, Net Framework, and Oracle.
• Excellent analytical and organisational skills.
• Understanding the needs of front-end users and having a problem-solving mindset.
• Excellent verbal and written communication skills.
• Degree in Computer Science or relevant field

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:

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.