• Us Citizen

• Green Card

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 9th Apr 2021

·         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 
·         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