Description

• Architecture Design - DB2 to Snowflake
• Extensive experience  in Snowflake data migration preferably DB2 to Snowflake
• Schema Migration – Index , Constraints and SPs
• Data Migration – Historical Load
• Cloud Operations – Snowflake
• Design and implement features for identity and access management.
• Create  migration/ingestion pipelines into Snowflake.
• Implement query optimization.
• Solve performance issues and scalability issues.
• Build, monitor, and optimize ETL and ELT processes with data models.
• Ensure archival strategy. 
• Proficiency in Snowflake SQL, snowproc
• Maintain testing tracker highlighting data comparability between Netezza and Snowflake.
• Data orchestration/development and automation of data workflows(CI/CD)
• Testing between DB2 tables and Snowflake tables data and data types.
• Maintain test results, validation activities in a tracker.
• Collaborate with Business/tech SME to write test cases towards data validation.
• Facilitates user level testing.
• Prepares test cases scenarios for validation or performance testing across DB2 data set vs Snowflake staging tables/data mart

Key Skills

Education

Any Gradute