Required Skills

Data Engineer

Work Authorization

  • US Citizen

  • Green Card

  • EAD (OPT/CPT/GC/H4)

  • H1B Work Permit

Preferred Employment

  • Corp-Corp

  • W2-Permanent

  • W2-Contract

  • Contract to Hire

Employment Type

  • Consulting/Contract

education qualification

  • UG :- - Not Required

  • PG :- - Not Required

Other Information

  • No of position :- ( 1 )

  • Post :- 3rd May 2025

JOB DETAIL

 

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.

Company Information