TechDigital Group
Job Title:
Snowflake Data Engineer Job Requirements: Extensive experience in Snowflake data migration, preferably from DB2 to Snowflake. Proficiency in Snowflake SQL and snowproc. Strong understanding of data migration techniques. Experience with AWS cloud platform. Experience in Informatica/Abinitio. Experience in building ETL pipelines using Python, Spark, and AWS Glue. Responsibilities: Schema Migration – Index, Constraints, and Stored Procedures. 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 and solve performance and scalability issues. Build, monitor, and optimize ETL and ELT processes with data models. Ensure archival strategy. 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, including data types. Maintain test results and validation activities in a tracker. Collaborate with Business/Tech SME to write test cases for data validation. Facilitate user-level testing. Prepare test case scenarios for validation or performance testing across DB2 data set vs Snowflake staging tables/data mart.
#J-18808-Ljbffr
Snowflake Data Engineer Job Requirements: Extensive experience in Snowflake data migration, preferably from DB2 to Snowflake. Proficiency in Snowflake SQL and snowproc. Strong understanding of data migration techniques. Experience with AWS cloud platform. Experience in Informatica/Abinitio. Experience in building ETL pipelines using Python, Spark, and AWS Glue. Responsibilities: Schema Migration – Index, Constraints, and Stored Procedures. 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 and solve performance and scalability issues. Build, monitor, and optimize ETL and ELT processes with data models. Ensure archival strategy. 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, including data types. Maintain test results and validation activities in a tracker. Collaborate with Business/Tech SME to write test cases for data validation. Facilitate user-level testing. Prepare test case scenarios for validation or performance testing across DB2 data set vs Snowflake staging tables/data mart.
#J-18808-Ljbffr