Senior Developer / Lead (ODI / Snowflake)

Stridely Solutions Corporation; Cambridge; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A leading technology solution provider in Canada is seeking a Senior Developer / Lead to design and implement data loading solutions using Oracle Data Integrator and Snowflake. The ideal candidate will have strong debugging skills, knowledge of ETL processes, and be able to work collaboratively in a dynamic environment. This position offers competitive salary and career advancement opportunities.

Benefits

Competitive salary and benefits package

Opportunities for career advancement

Dynamic work environment

Collaborative team culture

Qualifications

• Good knowledge of Oracle Data Integrator interfaces and design.
• Experience with ETL processes and unit testing.
• Strong understanding of SQL for DDL and DML commands.

Responsibilities

• Design and develop data loading interfaces into Oracle.
• Develop packages using ODI tools and procedures.
• Implement and debug jobs using operator navigator.

Skills

ODI commands usage

Debugging skills

Knowledge of Snowflake

Problem-solving

Team collaboration

Communication skills

Job description

Overview

Position: Senior Developer / Lead (ODI / Snowflake)

Location: Cambridge, Canada

Working Days: 5 Days a week, Hybrid (3 Days Work From Office, 2 Days Work From Home)

Responsibilities

• Designed and developed interfaces to load the data from multiple sources like flat files into Oracle database, DB to DB.
• Developed packages and scenarios using interfaces, variables, sequences, and procedures.
• Good knowledge of Topology, Designer, and Operator in Oracle Data Integrator.
• Good knowledge of Snowflake.
• Debugging the master jobs and packages by using the operator navigator.
• Worked with knowledge modules like LKM, IKM, and CKM.
• Have knowledge about Changed Data Capture.
• Have knowledge about Work Repository tables.
• Ability to work individually as well as in a team with excellent problem-solving skills.
• Good communication skills, self-motivated, quick learner, hard worker, and responsible.
• Used ODI commands like OdiFileMove, odiFileAppend, odiFilecopy and SQL upload.
• Implemented SCD type1 and SCD type2.
• Involved in unit testing at various levels of ELT flows.
• Knowledge in OLTP / OLAP System Study and like Star schema and Snowflake schema.
• Knowledge of Fact, dimensional tables, and slowly changing dimensions.
• Experience in SQL on creating DDL and DML commands.

Benefits

• Competitive salary and benefits package.
• Opportunities for career advancement and professional development.
• Dynamic work environment with a collaborative team culture.

How to apply

If interested, please share your resume on

Company Description

• STRIDELY SOLUTIONS IS AN ISO 9001:2015 CERTIFIED LEADING GLOBAL TECHNOLOGY SOLUTION PROVIDER ENABLING YOU TO AVAIL DIGITAL TRANSFORMATION SOLUTIONS BASED ON CUTTING-EDGE TECHNOLOGY TOOLS AND PLATFORMS.
• WE ARE TRUSTED GLOBAL PARTNERS OFFERING SERVICES INTO SAP, IOT, RPA, ADVANCED ANALYTICS, MICROSOFT DYNAMICS, & MICROSOFT CRM HAVING HIGHLY QUALIFIED TEAM OF 450+ TECHNO BRAINS WITH OUR DIRECT PRESENCE IN INDIA, USA AND CANADA.
• WE BOAST OF HAVING EXTENSIVE EXPERIENCE OF AUTOMATING BUSINESS PROCESSES AND TECHNOLOGY PLATFORM MIGRATION, WITH COMMITTED TECHNO-ENTHUSIASTS TO PROVIDE QUALITY ENTERPRISE SOFTWARE SOLUTIONS THAT ADDS VALUE TO GENERATE A FAVORABLE RETURN ON YOUR INVESTMENT.
• WORKING WITH OUR CLIENTS MORE LIKE ASSOCIATES AND PARTNERS IS OUR STANDARD ENGAGEMENT MODEL.