Engineer Data

Empower India; Bengaluru; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Canada Life is seeking a Senior ETL Developer in Bengaluru to design, develop, and support complex ETL solutions. You will work within a centralized team responsible for building integration solutions that power data warehousing and BI initiatives.

The role requires strong Ab Initio ETL skills, experience with Informatica/IDMC, and hands-on knowledge of database technologies such as MS SQL Server, Oracle, and DB2. On-site work with collaboration across teams is expected.

Qualifications

• Post-secondary education in business or computer science.
• Minimum 3 years’ IS environment with practical data integration/ETL experience.
• Advanced experience with Ab Initio ETL.
• Experience with Informatica/IDMC.
• Experience with the listed database technologies and data warehousing concepts.

Responsibilities

• Build and support ETL solutions to meet business partner expectations.
• Collaborate with application teams to define requirements.
• Design, develop, and QA ETL workflows.
• Provide production support on ETL jobs as required.
• Automate and optimize integration points and processes.
• Contribute to ETL standards and guidelines.
• Coach and mentor others.
• Performance tune end-to-end integration processes.
• Identify opportunities for reuse across Data Warehouse/Mart and BI.
• Commit to continuous learning and on-call rotation.

Skills

Ab Initio ETL

Informatica/IDMC

Data integration

ETL design

Education

Post-secondary education in business or computer science

Tools

Syncsort DMX ETL

BMC Control-M scheduling

CDC tools

Jira and Confluence

Job description

Our vision for the future is based on the idea that transforming financial lives starts by giving our people the freedom to transform their own. We have a flexible work environment, and fluid career paths. We not only encourage but celebrate internal mobility. We also recognize the importance of purpose, well-being, and work-life balance. Within Empower and our communities, we work hard to create a welcoming and inclusive environment, and our associates dedicate thousands of hours to volunteering for causes that matter most to them.

Chart your own path and grow your career while helping more customers achieve financial freedom. Empower Yourself.

Canada Life is an insurance and financial services company with its headquarters in Winnipeg, Manitoba. we provide a wide range of insurance and wealth management products for individuals, families, and business owners from coast to coast. Canada Life is focused on improving the financial, physical and mental well-being of Canadians and believes in good corporate governance. Our Technology team is a strategic partner in our business – with an ambition to be a forward-thinking, agile technology organization delivering secure, resilient, and leading solutions that support Canada Life and the well-being of millions of Canadians.

Position Summary

At Canada Life, we believe in improving the financial and physical well-being of all the Canadians we serve. The foundation of our strategy is to put the customer at the center of everything we do.

Are you a creative problem solver? Do you like to be challenged? Do you enjoy learning? Are you a team player? Do you like looking for opportunities to automate and improve process? If you answered yes to all these questions, then we would love to talk to you.

The Senior ETL Developer is responsible for designing, developing, and supporting ETL solutions that meet our business partner’s expectations. You will be a member of a centralized team responsible for building and supporting integration solutions.

Key Responsibilities

• Relationship builder who understands the importance of happy clients.
• Works with application teams to understand and define requirements.
• Participates in the design, development, and QA of ETL solutions.
• Performs production support on ETL jobs as required.
• Focuses on continually improving and automating integration points and processes.
• Contributes to the standards and guidelines used to support the ETL application environment.
• Coaches and mentors' others.
• Performance tuning of end-to-end integration processes across the integration platform.
• Identifies opportunity for reuse of objects across Data Warehouse/Mart & ETL BI Solutions.
• Has a focus for continuous learning and professional development.
• Available to join the ETL off hours On-Call Support rotation.

Qualifications

• Post-secondary education in business or computer science or an equivalent combination of training and experience
• Minimum 3 years’ experience in an IS environment with practical experience in application development in data integration (ETL)
• Advanced experience with Ab Initio ETL.
• Experience with Syncsort DMX ETL is an asset.
• Experience with Informatica/IDMC

Experience working with the following database technologies

• MS SQL Server
• Oracle
• DB2 Midrange/Mainframe
• Experience in technical specification design - Proven experience in designing and building operational integrations and standard data warehousing objects (e.g. type-2 dimensions, aggregations, star schema, etc.)
• Solid working knowledge of other software developer toolsets.
• Superior analytical and problem-solving skills.
• Proven ability to develop and maintain collaborative business relationships.
• Effective planning and organizational skills with the ability to adapt to change and perform effectively under pressure.
• Experience supporting the Ab Initio platform is an asset.
• Experience with BMC Control-M scheduling software is an asset.
• Experience with Change Data Capture (CDC) tools are an asset.
• Experience with Collaboration tools like Atlassian’s Jira and Confluence is an asset.

We are an equal opportunity employer with a commitment to diversity. All individuals, regardless of personal characteristics, are encouraged to apply. All qualified applicants will receive consideration for employment without regard to age, race, color, national origin, ancestry, sex, sexual orientation, gender, gender identity, gender expression, marital status, pregnancy, religion, physical or mental disability, military or veteran status, genetic information, or any other status protected by applicable state or local law.