Sonata Software

About the Company

Sonata Software Limited is a leading Modernization engineering company, headquartered in Bangalore. Sonata provides modernization services using its proprietary Platformation(tm) approach. It specializes in cloud and data modernization, Microsoft Dynamics Modernization, Digital contact center setup and management, managed cloud services and digital transformation services. Founded in 1986, the company has since grown to have a presence in North America, Europe, ANZ and Asia-Pacific. Sonata has partnerships with leading technology providers such as Microsoft, Amazon, Google, among others, and has received several awards and recognition for its services. With a focus on innovation and customer-centricity, Sonata aims to help businesses accelerate their modernization and digital transformation journeys.

Listed Jobs

Company Name

Sonata Software

Job Title

Business Analyst

Job Description

Job title: Business Analyst Role Summary: Lead data-driven insights for business operations within the Health & Life Sciences domain, collaborating across teams to develop reports, evaluate proposals, and recommend operational improvements. Expectations: Deliver actionable analytics using Microsoft BI tools, maintain rigorous data quality and governance, support UAT, and drive continuous improvement initiatives. Key Responsibilities: - Gather, elicit, and document business reporting requirements across UK/Europe stakeholders. - Design, develop, and maintain Power BI dashboards and Microsoft Fabric data models. - Map source data to target structures, perform data profiling, cleansing, and validation. - Write and optimize SQL queries for extraction, transformation, and reporting. - Track requirements, update documentation, and ensure alignment with business goals. - Conduct UAT testing, manage defects, and facilitate user training. - Partner with cross‑functional teams to evaluate proposals and recommend process enhancements. Required Skills: - 10–12 years of business analysis and data analytics experience, with deep familiarity in HLS. - Proficiency in Microsoft Power BI, Microsoft Fabric, and related analytics platforms. - Advanced SQL querying and data mapping abilities. - Strong requirements elicitation, documentation, and stakeholder communication skills. - Experience with UAT coordination and quality assurance. - Team‑oriented mindset with proven cross‑functional collaboration. Required Education & Certifications: - Bachelor’s degree in Business, Data Science, Information Systems, Finance, or related field. - Microsoft Certified: Data Analyst Associate or equivalent analytics certification preferred.

London, United kingdom

On site

Senior

15-12-2025

Company Name

Sonata Software

Job Title

SQL Developer

Job Description

**Job title** SQL API Developer **Role Summary** Design, develop, and maintain high‑performance, secure RESTful APIs that interact with SQL Server databases. Build and manage Azure Data Factory pipelines for data ingestion, transformation, and orchestration, ensuring scalability, reliability, and compliance with security and governance standards. **Expactations** - Deliver production‑ready APIs and ADF pipelines within defined timelines. - Achieve optimal performance and scalability for SQL Server‑backed services. - Adhere to coding standards, documentation practices, and security protocols. - Collaborate effectively with cross‑functional teams (front‑end, data engineering, operations). **Key Responsibilities** - Architect and implement RESTful APIs using .NET Web API, Java, or equivalent frameworks. - Write, optimize, and maintain complex T‑SQL queries, stored procedures, and functions. - Design and maintain Azure Data Factory pipelines for data ingestion, transformation, and orchestration. - Integrate API endpoints with ADF pipelines via REST, HTTP, or database connectors. - Conduct performance tuning for SQL Server (indexing, query optimization, best‑practice application). - Implement robust data validation, error handling, logging, and exception management. - Ensure compliance with security, governance, and regulatory requirements. - Produce and update technical documentation for APIs and database schemas. - Support data migration and integration across on‑premises and Azure environments. **Required Skills** - Strong proficiency in SQL Server and T‑SQL. - Experience developing RESTful APIs (e.g., .NET Web API, Java). - Hands‑on expertise with Azure Data Factory (ADF). - Knowledge of ETL/ELT concepts, data integration patterns, and data orchestration. - SQL Server performance tuning and optimization. - Understanding of authentication/authorization (OAuth, API keys, etc.). - Familiarity with Azure SQL Database or SQL Managed Instance. - Version control (Git), CI/CD awareness, and automated testing. **Required Education & Certifications** - Bachelor’s degree in Computer Science, Information Technology, or related field. - Microsoft Certified: Azure Data Engineer Associate (recommended). - Additional certifications in REST API design, database administration, or cloud architecture are advantageous.

Los angeles, United states

Hybrid

24-12-2025