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 - Database Developer / SQL Developer
Location : Agoura Hills , CA ( Onsite 5Days )
We are looking for a skilled Database Developer with hands-on experience in Azure Data Factory (ADF) and SQL Server to design, develop, and maintain reliable data integration and database solutions. The ideal candidate will work closely with data architects, analysts, and application teams to build efficient ETL pipelines and optimize SQL Server databases for performance and scalability.
Key Responsibilities
• Design, develop, and maintain SQL Server databases, tables, views, indexes, and stored procedures.
• Build and manage data integration pipelines using Azure Data Factory.
• Develop and optimize ETL/ELT processes for loading data from multiple sources.
• Write complex T-SQL queries for data transformation and reporting.
• Monitor and troubleshoot ADF pipelines, ensuring data accuracy and reliability.
• Perform SQL Server performance tuning, including query optimization and indexing.
• Implement data validation, error handling, and logging mechanisms.
• Collaborate with data architects and business teams to understand data requirements.
• Support data migration and integration efforts (on-premises to Azure).
• Maintain technical documentation for database objects and data flows.
• Follow data security and governance best practices.
Required Skills & Qualifications
• Strong experience as a Database Developer or similar role.
• Hands-on experience with Azure Data Factory.
• Strong proficiency in SQL Server and T-SQL.
• Experience with ETL/ELT concepts and data warehousing fundamentals.
• Knowledge of SQL Server performance tuning techniques.
• Experience working with relational data models.
• Familiarity with Azure SQL Database or SQL Managed Instance.
• Understanding of data security and access controls.
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.
