We enable #HumanFirstDigital
Mandatory to have:
Around 5 years experience as Snowflake Developer on design and development of data solutions within the Snowflake Data Cloud, leveraging its cloud-based data warehousing capabilities. Responsible for designing and implementing data pipelines, data models, and ETL processes, ensuring efficient and effective data storage, processing, and analysis
Able to write Complex SQL Queries, Write JavaScript and Python Stored Procedure code in Snowflake
1 to 3 days per week - work from Bengaluru office
Job Description Summary:
Data Modeling and Schema Design:
Create and maintain well-structured data models and schemas within Snowflake, ensuring data integrity and efficient query performance.
ETL/ELT Development:
Design and implement ETL (Extract, Transform, Load) or ELT (Extract, Load, Transform) processes to load data into Snowflake from various sources.
Data Pipeline Management:
Build and optimize data pipelines to ingest data into Snowflake, ensuring accurate and timely data flow.
SQL Optimization:
Write and optimize SQL queries to enhance performance and efficiency within Snowflake.
Performance Tuning:
Identify and address performance bottlenecks within Snowflake, optimizing query execution and resource allocation.
Security and Governance:
Implement data security and governance best practices within Snowflake environments, including access control and encryption.
Documentation and Maintenance:
Maintain documentation for data models, data pipelines, and other Snowflake solutions.
Troubleshooting and Support:
Troubleshoot and resolve issues within Snowflake, providing technical support to users.
Collaboration:
Collaborate with data architects, data engineers, and business users to understand requirements and deliver solutions
Other Skills:
Experience with data warehousing concepts and data modeling.
Hands-on experience in creating stored procedures, functions, tables, cursors.
Experience in database testing, data comparison, and data transformation scripting.
Capable of troubleshooting common database issues
Hands on experience in Gitlab with understanding of CI/CD Pipeline, DevOps tools
Knowledge on AWS Lambda and Azure Functions
Our Commitment to Diversity & Inclusion:
Our Perks and Benefits:
Our benefits and rewards program has been thoughtfully designed to recognize your skills and contributions, elevate your learning/upskilling experience and provide care and support for you and your loved ones. As an Apexon Associate, you get continuous skill-based development, opportunities for career advancement, and access to comprehensive health and well-being benefits and assistance.
We also offer:
o Group Health Insurance covering family of 4
o Term Insurance and Accident Insurance
o Paid Holidays & Earned Leaves
o Paid Parental LeaveoLearning & Career Development
o Employee Wellness
Job Location : Bengaluru, India