Job Description :
Snowflake Architect
Location: 100% REMOTE
Duration: 6 Months plus

Pre-Qualifying Questions:
1. Have you migrated Oracle data sources into Snowflake Data Warehouse?
2. Have you used dimensional modeling?
3. Have you used Metadata driven ETL development using Matillion?
4. Have you used S3 as a data source into Snowflake staging area?
5. Have you worked on Matillion for ETL development?
6. Have you used Tableau on top of Snowflake for reporting?

IT General
Snowflake- Data migration into Snowflake Data Warehouse
Matillion- Metadata driven ETL development, mapping development testing validation, data migration into cloud.
AWS- Cloud RDS in MS SQL server

Minimum 15+ years of relevant experience in ETL Design/Development in (Talend, Pentaho, Matillion, Informatica-Cloud-IICS)
Experience designing and delivering complex, large-volume cloud data warehouse applications
Experience on architecting, Data Modeling, Schema Design, ETL Design, ETL development mapping
Strong experience in advanced SQL programming
Experience in ETL system design and development with Matillion is essential.
Working knowledge of Snowflake, Snowflake stages and integrations with it is essential.
Experience with best practice Snowflake architecture experience is required.
Experience to work with ETL tools (Matillion) to migrate data into Snowflake cloud data warehouse from Oracle-OBIEE sources
Develop, maintain, and enhance unit test suites to verify the accuracy of ETL processes,
Dimensional data (dimensions, facts, aggregate tables design), OLAP cubes and various forms of BI content including reports, dashboards, and analytical models.
ELT (Extract Load Transform) experience is plus in cloud data warehousing
Designing and creating reusable generic parameterized extraction, transformation and load pipelines.
Unix familiarity and shell scripting experience

The candidate will be expected to develop an understanding of customer data sources in OBIEE, understanding existing dashboards for data need, contribute to functional requirements documentation, work with stakeholders to design ETL/ELT migration strategy into Snowflake Data Warehouse/Data Lake. Design, develop, test ETL mappings in Matillion to migrate into Snowflake. Design metadata driven ETL development using Matillion. The candidate will provide technical solutions to a wide range of difficult business problems. These solutions must be innovative, thorough, practical, technically sound and consistent with organizational objectives.

Similar Jobs you may be interested in ..