Snowflake Data Engineer - Hartford, CT (

Snowflake Data Engineer

Location: Hartford, CT (Remote) 6 months Contract Salary: DOE $/hr. on w2 only US citizens and Green Card only, No third Party OPT-EAD also consider No third Party

Required:

• 5 years of relevant experience in oracle and 4 years of experience in snowflake.
• Analyze data design and build AWS S3 folder structure and Snowflake tables to capture all data elements and load data while maintaining data lineage and operational tracking.
• 4 years with oracle database development Code Conversion experience from oracle to snowflake.
• 2 years' experience in Snowflake
• 2 years' experience in Cloud AWS Technologies experience.
• Should be very strong in creating stored procedures UDF in snowflake.
• Should have experience in converting code from oracle to snowflake Should have good experience in oracle development.
• Should have experience working with multiple file formats especially with Parquet and Avro on snowflake database.
• Should have experience with moving data using Snowpipe from S3 to Snowflake.
• Should have experience in writing Stored procedures using java scripting in snowflake.
• Provide guidance or assistance to client vendor on setting up processes to extract and deliver data for consumption on snowflake.
• Maintain documentation manage source code and deployments and implement best practices Lead on aspects of day to day delivery in agile and DevOps delivery environments.
• Lead and guide other developers coordinate and oversee assignments timing and quality of their deliverables.
• Oracle AWS certification is a plus