Connecting...

W1siziisimnvbxbpbgvkx3rozw1lx2fzc2v0cy9hewfulwluzm90zwnol2pwzy9iyw5uzxitzgvmyxvsdc5qcgcixv0

Snowflake Lead - Sydney

Job Title: Snowflake Lead - Sydney
Contract Type: Contract
Location: Sydney CBD, New South Wales
Industry:
Salary: Negotiable
Reference: 3570_1583708224
Contact Name: Gaurav Bagga
Contact Email: gaurav.b@ayaninfotech.com
Job Published: March 09, 2020 09:57

Job Description


Ayan Infotech has an urgent and immediate requirement for a Snowflake lead for a long term contract job opportunity in Sydney.

All applicants must have full work rights in Australia.

Title: Snowflake Lead
Location: Sydney
Type: Contract (6 months + extensions)

Required Skills and Experience:

Relevant job experience

  • 5-8 years of experience working in a distributed product development environment with 2+ hands on experience in Snowflake Cloud Data warehouse.
  • Must have worked on or knowledge of creation of LDM. Should have experience in data modelling tools such as SqlDBM, ERWIN
  • Expert in Dimensional data modelling. Should be good in Conceptual and logical.
  • Responsible for systems analysis - Design, Coding, Unit Testing and other SDLC activities
  • Requirement gathering and understanding, Analyze and convert functional requirements into concrete technical tasks and able to provide reasonable effort estimates
  • Work proactively, independently and with global teams to address project requirements, and articulate issues/challenges with enough lead time to address project delivery risks
  • Providing expertise in technical analysis and solving technical issues during project delivery
  • Code reviews, test case reviews and ensure code developed meets the requirements
  • Good at Create and maintain optimal data lake architecture Designing large, complex data sets that meet functional / non-functional business requirements

Skills / Competencies

  • Experience with Snowflake utilities, SnowSQL, SnowPipe, Big Data model techniques using Python/Java. Cloud knowledge ( AWS/GCP or Azure) is must.
  • Experience in Data Migration from RDBMS to Snowflake cloud data warehouse.
  • Expertise in migrating stored procedures into Snowflake
  • Experience in deploying solutions in AWS/GCP
  • Experience writing ETL routines for Snowflake in Python or Scala or with any ETL tool
  • Strong communication skills, should be able to communicate effectively with business and other stake holders
  • Demonstrate ownership and initiative taking


  • Experienced in creating data warehouse using complete AWS Cloud tool stack.
  • Worked on the Greenfield implementation for the client, whereby the cloud datawarehouse was built using AWS technology stack.
  • Expertise in ETL design involving Informatica Powercenter, DataStage, SSIS, Kettle, AWS Data Pipeline.
  • Worked on various projects for different Organization on the above ETL tools and technologies

We will be able to contact only shortlisted candidates. We thank you in advance.

www.ayaninfotech.com

Get similar jobs like these by email

By submitting your details you agree to our T&C's