CIBC Bank

Chicago IL (hybrid onsite, 2-days per week)

Sr ETL/Data Engineer (Talend/SQL)

What You'll Be Doing

By joining company's Capital Markets Enterprise Solutions Group, you'll be at the heart of a team bringing innovative technology to life as part of our digital transformation. As a Senior Data Engineer/ETL Developer, you'll contribute to the technical design, development and integration of cross-functional, multi-platform application systems. You'll build easy, flexible, and personalized banking solutions that enhance client experience and help build the bank of the future.

We have worked with our client here in Chicago and Canada the last 7 years helping them build out their agile development teams in support of their digital transformation to . Azure Cloud, Azure SQL, Databricks, and ADF

The core of the current work on their CECEL (Anti-Money Laundering) systems. Doing ETL work out of their data in AML/Loan Origination applications using Talend, AzureSQL, Query development/optimizations, EDW Development

• Experience in ETL/ELT specifically on data heavy applications like Enterprise Data warehouses
• Have good knowledge of Kimball Imnon models - SCD, Dimensions, Facts, Data modeling - Star, snowflake
• SSIS is good, but if they also have experience with tools like Informatica, Datastage, Talend, Pyspark, Databricks - that is great. We will be working heavily in Talend as of now (can teach if experienced in Informatica or Datastage)

How You'll Succeed

• Business Systems Expertise - Be the subject matter expert in business systems. Use your knowledge to define and document requirements for data, workflow, processes, systems, internal and external checks, controls and outputs to ensure the application exceeds expectations.

• Programming Knowledge - Design and development of specifications and perform code reviews. Test, debug, document, and manage changes to ensure the successful implementation and maintenance of programs.

• Leadership Skills - Regularly offer guidance and support to fellow developers. Provide strategic, informed recommendations to senior management, and keep up to date on current technology trends.

Who You Are

• You can demonstrate experience in SQL, EDW Concepts, Kimball Methodology, Azure SQL or similar cloud db experience, Talend or similar ELT/ETL tools (Informatica, or Datastage) ETL testing, and working in both business facing and scrum team facing role with strong communication and collaboration capabilities. Databricks, Spark are a plus

• You have a degree/diploma in Computer Science, SW Engineering/or related programming degree/diploma.

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

• You're digitally savvy. You seek out innovative solutions and embrace evolving technologies. You can easily adapt to new tools and trends.

• You give meaning to data. You enjoy investigating complex problems, and making sense of information. You're confident in your ability to communicate detailed information in an impactful way.

• Values matter to you. You bring your real self to work and you live our values - trust, teamwork, and accountability.

As Part Of Our Team, You Will

You'll become part of a diverse community that acknowledges everyone's unique talents, and empowers teams to do what's right for the client, and to do it well. What our company knows - our people are our greatest asset.

• Thrive: Benefit from an open and approachable culture that provides the flexibility and support you need to integrate your life at work and at home

• Connect: Work in a place where the right technology and infrastructure fosters innovation, collaboration and creativity

• Develop: Grow your skills and career through our best-in-class onboarding experience, ongoing learning opportunities, and individual development planning.

• Prosper: Share in our collective success with a competitive salary, incentive pay, banking benefits, health benefits program, and employee share purchase plan

Required Skills : - 10+ years overall experience in ETL/Data Engineering -Talend ETL Development Experience (hands-on experience). -Informatica or Datastage Experience is also suitable -Strong Skills in Star Schema, Data modeling, SQL, Kimball Methodologies, Div/Fact Tables, and Data Warehousing - Experience working in Data Lake environments - Azure SQL, Azure Devops -Superb communication skills
Background Check :Yes
Notes :
Selling points for candidate :
Project Verification Info :
Candidate must be your W2 Employee :No
Exclusive to Apex :Yes
Face to face interview required :No
Candidate must be local :Yes
Candidate must be authorized to work without sponsorship ::No
Interview times set : :No
Type of project :Development/Engineering
Master Job Title :Dev: .NET
Branch Code :Chicago