Snowflake Data Engineer - NV

01 Jul 2024

Vacancy expired!

Must have total 10+ 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 migration projects and 3 end to end data warehouse implementations on-premise & cloud.Should have very good hands on experience in ETL tools like Informatica, Talend , SAP BODSShould have very good hands on experience in API handling, Java, PythonShould be well versed in Data modelling & architectureExpertise in Snowflake data modelling, ELT using Snowflake SQL, implementing complex stored Procedures and standard DWH and ETL conceptsExpertise 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 featuresExpertise in deploying Snowflake features such as data sharing, events and lake-house patternsHands-on experience with Snowflake utilities, SnowSQL, SnowPipe, Big Data model techniques using PythonExperience in Data Migration from RDBMS to Snowflake cloud data warehouseDeep understanding of relational as well as NoSQL data stores, methods and approaches (star and snowflake, dimensional modelling)Experience with data security and data access controls and designBuild processes supporting data transformation, data structures, metadata, dependency and workload managementProficiency in RDBMS, complex SQL, PL/SQL, Unix Shell Scripting, performance tuning and troubleshootProvide resolution to an extensive range of complicated data pipeline related problems, proactively and as issues surfaceCertified Snowflake cloud data warehouse Architect (Desirable).Should be able to troubleshoot problems across infrastructure, platform and application domains.Resolve technical issues of projects and Explore alternate designsGood to have SAP HANA experience & Cloud technology skillsets

  • ID: #43738836
  • State: California Santaclara 95050 Santaclara USA
  • City: Santaclara
  • Salary: Depends on Experience
  • Job type: Contract
  • Showed: 2022-07-01
  • Deadline: 2022-08-28
  • Category: Et cetera