Senior Snowflake Developer & Administrator

Sonata Software Overview In today's market, there is a unique duality in technology adoption. On one side, extreme focus on cost containment by clients, and on the other, deep motivation to modernize their Digital storefronts to attract more consumers and B2B customers. As a leading Modernization Engineering company, we aim to deliver modernization-driven hypergrowth for our clients based on the deep differentiation we have created in Modernization Engineering, powered by our Lightening suite and 16-step Platformation™ playbook. In addition, we bring agility and systems thinking to accelerate time to market for our clients. Headquartered in Bengaluru, India, Sonata has a strong global presence, including key regions in the US, UK, Europe, APAC, and ANZ. We are a trusted partner of world-leading companies in BFSI (Banking, Financial Services, and Insurance), HLS (Healthcare and Lifesciences), TMT (Telecom, Media, and Technology), Retail & CPG, and Manufacturing space. Our bouquet of Modernization Engineering Services cuts across Cloud, Data, Dynamics, Contact Centers, and around newer technologies like Generative AI, MS Fabric, and other modernization platforms. Job Role: Senior Snowflake Developer & Administrator Location: Remote: Job Description: We are seeking a highly skilled • • Senior Snowflake Developer & Administrator • • with extensive hands-on experience in developing, administering, and optimizing enterprise-scale Snowflake data platforms. The ideal candidate should have deep expertise in advanced Snowflake capabilities, strong administration skills, and experience integrating Snowflake with ETL tools such as • • Talend • • . Exposure to Snowflake AI capabilities is a distinct advantage. The role requires excellent client-facing communication, analytical thinking, and problem-solving skills. Key Responsibilities Snowflake Development • 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. Snowflake Administration • 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. Talend & Data Integration • 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. • Experience integrating Talend with cloud storage (AWS S3/Azure Blob/GCS), APIs, and databases. Advanced Snowflake Expertise Hands-on experience with: • Snowpark (Python preferred) • Dynamic Tables • Streams & Tasks • Snowpipe / Snowpipe Streaming • External Tables • Iceberg Tables • Search Optimization Service • Materialized Views • Zero Copy Cloning • Query Profile Analysis & Performance Tuning • Secure Data Sharing • Native Apps (preferred) AI (Preferred) Exposure to one or more of: • Snowflake Cortex AI • Cortex Analyst • Cortex Search • Snowpark ML • Document AI • AI/LLM integrations with Snowflake Required 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. Soft Skills • 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. Preferred Qualifications • SnowPro Certification. • Experience in Banking or Financial Services. • Exposure to AI-enabled data engineering solutions. Why join Sonata Software? At Sonata, you´ll have an outstanding opportunity. The chance to use your skills and imagination to push the boundaries of what´s possible. To build never seen before solutions to some of the world’s toughest problems. You´ll be challenged, but you will not be alone. You´ll be joining a team of diverse innovators, all driven to go beyond the status quo to craft what comes next. Sonata Software is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity, age, religion, disability, sexual orientation, veteran status, marital status, or any other characteristics protected by law.