Note: The job is a remote job and is open to candidates in USA. Sonata Software is a leading Modernization Engineering company focused on delivering hypergrowth for clients through innovative solutions. They are seeking a Senior Snowflake Developer & Administrator to develop and optimize enterprise-scale Snowflake data platforms, requiring advanced skills in Snowflake and data integration.
Responsibilities
- Design, develop, and maintain scalable ELT/ETL solutions on Snowflake
- Develop complex SQL, Stored Procedures, UDFs, Streams, Tasks, Dynamic Tables, and Snowpark applications
- Design dimensional models and optimize data pipelines for performance and scalability
- Implement metadata-driven and reusable data ingestion frameworks
- Perform query optimization and warehouse tuning to improve performance and reduce costs
- Administer Snowflake environments across Development, QA, UAT, and Production
- Configure and manage Virtual Warehouses, RBAC, Security, Resource Monitors, Data Sharing, Replication, Time Travel, and Network Policies
- Monitor platform health, usage, security, and optimize compute/storage costs
- Support deployments, environment migrations, and production releases
- Develop and maintain Talend ETL/ELT jobs integrating diverse source systems with Snowflake
- Design reusable Talend frameworks and orchestrate end-to-end data pipelines
- Troubleshoot and optimize Talend jobs for performance, scalability, and reliability
Skills
- Strong hands-on experience in Snowflake Development and Administration
- Advanced SQL programming and performance tuning
- Strong experience with Talend ETL/ELT development and data integration
- Good understanding of Data Warehousing, Data Vault, and Dimensional Modeling
- Experience with Python and automation scripting
- Experience working with AWS, Azure, or GCP
- Knowledge of CI/CD, Git, and DevOps practices
- Strong logical and analytical problem-solving skills
- Excellent communication and presentation skills
- Proven experience working directly with business stakeholders and clients
- Ability to independently drive technical discussions, solution design, and implementation
- Strong ownership mindset and mentoring capabilities
- SnowPro Certification
- Experience in Banking or Financial Services
- Exposure to AI-enabled data engineering solutions
Company Overview
Company H1B Sponsorship