What are the responsibilities and job description for the Lead Snowflake Data Engineer - Banking Clients Mandate position at StratG Inc?
Job Details
Job Requirement (The Skill required) |
Extensive experience in Snowflake data migration preferably DB2 to Snowflake |
Proficiency in Snowflake SQL, snowproc |
Strong understanding of data migration techniques |
Experience with AWS cloud platform |
Experience in Informatica/Abinitio |
Data model, data warehousing |
Experience in Building ETL pipeline using Python, Spark, AWS Glue |
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 |
