Senior Developer / Lead (ODI / Snowflake)

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

Job summary

A leading company in technology solutions seeks a skilled data integration developer to design and implement data loading interfaces using Oracle Data Integrator and Snowflake. The ideal candidate will possess strong SQL skills and a problem-solving mindset, contributing to a collaborative team environment focused on delivering quality enterprise solutions.

Benefits

Competitive salary and benefits package

Opportunities for career advancement

Dynamic work environment

Qualifications

• Experience with Oracle Data Integrator and Snowflake is essential.
• Strong SQL skills for creating DDL and DML commands.
• Ability to work independently and collaboratively.

Responsibilities

• Design and develop data loading interfaces into Oracle databases.
• Implement slowly changing dimensions and participate in unit testing.
• Utilize ODI commands for data management tasks.

Skills

Problem-solving

Communication

Self-motivation

Teamwork

Tools

Oracle Data Integrator

Snowflake

SQL

Job description

Location: Cambridge, Canada

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

Please share your resume on

Job Descriptions:

1. Design and develop interfaces to load data from multiple sources like flat files into Oracle database, including database-to-database transfers.
2. Develop packages and scenarios using interfaces, variables, sequences, and procedures.
3. Possess good knowledge of Topology, Designer, and Operator in Oracle Data Integrator.
4. Have good knowledge of Snowflake.
5. Debug master jobs and packages using the operator navigator.
6. Work with knowledge modules like LKM, IKM, and CKM.
7. Have knowledge about Changed Data Capture.
8. Understand Work Repository tables.
9. Ability to work independently and in a team, with excellent problem-solving skills.
10. Possess good communication skills, be self-motivated, a quick learner, hard worker, and responsible.
11. Utilize ODI commands like OdiFileMove, OdiFileAppend, OdiFileCopy, and SQL upload.
12. Implement SCD type 1 and SCD type 2.
13. Participate in unit testing at various levels of ELT flows.
14. Have knowledge of OLTP/OLAP systems, star schema, and snowflake schema.
15. Understand fact tables, dimensional tables, and slowly changing dimensions.
16. Experience in SQL, 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.

If interested, please share your resume on

Company Description:

• We are trusted global partners offering services in SAP, IoT, RPA, advanced analytics, Microsoft Dynamics, and Microsoft CRM, with a highly qualified team of 450+ tech professionals across India, USA, and Canada.
• We have extensive experience in automating business processes and technology platform migration, committed to providing quality enterprise software solutions that add value and generate a favorable return on investment.
• Our standard engagement model involves working with clients as partners and associates.