Job Title: ETL Pentaho Developer
Corp Title: Associate
Location: Bangalore, India
Role Description
The ETL Pentaho developer is responsible for the design, development, and implementation of ETL processes using Pentaho Data Integration (PDI). This role involves managing data extraction, transformation, and loading (ETL) processes to ensure data is accurately and efficiently processed for business intelligence and analytics purposes.
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
- Managing and optimizing the ETL (Extract, Transform, Load) processes using Pentaho tools.
- Development: Implementation of ETL processes using Pentaho Data Integration (PDI). This includes creating data pipelines to extract data from various sources, transform it into the required format, and load it into target systems.
- Ensure seamless integration of data from multiple sources, maintaining data quality and consistency. This involves working with different data formats and structures.
- Optimize ETL processes for performance and scalability. This includes tuning data transformations and load processes to handle large volumes of data efficiently.
- Work closely with business analysts, data Architects, and other stakeholders to understand data requirements and deliver solutions that meet business requirements.
- Document ETL processes, data flows, and system architecture. Maintain clear and comprehensive documentation for future reference and troubleshooting.
- Provide support for ETL processes, including troubleshooting issues and implementing fixes. Ensure data accuracy and integrity throughout the ETL lifecycle.
- Lead ETL projects, including planning, scheduling, and coordinating tasks. Ensure projects are delivered on time and within scope.
- Ensure that ETL processes 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: Understanding 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 implementing complex ETL projects.
- Hands-on experience in integrating data from multiple sources and ensuring data consistency and quality.
- Experience in 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 lead and mentor a team of ETL developers, providing guidance and support.
- Attention to Detail: Meticulous attention to detail to ensure data accuracy and integrity.
- 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:
https://www.db.com/company/company.html
We strive for a culture 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.
Skills Required
- Proficiency in Pentaho Data Integration (PDI)
- Strong knowledge of SQL
- Experience in implementing complex ETL projects
- Experience in optimizing ETL processes
- Ability to lead and mentor a team
- Experience with other ETL tools like Informatica, Talend, or SSIS
Deutsche Bank Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Deutsche Bank and has not been reviewed or approved by Deutsche Bank.
-
Healthcare Strength — Health coverage is positioned as comprehensive, spanning multiple medical plan options along with dental, vision, prescription coverage, life insurance, and disability protection.
-
Leave & Time Off Breadth — Time away is described as generous, including annual leave, sick leave, public holidays, wellbeing leave, volunteering leave in some regions, and expanded bereavement leave in certain locations.
-
Retirement Support — Retirement support is presented as a matched savings plan (401(k)), reinforcing longer-term financial security as part of the rewards package.
Deutsche Bank Insights
What We Do
At Deutsche Bank, we give original thinkers the space and support they need to shine. Merging local knowledge with global vision, in-depth insight with industry-leading digital expertise, if you’re an innovator by nature, we can help you to unleash your potential. We see things differently at Deutsche Bank – and we’re proud of our fresh perspective. Today, we’re driving growth through our strong client franchise, investing heavily in digital technologies, prioritising long-term success over short term gains, and serving society with ambition and integrity. Wherever your interests lie – in investment banking, trading, private wealth, asset management, retail banking - or many of the infrastructure functions that support them – you’ll discover resources, training and opportunities designed to keep you ahead of the curve. Intelligence has no boundaries: we welcome high-achieving, talented individuals from any background. If you’re full of imagination, enjoy solving problems and respond positively to complex challenges, discover a career to look forward to and join us!
.png)
