Java Full Stack Sr. Developer

Sr. Snowflake Data Engineer


***Candidate must be local to Bay Area. As Cusotmer is not considering relocation candidates for this role.


Key Qualifications


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)
o 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.
o Pandas, Tableau server modules, Numpy, Datetime, Apache Airflow related modules, APIs
o Setting up Python scripts on DataLab, scheduling processes, connecting with DataLake (S3 etc )
o Data Pipeline automation
o Strong Python programming skills
o pache Kafka and Python (using client libraries like Confluent's librdkafka or kafka-python; to send (produce) and receive (consume) messages from Kafka topics.
o Experience building streaming applications, data pipelines, and microservices etc.)
• Good understanding on Snowflake Architecture - experience with designing and building solutions.


o rchitecture, design aspects, performance tuning, time travel, warehouse concepts - scaling, clustering, micro-partitioning
o Experience with SnowSQL, Snowpipe
• Good to Have - Experience with Snowflake performance optimization techniques
• Experience with Vertica, Singlestore
• Lead Experience - Experience interacting with business and independently develop and lead data projects. Collaborating with Offshore and owning overall project delivery.
• ctively participating in discussions with business to understand requirements, perform thorough impact analysis and provide suitable solutions.

Diverse Lynx LLC is an Equal Employment Opportunity employer. All qualified applicants will receive due consideration for employment without any discrimination. All applicants will be evaluated solely on the basis of their ability, competence and their proven capability to perform the functions outlined in the corresponding role. We promote and support a diverse workforce across all levels in the company.