| Job Title: Snowflake Data Engineer |
| 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. |