Snowflake Data Engineer

Apply Now

Company: Cynet Systems

Location: Alpharetta, GA 30022

Description:

Job Description:

Responsibilities:

rchitecture 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.

Skill Set Required: