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