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.