Senior Developer / Lead- Oracle Data Integrator

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

Job summary

A technology solutions company in Cambridge is looking for a Senior Developer / Technical Lead with expertise in Oracle Data Integrator and SQL. The ideal candidate will design and develop data loading interfaces and debug ELT processes. Strong problem-solving and communication skills are essential. This position offers a hybrid work model.

Qualifications

• Experience designing and developing database interfaces.
• Good knowledge of Oracle Data Integrator and its components.
• Familiarity with OLTP/OLAP system studies.

Responsibilities

• Develop and maintain interfaces to load data into the Oracle database.
• Debug master jobs and packages using operator navigator.
• Perform unit testing at various levels of ELT flows.

Skills

Oracle Data Integrator

SQL

Problem-solving skills

Communication skills

Tools

ODI commands

Job description

Overview

Position: Senior Developer / Technical Lead - (ODI / Snowflake)

Locations: Cambridge, Ontario-N3H4R7 (Hybrid Mode)

Job Description

• 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.
• 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, etc.
• Implemented SCD type1 and SCD type2.
• Have knowledge about Changed Data Capture.
• 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.