Exponentia - SQL Developer - ETL

Role Over view : As a Senior SQL Developer at Exponentia.ai, should have strong background in SQL development, ETL processes, and proficiency in the Microsoft BI stack, including SQL Server and Azure, as well as PostgreSQL. Excellent communication and interpersonal skills are essential, as you will collaborate closely with crossfunctional teams to deliver high-quality solutions. Job Responsibilities : - Design, develop, and optimize complex SQL queries and stored procedures across SQL Server, Azure SQL Database, and PostgreSQL. - Lead ETL processes to ensure seamless data integration and transformation. - Collaborate with data analysts and business stakeholders to gather requirements and translate them into technical specifications. - Implement and maintain data models and database structures for optimal performance. - Monitor and troubleshoot database performance issues, ensuring high availability and reliability. - Develop and maintain documentation related to data processes and architecture Required Skills : - Minimum of 6 years of experience as an SQL Developer, with a focus on ETL processes. - Strong expertise in Microsoft SQL Server and Azure SQL Database. - Experience with data warehousing concepts and methodologies. - Proficient in writing complex SQL queries, stored procedures, and performance tuning. - Familiarity with BI tools and reporting services (e.g., SSRS, Power BI) is a plus. - Excellent problem-solving skills and attention to detail. - Strong communication and interpersonal skills, with the ability to collaborate effectively with technical and non-technical stakeholders. - Preferred - Knowledge of cloud data services and platforms (e.g., Azure Data Factory, Azure Synapse Analytics) or Certification in Microsoft SQL Server or related technologies. (ref:hirist.tech)

Location: mumbai, IN

Posted Date: 12/22/2024