SQL Developer

SQL API Developer

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, HLS, TMT, 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 Type: Contract

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.

• 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 Server–backed 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.

• Proven experience as a SQL Developer, API Developer, or Backend Developer
  .
• Strong expertise in SQL Server and T‑SQL
  .
• 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
  .

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.

• Associate

• Contract

• Information Technology

• IT Services and IT Consulting and Financial Services