Data ArchitectSnowflake Architect

Job Title: Data Architect (Snowflake + Informatica PC)

Location: Plainsboro, NJ (Onsite)

Hire Type: Contract

Primary Skills

• Data Warehousing
• DataStream
• ETL Fundamentals
• Python
• Snowpipe
• SnowSQL
• SQL,
• SQL (Basic + Advanced)
• Time Travel
• Fail Safe

Secondary Skills

• Informatica PC
• Tableau
• Snowflake

Job requirements

• Demonstrated ability to have successfully completed multiple, complex technical projects and create high-level design and architecture of the solution, including class, sequence, and deployment infrastructure diagrams
• Take ownership of technical solutions from design and architecture perspective for projects in presales phase as well as on-going projects
• Experience with gathering end user requirements and writing technical documentation
• Time management and multitasking skills to effectively meet deadlines under time-to-market pressure
• Suggest innovative solutions based on new technologies and latest trends to sales team
• Review the architectural/ technological solutions for ongoing projects and ensure right choice of solution
• Work closely with sales team and clients to understand their business, capture requirements, identify pain areas, accordingly, propose an ideal solution and win business Key Competencies:
• Must have total 12 yrs. in IT and 3 years' experience working as a snowflake Data Architect and 8 years in Data warehouse, ETL, BI projects
• Must have experience at least two end-to-end implementation of Snowflake cloud data warehouse
• Expertise in Snowflake data modelling, ELT using Snowflake SQL, implementing complex stored procedures and standard DWH and ETL concepts
• Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, zero copy clone, time travel and understand how to use these features
• Expertise in deploying Snowflake features such as data sharing, events, and lake-house patterns
• Hands-on experience with Snowflake utilities, SnowSQL, SnowPipe, Big Data model techniques using Python
• Experience in Data Migration from RDBMS to Snowflake cloud data warehouse
• Deep understanding of relational as well as NoSQL data stores, methods, and approaches (star and snowflake, dimensional modelling)
• Expertise in Snowflake advanced concepts like setting up resource monitors, RBAC controls, virtual warehouse sizing, query performance tuning, Zero copy clone, time travel and understand how to use these features
• Experience with data security and data access controls and design
• Experience with Azure data storage and management technologies such as ADLS
• Build processes supporting data transformation, data structures, metadata, dependency and workload management
• Proficiency in RDBMS, complex SQL, PL/SQL, Unix Shell Scripting, performance tuning and troubleshoot
• Provide resolution to an extensive range of complicated data pipeline related problems, proactively and as issues surface
• Must have expertise in Azure Platform as a Service (PAAS)
• Certified Snowflake cloud data warehouse Architect (Desirable)
• Should be able to troubleshoot problems across infrastructure, platform, and application domains
• Must have experience of Agile development methodologies
• Strong written and communication skills
• Effective and persuasive in both written and oral communication

Nice to have skills:

Architect level certification from AWS / Azure / GCP

Experience being part of Snowflake Practice/COE

Data Science / AI ML implementation experience