Senior Developer/Lead (ODI/Snowflake)

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:

• 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