ApTask
Snowflake Developer
ApTask, San Francisco, California, United States, 94199
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.
Salary Range: $110K-$130K/Annum
Job Description
Knowledge of SQL language and cloud-based technologies Profound knowledge and hands-on experience in Snowflake Platform Architecture. Proficient in SQL for data validation and querying, with experience in Snow SQL scripts. Excellent understanding of Snowflake Internals, Stages, and Integrations in Snowflake. Extensive experience in T-SQL stored procedures and complex query development. Design and implement features for identity and access management Implement Client query optimization, major security competencies with encryption Solve performance issues and scalability issues in the system Experience in SQL query performance tuning, including proficiency with Query Profiler, Micro-partition pruning, Data spilling and understanding of optimizer and execution plans. Experience with productionized data ingestion and processing pipelines using Snow SQL Data warehousing concepts, data modeling, metadata management Create, test, and implement enterprise-level apps with Snowflake Experience in integrating Snowflake with other data processing and reporting technologies such as SSRS, Tableau reports is a plus. Strong understanding of CI/CD workflows, unit testing and integration testing, and deployment patterns. Strong ability in documenting design solutions effectively. Familiarity with a variety of tools including Jira, ServiceNow, Confluence, GIT, and Flyway. Experience in Azure cloud services including Azure SQL MI and ADF, particularly in database and data management contexts is plus.
About ApTask: ApTask is a leading global provider of workforce solutions and talent acquisition services, dedicated to shaping the future of work. As an African American-owned and Veteran-certified company, ApTask offers a comprehensive suite of services, including staffing and recruitment solutions, managed services, IT consulting, and project management. With a focus on excellence, collaboration, and innovation, ApTask provides unparalleled opportunities for professional growth and development. As a member of the ApTask team, you will have the chance to connect businesses with top-tier professionals, optimize workforce performance, and drive success across diverse industries. Join us at ApTask and be part of our mission to empower organizations to thrive while fostering a diverse and inclusive work environment.
Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government issued ID during each interview.
Candidate Data Collection Disclaimer: At ApTask, we prioritize safeguarding your privacy. As part of our recruitment process, certain Personally Identifiable Information (PII) may be requested by our clients for verification and application purposes. Rest assured, we strictly adhere to confidentiality standards and comply with all relevant data protection laws. Please note that we only collect the necessary information as specified by each client and do not request sensitive details during the initial stages of recruitment.
If you have any concerns or queries about your personal information, please feel free to contact our compliance team at businessexcellence@aptask.com
Salary Range: $110K-$130K/Annum
Job Description
Knowledge of SQL language and cloud-based technologies Profound knowledge and hands-on experience in Snowflake Platform Architecture. Proficient in SQL for data validation and querying, with experience in Snow SQL scripts. Excellent understanding of Snowflake Internals, Stages, and Integrations in Snowflake. Extensive experience in T-SQL stored procedures and complex query development. Design and implement features for identity and access management Implement Client query optimization, major security competencies with encryption Solve performance issues and scalability issues in the system Experience in SQL query performance tuning, including proficiency with Query Profiler, Micro-partition pruning, Data spilling and understanding of optimizer and execution plans. Experience with productionized data ingestion and processing pipelines using Snow SQL Data warehousing concepts, data modeling, metadata management Create, test, and implement enterprise-level apps with Snowflake Experience in integrating Snowflake with other data processing and reporting technologies such as SSRS, Tableau reports is a plus. Strong understanding of CI/CD workflows, unit testing and integration testing, and deployment patterns. Strong ability in documenting design solutions effectively. Familiarity with a variety of tools including Jira, ServiceNow, Confluence, GIT, and Flyway. Experience in Azure cloud services including Azure SQL MI and ADF, particularly in database and data management contexts is plus.
About ApTask: ApTask is a leading global provider of workforce solutions and talent acquisition services, dedicated to shaping the future of work. As an African American-owned and Veteran-certified company, ApTask offers a comprehensive suite of services, including staffing and recruitment solutions, managed services, IT consulting, and project management. With a focus on excellence, collaboration, and innovation, ApTask provides unparalleled opportunities for professional growth and development. As a member of the ApTask team, you will have the chance to connect businesses with top-tier professionals, optimize workforce performance, and drive success across diverse industries. Join us at ApTask and be part of our mission to empower organizations to thrive while fostering a diverse and inclusive work environment.
Applicants may be required to attend interviews in person or by video conference. In addition, candidates may be required to present their current state or government issued ID during each interview.
Candidate Data Collection Disclaimer: At ApTask, we prioritize safeguarding your privacy. As part of our recruitment process, certain Personally Identifiable Information (PII) may be requested by our clients for verification and application purposes. Rest assured, we strictly adhere to confidentiality standards and comply with all relevant data protection laws. Please note that we only collect the necessary information as specified by each client and do not request sensitive details during the initial stages of recruitment.
If you have any concerns or queries about your personal information, please feel free to contact our compliance team at businessexcellence@aptask.com