Sonata Software
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 Description
SQL API Developer Location :LosAngeles, CA/Hybrid Job Type Contract
Job Description
SQL API Developer We are looking for a skilled
SQL API Developer
with strong expertise in
SQL Server
and
Azure Data Factory
to design, develop, and maintain high-performance data APIs and integration workflows. The ideal candidate will build secure, scalable APIs that interact with SQL Server databases and support data ingestion, transformation, and orchestration using Azure Data Factory.
Key Responsibilities Design, develop, and maintain
RESTful APIs
that interact with
SQL Server databases . Write and optimize complex
T-SQL queries , stored procedures, and functions to support API operations. Develop and manage
Azure Data Factory pipelines
for data ingestion and orchestration. Integrate APIs with
ADF pipelines
using REST, HTTP, or database connectors. Ensure
high performance, scalability, and reliability
of SQL Serverbacked APIs. Implement
data validation, error handling, logging, and exception management . Optimize SQL Server database performance through indexing, query tuning, and best practices. Collaborate with front-end, application, and data teams to define API and data requirements. Support
data migration and integration
solutions involving on-prem and Azure environments. Maintain API and database technical documentation. Follow
security, governance, and compliance
standards for APIs and databases.
Required Skills & Qualifications Proven experience as a
SQL Developer, API Developer, or Backend Developer . Strong expertise in
SQL Server
and
T-SQL . Experience developing
RESTful APIs
(e.g., .NET Web API, Java, or similar). Hands-on experience with
Azure Data Factory . Knowledge of
ETL/ELT concepts
and data integration patterns. Experience with
SQL Server performance tuning
and optimization. Understanding of
authentication and authorization
mechanisms (OAuth, API keys, etc.). Familiarity with
Azure SQL Database
or
SQL Managed Instance .
Why join Sonata Software?
At Sonata, youll have an outstanding opportunity. The chance to use your skills and imagination to push the boundaries of whats possible. To build never seen before solutions to some of the worlds toughest problems. Youll be challenged, but you will not be alone. Youll 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.
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 Description
SQL API Developer Location :LosAngeles, CA/Hybrid Job Type Contract
Job Description
SQL API Developer We are looking for a skilled
SQL API Developer
with strong expertise in
SQL Server
and
Azure Data Factory
to design, develop, and maintain high-performance data APIs and integration workflows. The ideal candidate will build secure, scalable APIs that interact with SQL Server databases and support data ingestion, transformation, and orchestration using Azure Data Factory.
Key Responsibilities Design, develop, and maintain
RESTful APIs
that interact with
SQL Server databases . Write and optimize complex
T-SQL queries , stored procedures, and functions to support API operations. Develop and manage
Azure Data Factory pipelines
for data ingestion and orchestration. Integrate APIs with
ADF pipelines
using REST, HTTP, or database connectors. Ensure
high performance, scalability, and reliability
of SQL Serverbacked APIs. Implement
data validation, error handling, logging, and exception management . Optimize SQL Server database performance through indexing, query tuning, and best practices. Collaborate with front-end, application, and data teams to define API and data requirements. Support
data migration and integration
solutions involving on-prem and Azure environments. Maintain API and database technical documentation. Follow
security, governance, and compliance
standards for APIs and databases.
Required Skills & Qualifications Proven experience as a
SQL Developer, API Developer, or Backend Developer . Strong expertise in
SQL Server
and
T-SQL . Experience developing
RESTful APIs
(e.g., .NET Web API, Java, or similar). Hands-on experience with
Azure Data Factory . Knowledge of
ETL/ELT concepts
and data integration patterns. Experience with
SQL Server performance tuning
and optimization. Understanding of
authentication and authorization
mechanisms (OAuth, API keys, etc.). Familiarity with
Azure SQL Database
or
SQL Managed Instance .
Why join Sonata Software?
At Sonata, youll have an outstanding opportunity. The chance to use your skills and imagination to push the boundaries of whats possible. To build never seen before solutions to some of the worlds toughest problems. Youll be challenged, but you will not be alone. Youll 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.