SQL and Data Integration Developer

We are searching for a skilled SQL and Data Integration Developer to join our team. As a SQL and Data Integration Developer, you will be responsible for designing, developing, and maintaining scalable SQL database solutions, including data warehouses and complex ETL/ELT processes. Your role will involve integrating third-party API data, optimizing database performance, and collaborating with cross-functional teams to support critical business applications. The ideal candidate for this position should have a strong background in T-SQL development, enterprise data architecture, and cloud-based tools like Azure Data Factory. You should possess excellent communication skills and a proactive approach to problem-solving in a distributed team environment. **Job Responsibilities:** - Design, develop, and maintain SQL database schemas and scripts, including views, stored procedures, and SQL jobs. - Develop logical and physical data models to ensure robust and scalable database design. - Monitor and maintain existing data to ensure cleanliness, accuracy, consistency, and impact. - Write and optimize complex stored procedures, functions, and views using T-SQL for high-performance data operations. - Build and maintain data integration workflows using ETL/ELT tools like Azure Data Factory to facilitate data movement between systems and environments. - Integrate and import data from third-party APIs into SQL databases, ensuring data accuracy, security, and consistency. - Collaborate closely with application developers to implement and optimize database structures that meet application requirements. - Design and implement scalable data warehouse solutions that align with business goals and support enterprise analytics. - Act as the primary liaison between the SQL development team and cross-functional teams, including marketing, accounting, graphic design, and customer support. - Create comprehensive technical documentation, including design specifications, architecture documentation, and user instructions. - Continuously evaluate existing software components and tools, recommending improvements to ensure efficiency and scalability. - Participate in an agile development environment, coordinating with a distributed team across multiple time zones to deliver high-quality solutions on time and within budget. **Job Requirements:** - Work From Home (Shift: 2 pm - 11 pm) based in India. - 5+ years of hands-on experience in SQL development. - 3+ years of experience working with ETL/ELT tools, preferably Azure Data Factory. - Proficiency in writing and optimizing complex T-SQL queries, with expertise in performance tuning and query development. - Proven track record in developing and maintaining enterprise data warehouse architectures. - Experience in integrating data from external APIs and importing third-party data into relational databases. - Familiarity with version control systems such as TFS, GIT, or Azure DevOps. - Exposure to Azure SQL, SQL Source Control, and Azure Logic Apps is a plus. - Knowledge of Master Data Management (MDM) concepts and practices is advantageous. - Solid understanding of database troubleshooting and implementation of industry best practices. - Bachelor's degree (or higher) in Computer Science, Information Systems, or a related field. - Excellent communication and collaboration skills, with a proven ability to work effectively with globally distributed teams. **Benefits:** - Group Mediclaim Policy - Parental Insurance Coverage - Accident Policy - Retirement Benefits (Provident Fund) - Gratuity - Overtime Bonus, Paid Vacation & Holidays, Profit Sharing & Incentives,