ETL Snowflake Lead with AWS & Python, Power BI// Remote initially, Atlanta, GA// (GC or USC must)

Hello,

 

Hope you’re doing well.

 

I have an urgent requirement for which below is the job description:

 

Role: ETL Snowflake Lead with AWS & Python, Power BI exp (GC or USC must)

Duration: 6-12 months

Location : Remote initially, Atlanta, GA

 

Very High Priority

They need to have extensive development experience with AWS. They need to have experience moving data into Snowflake from AWS.  Expert level SQL skills. Snow pipe skills. Power BI.

 

Exp: 10+Years

 

·         Expertise in designing distributed processing in AWS/SnowFlake 

·         Expertise in Python and SQL 

·         Expertise in designing ELT for Star Schema based on Data Model in ERWin 

·         Ability to understand OLTP schema 

·         Expertise to design and develop for hierarchical, late arriving, and conformed dimensions 

·         Expertise in design and development of aggregates 

·         Expertise in designing and developing for error handling and restarts in Airflow 

·         Expertise in orchestrating processes using Airflow 

·         Expertise to design and develop full loads, incremental loads, historical loads 

·         Provide guidance for robust ELT test including functionality and performance 

·         Proven expertise in designing and developing high performing ELT. 

·         Expertise to unit test ELT for functionality and performance 

·         Ability to understand and implements the architecture and report stack already in production in DSS using Snowflake, AWS and Airflow 

·         Preferred Certified SnowPro Advanced: Architect  

·         Good documentation skills 

·         Good communication skills 

·         Experience in using Github. 

 

Skill

Years of Experience

AWS

 

Snowflake

 

Airflow 

 

Github

 

DSS

 

SQL

 

ELT

 

Python

 

OLTP

 

ERWin 

 

 

Thanks & Regards,

Anvita Gupta

Technical Recruiter | ITMC Systems, Inc.

Mobile: 331 239 8113

Fax no. +1 405 724 6001

Anvita@itmcsystems.com |www.itmcsystems.com

Hangouts:-coolanvita.gupta@gmail.com

Let’s connect on LinkedIn:

https://www.linkedin.com/in/anvita-gupta-616595195/

 

 

Leave a Reply