Must Have
At least 10+ years of hands-on experience in Development/Data Integration/Data Modeling/Data migration
Experience in design or development of enterprise data solutions, applications, and integrations in Snowflake Warehouse environment
Design and develop both physical and logical data models along with define metadata standards for the DW
Develop complex SQL queries, scripts, user defined functions, views, and triggers for business logic implementation in Snowflake Enterprise Data Warehouse
Develop and own ETL Data Pipeline and Data Model solutions for integrating new data sets into the Snowflake Enterprise Warehouse from different sources.
Perform data mapping data between source systems and DW
Develop & execute ETL procedures/pipelines as well monitor and tune data loads and queries
Prepare technical documentation including metadata and diagrams of entity relationships, process flows and others
Create scripts for data warehouse testing ranging from unit to integration testing
Good experience in data migration from various systems to Snowflake warehouse
Strong experience with ELT concepts & tools such as Talend, Matillion
Sound experience in Python scripting to read & load data from
Hands-on experience in Cloud technologies such as
AWS - S3, Glacier, EC2, Lambda, SQS, Redshift
Azure - Blob Storage, Cool Blob Storage, Virtual Machine, Functions, SQL Datawarehouse
Own, monitor, and improve automated solutions to ensure quality and performance SLAs are met
Experience working directly with business users and solving business questions with data
In-depth understanding of database management systems and advantages & disadvantages of different types of systems (OLAP, OLTP, etc.).
Strong experience with Data warehousing methodologies and modelling techniques
Sound experience in working with Massively Parallel Processing (MPP) Analytical Datastores such as Netezza, Teradata
Very good understanding of the Snowflake architecture
Experience in handling semi-structured data (JSON, XML) using the VARIANT attribute in Snowflake
Experience in in Re-clustering of the data in Snowflake with good understanding on how Micro-Partition works inside Snowflake is a plus
Experience in working with Batch and Stream data
Nice to Have
Prior experience in Oracle Financial data is a plus
Experience in Netsuite/Zuora is a huge plus
Advanced data visualization skills using any technology is a plus
Experience in Hadoop, Hive, HBASE, Spark is a plus