Data Engineer

Job Title: Data Engineer
Location: Sunnyvale, CA
Duration: 6 months (Extendable)
Pay Range: $50-55/Hour on W2/C2C (All Inclusive)
Request ID: 112557-1

Position Summary:
MUST HAVE: Python| AI| Data Quality Frameworks 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 Dimensionso 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 and programming using Pandas| PyParsing| Airflow.oPandas| Tableau server modules| Numpy| Datetime| Apache Airflow related modules| APIsoSetting up Python scripts on DataLab| scheduling processes| connecting with DataLake o Data Pipeline automation Strong Python programming skills oApache Kafka and Python oExperience building streaming applications| data pipelines| and microservices etc. Good understanding on Snowflake Architecture - experience with designing and building solutions. o Architecture| design aspects| performance tuning| time travel| warehouse concepts - scaling| clustering| micro-partitioning o Experience with SnowSQL| SnowpipeGood to Have - Experience with Snowflake performance optimization techniquesExperience with Vertica| SinglestoreLead Experience - Experience interacting with business and independently develop and lead 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.