Report this job

---

What is the problem? *

Incorrect company
Incorrect location
Job is expired
Job may be a scam
Other

Role: ETL Architect(Snowflake)

Duration: 6-12months

Exp: 10+

Visa: Any Visa except OPT/CPT

ELT architect (5+ years ELT design and developer experience)

• 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.