Job summary:
Title:
Data Engineer
Location:
Chevy Chase, MD, USA
Length and terms:
Long term - W2 or C2C
Position created on 04/01/2021 05:57 pm
Job description:
**** Webcam interview; *** Long term project *** Initial remote due to covid then onsite***
Required Skills:
- 10+ years of total experience in data projects with focus on data integration and ingestion
- 4+ years of experience in Azure cloud infrastructure for data services with 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
- 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 with data security and data access controls and design
- Deep understanding of relational as well as NoSQL data stores, methods, and approaches (star and snowflake, dimensional modelling)
- Should have experience in Data Migration from RDBMS to Snowflake cloud data warehouse
- Good Understanding of managing account-level and user-level network policies in snowflake with Azure Networking knowledge like VNET peering, NSG, Network Gateways, VPN connectivity
- Good understanding of configuring access with Azure private link
- Hands-on of Data loading and off-loading from Snowflake Database tables
- Exposure to data modeling for Snowflake
- Good knowledge on Snowflake connectors
- Azure experience must be focused on Azure Data Factory, Azure storage solutions (such as Blob and Azure Datalake Gen2) and Azure data pipelines
- Expertise in building data pipelines for Snowflake using Snowpipe, SnowSQL’s and stored procedures.
- Experience in power shell, shell scripting and python
- Good experience on Azure Databricks
- Experience in building data pipelines for large volumes of data across disparate data sources
- Exposure to data modeling for Snowflake
- Knowledge and experience on Big data and Data Vault methodology is a plus.
- Experience in working with agile/scrum methodologies.
- Good communication and presentation skills
- Certified Snowflake cloud data engineer/ Architect (Preferred)
Contact the recruiter working on this position:
The recruiter working on this position is Rajendra Reddy
His/her contact number is +(1) (202) 4706751
His/her contact email is rajr@msysinc.com
Our recruiters will be more than happy to help you to get this contract.