Urgent requirement for a Sr. Snowflake Data Engineer in CA

[Talent Acquisition]

Hi All,

Please find the requirement below and share your updated resume with the rate and visa status to discuss further to sreen...@eniacsys.com

 

Please share only locals who can attend an in -person interview.

 

Role: Sr. Snowflake Data Engineer

Location: Sunnyvale, CA  

Duration: 6 months

Experience: 10+ Years

 

Must Have:

• Hands-on experience with writing Complex queries using – Joins, Self Joins, Views, Materialized Views, Cursor also Recursive, use of GROUP BY, PARTITION BY functions / SQL Performance tuning
• Hands-on experience with ETL and Dimensional Data Modelling – Slowly Changing Dimensions (SCD – Type 1, 2, 3)
• Good understanding of concepts like schema types, table types - fact-dimension etc. like how to design a dimension vs fact, design considerations factored etc.
• Proficiency in Python scripting/programming – using Pandas, PyParsing, Airflow.

• Pandas, Tableau server modules, NumPy, Datetime, Apache Airflow related modules, APIs
• Setting up Python scripts on Data Lab, scheduling processes, connecting with Data Lake (S3 etc )
• Data Pipeline automation
• Strong Python programming skills
• Apache Kafka and Python (using client libraries like Confluent's librdkafka or kafka-python; to send (produce) and receive (consume) messages from Kafka topics.
• Experience building streaming applications, data pipelines, and microservices etc.)

• Good understanding of Snowflake Architecture - experience with designing and building solutions.
• Architecture, design aspects, performance tuning, time travel, warehouse concepts - scaling, clustering, micro-partitioning
• Experience with SnowSQL, Snow pipe
• Good to Have - Experience with Snowflake performance optimization techniques
• Experience with Vertica, Single store
• Lead Experience - Experience interacting with business and independently developing and leading data projects. Collaborating with Offshore and owning overall project delivery.
• Actively participating in discussions with business to understand requirements, perform thorough impact analysis and provide suitable solutions.