Snowflake Lead

13 Jul 2024

Vacancy expired!

Hi, I would like to share an excellent opening Full time

“Snowflake Lead” do go through the details and kindly send me the updated resume.

Location : Dallas, TX

Type of Hire : Full time

Mode of interview : WebEx / Teams

Client : Tech Mahindra

Job Description :
Total industry experience between 10+ years Experience in building engineering pipeline Demonstrate expertise in snowflake data modeling and ETL using snowflake SQL implementing complex stored procedures and best practices with data warehouse and ETL concepts Demonstrate expertise on programming using snowflake concepts like orchestration of jobs – moving files from FTP to S3 bucket Demonstrate good RestAPI knowledge and strong AWS concepts Experience in using Semi-structured data
  • Building resilient engineering pipelines within Snowflake.
  • Have a good understanding of any ETL/ELT tool which brings in data to Snowflake like "DBT/Matillion/Hevodata/Fivetran/etc"
  • Strong PL/SQL skills.
  • Programming using snowflake with language as SQL(having JAVA is an added advantage).
  • Should be able to create CTEs, Complex nested views, tasks, streams, different kind of tables, etc within Snowflake.
  • Orchestration of jobs – from AWS-S3 till Snowflake by using various "bulk loading"/"Snowpipe"/etc should be clear.
  • In AWS, should be familiar with services like S3, SNS, SQS, File transfer protocols, storage integrations, etc
  • API familiarity within AWS is an advantage.
  • In Snowflake should be able to demonstrate skills of processing the semi-structured data sets and have used a flattening functions.
  • Ability to do performance tuning within Snowflake.
  • Ability to also do some code reviews and should be able to guide team on Snowflake best practices.
  • Thanks and Regards,

    Abrar Shaikh

    Ztek Consulting Inc.,Phone: E-mail: Visit us at www.ztek-inc.comLinkedIn Profile: https://www.linkedin.com/in/abrar-shaikh-576321a0/

    • ID: #44049190
    • State: Texas Dallas / fort worth 75201 Dallas / fort worth USA
    • City: Dallas / fort worth
    • Salary: Depends on Experience
    • Job type: Permanent
    • Showed: 2022-07-13
    • Deadline: 2022-09-10
    • Category: Et cetera