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