ETL Developer

What Youll Be Doing (position summary):

We are seeking a skilled Developer to design, build and optimize scalable data solutions on the Databricks platform. You will work closely with data engineers, analysts and business stakeholders to develop high-performing data pipelines, enable advanced analytics, and ensure a secure, reliable data environment

At CIBC India we enable the work environment most optimal for you to thrive in your role. Details on your work arrangement (including on-site and remote work) will be discussed at the time of your interview.

How Youll Succeed (responsibilities):

• Design, develop and maintain scalable ETL/ELT pipelines using Databricks.
• Design, develop and implement ETL solutions using Informatica Intelligent Cloud Services (IICS) and IDMC.
• Strongs hands on development experience with Informatica PowerCenter.
• Strongs Hands on experience in SQL with databases such as Oracle.
• Develop and optimize complex SQL queries for data processing and reporting.
• Analyzing business requirements and translating them into technical specifications.
• Collaborate with clients to understand their data needs and provide tailored solutions that meet their business objectives.
• Ensure data quality, integrity, and security throughout the data lifecycle.
• Manage Databricks clusters, jobs, workspaces & Integrate Databricks with cloud platform ( Azure).
• Leverage PySpark/Spark and SQL to transform and process large datasets.
• Implement rigorous data quality checks and validation procedures throughout the data pipeline to maintain high accuracy and reliability.
• Adhere to data governance policies and best practices.
• Monitor, troubleshoot, and resolve issues related to data pipelines and cluster performance.
• Provide technical leadership and best practices in data engineering and architecture.

CROSS-FUNCTIONAL RELATIONSHIPS

• Collaborates with other operational teams, QA teams, and development teams to define and deliver technical solutions.
• Works closely with infrastructure and operations teams to ensure seamless deployment and integration of applications.
• Partners with project managers and product owners to align technical deliverables with business priorities.

COMPLIANCE REQUIREMENTS/RESPONSIBILITIES

• As an employee of CIBC, the incumbent must comply with all applicable CIBC and Line of Business policies, standards, guidelines and controls.

AUTHORITIES/DECISION RIGHTS

• As a key contributor to the business unit, this job has the authority to recommend changes to business processes in order to enhance operational efficiency and effectiveness.

Experience: 7+ years of experience

Who You Are (skills/qualifications):

• 7+ years of experience in data engineering or related role.
• Azure Databricks, Azure Data Factory and PySpark experience is mandatory.
• Solid understanding of data warehousing principles, ETL processes, data modeling techniques, and database systems.
• Strong analytical and problem-solving abilities, with a proactive approach to identifying and resolving data-related challenges
• Excellent communication and interpersonal skills, with the ability to effectively collaborate with technical and non-technical stakeholders.
• Expert Python and Advanced SQL skills for data querying, transformation, and analysis.
• Hands-on experience with Databricks and Delta Lake.
• Familiarity with CI/CD and version control( Git, DevOps tools).

Good to Have:

• Experience with streaming technologies ( Kafka, Spark Structured Streaming)
• Databricks Certified Data Engineer certification.

About CIBC

CIBC is a leading North American bank, with a history of more than 150 years of living our purpose - to help make your ambition a reality. Client relationships are at the centre of our strategy, and our growth is enabled by a highly engaged and connected global team. From digital banking to community impact, were proud to drive progress for our clients and our communities. Recognized for our culture, award-winning innovation and community investment, CIBC continues to evolve by putting people and progress at the centre of everything we do.

About CIBC India

CIBC India is a technology and operations hub in Hyderabad, where youll be part of our highly engaged and global team, and play a central role in supporting our growth. Whether youre driving innovation in digital banking or streamlining client onboarding, youll be part of a culture recognized for excellence and investment in people. At CIBC India, people and progress are at the centre of what we do: youll develop skills, collaborate with industry leaders, and see your ideas realized in a culture that values progress and belonging. We provide cutting-edge resources, ongoing learning, and a supportive environment where people come first. If youre ready to create meaningful change and build your future, CIBC India is where your ambition meets opportunity.

What CIBC India Offers:

At CIBC India, your goals are a priority. We start with your strengths and ambitions and strive to create opportunities to tap into your potential. We aspire to give you a career that goes well beyond your compensation.

• We work to recognize you in meaningful, personalized ways including competitive fixed pay, performance-based incentive programs, a family-first benefits program, employer contributions for your retirement, attractive time off and leave offerings, wellbeing support, and MomentMakers, our social, points-based recognition program
• Our spaces and technological toolkit will make it simple to bring together great minds to create innovative solutions that make a difference for our clients worldwide
• We cultivate a culture where you can express your ambition through initiatives like Purpose Day, a paid day off dedicated for you to use to invest in your growth and development