Architecture Design - DB2 to SnowflakeExtensive experience in Snowflake data migration preferably DB2 to SnowflakeSchema Migration – Index, Constraints and SPsData Migration – Historical LoadCloud Operations – SnowflakeDesign and implement features for identity and access managementCreate migration/ingestion pipelines into SnowflakeImplement query optimizationSolve performance issues and scalability issuesBuild, monitor, and optimize ETL and ELT processes with data modelsEnsure archival strategyProficiency in Snowflake SQL, snowprocMaintain testing tracker highlighting data comparability between Netezza and SnowflakeData orchestration/development and automation of data workflows (CI/CD)Testing between DB2 tables and Snowflake tables data and data typesMaintain test results, validation activities in a trackerCollaborate with Business/tech SME to write test cases towards data validationFacilitates user level testingPrepares test cases scenarios for validation or performance testing across DB2 data set vs Snowflake staging tables/data mart