ApTask
Snowflake Data Engineer
ApTask, Sunnyvale, California, United States, 94087
About Client:
The Client is a leading global IT services and consulting company, providing a wide range of services to clients in various industries, including banking, financial services, retail, manufacturing, healthcare, and more. It is one of the largest employers in the IT industry and has a vast and diverse workforce. The company places a strong emphasis on employee training and development. Client is known for its commitment to innovation and invests in research and development to stay at the forefront of technological advancements.It offers a comprehensive set of services, including:IT Services: Application development, maintenance, and testing.Consulting: Business consulting, IT strategy, and digital transformation.Business Process Outsourcing (BPO): Outsourcing of business processes to improve efficiency.Enterprise Solutions: Implementation and support of enterprise-level software solutions.Digital Services: Services related to digital technologies, such as analytics, cloud, and IoT.Rate Range: $110K-$135K/AnnumJob Description:8+ years of relevant experience as a Data EngineerSnowflake (mandatory and preferably certified) - Strong implementation experience with a good understanding of Snowflake Architecture being able to design and implement solutions and having good experience in Snowflake performance optimization techniques.Advanced SQL (mandatory and preferably certified) - Good understanding of the concept of Slowly Changing Dimensions (SCD), be able to write complex queries using Self Joins, Cursors also recursive, Views/Materialized, strong in PL/SQL etc.Strong experience in SQL Performance tuning especially when dealing with large datasets in millions of data.Understanding of Data semantics and data semantic modelsPython (mandatory) - Good experience in PythonExpert in Singlestore procedure.Experience with Cloud Computing (AWS or Google Cloud) for deployment purposes is nice to have.
#J-18808-Ljbffr
The Client is a leading global IT services and consulting company, providing a wide range of services to clients in various industries, including banking, financial services, retail, manufacturing, healthcare, and more. It is one of the largest employers in the IT industry and has a vast and diverse workforce. The company places a strong emphasis on employee training and development. Client is known for its commitment to innovation and invests in research and development to stay at the forefront of technological advancements.It offers a comprehensive set of services, including:IT Services: Application development, maintenance, and testing.Consulting: Business consulting, IT strategy, and digital transformation.Business Process Outsourcing (BPO): Outsourcing of business processes to improve efficiency.Enterprise Solutions: Implementation and support of enterprise-level software solutions.Digital Services: Services related to digital technologies, such as analytics, cloud, and IoT.Rate Range: $110K-$135K/AnnumJob Description:8+ years of relevant experience as a Data EngineerSnowflake (mandatory and preferably certified) - Strong implementation experience with a good understanding of Snowflake Architecture being able to design and implement solutions and having good experience in Snowflake performance optimization techniques.Advanced SQL (mandatory and preferably certified) - Good understanding of the concept of Slowly Changing Dimensions (SCD), be able to write complex queries using Self Joins, Cursors also recursive, Views/Materialized, strong in PL/SQL etc.Strong experience in SQL Performance tuning especially when dealing with large datasets in millions of data.Understanding of Data semantics and data semantic modelsPython (mandatory) - Good experience in PythonExpert in Singlestore procedure.Experience with Cloud Computing (AWS or Google Cloud) for deployment purposes is nice to have.
#J-18808-Ljbffr