Job Description:

• Analyze and understand existing database processes, including packages, cursors, and stored procedures in Oracle DB.
• Design and implement data migration strategies to move data from Oracle DB to Snowflake.
• Transition ETL processes from Informatica to Matillion, ensuring data integrity and performance.
• Collaborate with stakeholders to gather and analyze requirements, ensuring that the migration meets business needs.
• Develop and maintain documentation for data migration processes and ETL workflows.
• Troubleshoot and resolve issues related to data migration and ETL processes.
• Ensure data quality and consistency throughout the migration process.
• Prioritize tasks and manage time effectively to meet project deadlines.
• Qualifications:
• Proven experience in data warehouse migration projects, specifically migrating from Oracle DB to Snowflake.
• Strong knowledge of ETL tools, particularly Informatica and Matillion.
• Proficiency in SQL and experience with database management systems.
• Excellent problem-solving skills and attention to detail.
• Strong communication and collaboration skills.
• Ability to work independently and as part of a team.

Qualifications:

• Experience with cloud-based data warehousing solutions.
• Familiarity with data modeling and data architecture principles.
• Knowledge of data governance and data quality best practices.