Senior Developer / Lead (ODI / Snowflake)

Job Description

Job Description

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)

Please share your resume on

Job Descriptions :

• 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, 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

Benefits :

If interested, please share your resume on

Company Description

Company Description