JOB DESCRIPTION
" " " Good Experience in designing End to End Architect for Enterprise Cloud using snowflake ,Python, Airflow on AWS
10+ years of experience in DW -SQL Development and Data Analysis required to develop new complex data pipelines/warehouse.
Expert in working on OTT/Realtime data integration using snowflake ,Python, Airflow on AWS
In-depth knowledge of Cloud services
At least 2 full year of recent Snowflake experience
Experience in other Databases like Oracle / Teradata etc.
Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe,
Hands on experience with data loads and managing cloud DB
Handling large and complex sets of XML, JSON, and CSV from various sources and databases
Solid grasp of database engineering and design
Experience with any scripting languages, preferably Python usually as wrapper/housekeeping (like SH)
Leveraged frameworks & orchestration like Airflow as required for ETL pipeline
Identify bottlenecks and bugs in the system and develop scalable solutions
Responsible for analyzing and building Snowflake SQLs
Unit Test & Document deliverables

Required Technical Skills:
Snowflake
Strong SQL
Python
Strong SQL
Other SQL based databases, like Oracle, SQL Server, etc.
AWS Cloud experience
Nice to have:
AWS/Glue
Experience in creation and modification of user accounts and security groups per request
Create AWS services like Lambda, AWS Glue, Step function, etc.
SnowPro Certification
Experience with an ETL tool, like Infomatica, Talend, Matillion, etc " " "