Senior ETL Developer (Pentaho), AVP

Position Overview

Job Title: Senior ETL Developer (Pentaho)

Location: Pune, India

Corporate Title: AVP

Role Description

The Senior ETL Pentaho Developer provides technical expertise in data management, data modeling and db design, data integration, data movement and replication, business intelligence, data quality, reference and master data management, data governance.

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

• Perform analysis of business requirements and develop logical and physical data models for data warehouse to support them.
• Provide guidance in the administration of the Pentaho ETL tool including developing best practices of development, administering security, developing job scheduling and monitoring techniques, and all other system responsibility including creating, configuring and applying patch, creating projects, credential mapping, creating users, changing passwords, start stop applications activities.
• Analyze business/functional requirements, review the solution architecture, and develop the technical architecture and detailed design.
• Analyze data issues, identify, and articulate the business impact of data problems.
• Perform code reviews and ensure that all solutions are aligned to pre-defined architectural standards, guidelines, best practices, and meet quality standards.
• Deploy the solution on a high-availability shared service production environment.
• Understand and comply with the established software development life cycle methodology.
• Establish and enhance technical guidelines and best practices for the integration development team.
• Utilize subject matter expertise in area of enterprise applications, solutions to evaluate complex, sensitive business problems and architect technical solutions.
• Keep current with industry technologies and tools in the integration domain.
• Suggest and implement best practices to Optimize ETL processes for performance and scalability. This includes tuning data transformations and load processes to handle large volumes of data efficiently.
• Document ETL processes, data flows, and system architecture. Maintain clear and comprehensive documentation and Architectural artefacts for future reference and troubleshooting.
• Design ETL processes that comply with data governance and security policies. Implement measures to protect sensitive data and maintain compliance with relevant regulations.

Your skills and experience

Technical Skills

• Pentaho Data Integration (PDI): Proficiency in using Pentaho tools for designing, developing, and managing ETL processes.
• Strong knowledge of SQL for querying databases and performing data manipulation.
• Data Warehousing: expertise in implementation of data warehousing concepts, including data modeling, schema design, and data marts.
• Experience with other ETL tools like Informatica, Talend, or SSIS can be beneficial.
• Familiarity with programming languages such as Java, Python, or VBA for scripting and automation
• Knowledge of database design, RESTful APIs, and working with various database systems
• Skills in data profiling, data analysis, and ensuring data quality.

Experience

• Experience in building strategies for ETL implementation.
• Experience in implementing complex ETL projects.
• Hands-on experience in integrating data from multiple sources and ensuring data consistency and quality.
• Experience in setting standards and best practices for optimizing ETL processes for performance and scalability.
• Proven ability to troubleshoot and resolve issues in ETL processes.
• Experience working with cross-functional teams, including business analysts, data scientists, and other stakeholders.

Soft Skills

• Problem-Solving: Excellent analytical and problem-solving skills to address complex data challenges.
• Leadership: Ability to mentor a team of ETL developers, providing guidance and support.
• Suggest and implement Continual improvements w.r.t. ETL.
• Appropriate communication skills to effectively convey technical information to non-technical stakeholders.

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 strive for a in which we are empowered to excel together every day. This includes acting responsibly, thinking commercially, taking initiative and working collaboratively.
Together we share and celebrate the successes of our people. Together we are Deutsche Bank Group.
We welcome applications from all people and promote a positive, fair and inclusive work environment.