Azure Etl Data Engineer

Toronto, ON, Canada

Job Description


We\xe2\x80\x99re building a relationship-oriented bank for the modern world. We need talented, passionate professionals who are dedicated to doing what\xe2\x80\x99s right for our clients.

At CIBC, we embrace your strengths and your ambitions, so you are empowered at work. Our team members have what they need to make a meaningful impact and are truly valued for who they are and what they contribute.

To learn more about CIBC, please visit



What you\'ll be doing:

  • As data engineer within the Capital market Technology Group, you\xe2\x80\x99ll develop applications using existing and emerging technology platforms, being a key team member supporting the applications.
  • Design and develop ETL processes flows to varies integrations points, understand data and cleans effectively based on functional and non-functional requirements in Azure platform
  • Understand the full end to end development activities from design to go live for ETL development in Azure platform
  • Recommend and execute improvements
  • Document component design for developers and for broader communication.
  • Understand and adopt an Agile (SCRUM like) software development mindset
  • Follow established processes/standards, business technology architecture for development, release management and deployment process
  • Execute and provide support during testing cycles and post-production deployment, engage in peer code reviews.
How you\'ll succeed

Design and development - Perform and coordinate complicated application programming activities. Design the application\'s technical infrastructure using specific databases, programming languages, utilities, and testing approaches. Lead the design and development of cost-effective and innovative solutions.

Strategic planning - Develop multi-year technology roadmaps that align with the bank\xe2\x80\x99s vision, strategy, and business goals. Lead multiple complicated projects involving backend systems, new technology, and the enhancement of existing applications.

Leadership skills - Act as the mobile development team lead and run code-review sessions with the wider team to ensure the project is on track to meet goals. Support and mentor intermediate and senior developers by sharing knowledge, collaborating and problem solving.

Who you are

You embrace and advocate change. You\'ll continuously evolve your thinking and the way you work in order to deliver your best.

Your influence makes a difference. You know that relationships and networks are essential to success. You inspire outcomes by sharing your expertise.

You\xe2\x80\x99re digitally savvy. You seek out innovative solutions and embrace evolving technologies. You can easily adapt to new tools and trends.

You\'re motivated by collective success. You know that teamwork can transform a good idea into a great one. You know that an inclusive team that enjoys working together can bring a vision to life.

You can demonstrate experience in:
  • Working experience in Azure Data Factory, Azure Databricks, ADLS, Azure SQL DB, Azure Synapse.
  • Hands-on experience in Python / Spark / Pyspark / JSON
  • Working experience with data modeling, relational modeling and dimensional modeling
  • Current/previous experience of working extensively on DW environment and ETL tools like Informatica, DataStage, SSIS.
  • Strong understanding of database and data warehousing concepts with experience in writing SQL queries, create functions, stored procedures and packages in oracle or Azure SQL.
  • Microsoft Azure certified \xe2\x80\x93 Data Engineer (good to have)
  • General knowledge about file formats (e.g. XML, CSV, JSON), databases (e.g. MS SQL, Oracle) and different type of connectivity like API integration.
  • Source-code versioning/promotion tools, e.g. Git/TFS/DevOps
  • Orchestration tools in Azure platform
Values matter to you. You bring your real self to work and you live our values - trust, teamwork, and accountability.

What CIBC offers

At CIBC, your goals are a priority. We start with your strengths and ambitions as an employee and strive to create opportunities to tap into your potential. We aspire to give you a career, rather than just a paycheck.

We work to recognize you in meaningful, personalized ways including a competitive salary, incentive pay, banking benefits, a health benefits program, defined benefit pension plan, an employee share purchase plan 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

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

What you need to know

CIBC is committed to creating an inclusive environment where all team members and clients feel like they belong. We seek applicants with a wide range of abilities and we provide an accessible candidate experience. If you need accommodation, please contact

You need to be legally eligible to work at the location(s) specified above and, where applicable, must have a valid work or study permit.

Job Location Toronto-CC East 13th Floor

Employment Type Regular

Weekly Hours 37.5

Skills

API Integration, Back-End Development, Emerging Technologies, Relational Modeling, SQL Server Integration Services (SSIS), Structured Query Language (SQL)

CIBC

Beware of fraud agents! do not pay money to get a job

MNCJobz.com will not be responsible for any payment made to a third-party. All Terms of Use are applicable.


Related Jobs

Job Detail

  • Job Id
    JD2109772
  • Industry
    Not mentioned
  • Total Positions
    1
  • Job Type:
    Full Time
  • Salary:
    Not mentioned
  • Employment Status
    Permanent
  • Job Location
    Toronto, ON, Canada
  • Education
    Not mentioned