Snowflake Architect

Job Title : Snowflake Architect


Location: Charlotte, NC 28217 (Onsite)


Duration: 12+ Months


Implementation Partner: Infosys


Minimum Work Experience: 10-15 Years

Job Details:


Facilitate design and develop processes utilizing best standards.


Develop solutions in accordance with the client specifications.


Assist development teams to maintain all data sources and data storage options.


Coordinate with application team and develop all ETL processes.


Provide an efficient interface with brand for all processes across various platforms.


Administer all requests and analyse issues and provide efficient resolution for same.


Prepare codes for all modules according to require specification Design all programs and systems and associate documentation for same.


Strong knowledge of snowflake functions and features Past experience in building denormalized data sets for analytics; data sets can be batch or near real time in refresh frequency Experience in migrating other databases to Snowflake Experience in creating and enhancing framework to build data sets Strong skills in Snowflake Multi - Cluster Warehouses, Snowflake Clone and Time Travel.


Understanding of Snowflake Multi-cluster Size and Credit Usage.


Experience in Snowflake cloud technology.


Experience in building Snow pipe.


Understanding of views, Synonyms, Indexes, Joins and Partitioning.


Monitor all production issues and inquiries and provide efficient resolution for same.


Evaluate all functional requirements and map documents and perform troubleshoot on all development processes.


Collaborate with application groups to prepare effective solutions for all programs.


Document all technical specifications and associate project deliverables.


Strong in writing complex SQL/PLSQL optimized queries

Must have skills:


At least 5 + yrs. of experience managing large projects with the below experiences Experience in working large teams in Onsite/Offshore model Working experience in Snowflake and ETL expertise Knowledge of existing language runtimes - Python in particular.


Expertise in at least one popular Python framework (like Django, Flask or Pyramid) Strong knowledge of DW/BI concepts Good Communication skills