Sql Developer

Net Connect; Bengaluru; On-site; INR 2,400,000 - 4,200,000; Full time

Job summary

Net Connect in Bengaluru is seeking a Senior SQL Developer to lead the design, development, and optimization of data solutions within a consulting environment. You will build and maintain data lakes, data models for analytics and AI, and manage vector databases for GenAI and semantic search.

The role requires 6–9 years of SQL/data engineering experience, proficiency across major RDBMS, and strong Python skills for automation and data processing.

Qualifications

• 6-9 years of experience in SQL development and data engineering.
• Proficiency in advanced SQL across SQL Server, PostgreSQL, Oracle, and MySQL.
• Strong experience in Data Warehousing, Dimensional Data Modeling, and AI/ML data modeling techniques.
• Skilled in Python for data engineering tasks, including data processing and automation.
• Expertise in Vector Database architecture and management with Pinecone, Qdrant, or Weaviate.
• Proven ability to conduct query performance tuning and database optimization.
• Experience with GenAI applications, RAG techniques, and large-scale data management.

Responsibilities

• Design, develop, and optimize complex SQL queries, stored procedures, and database objects.
• Build and maintain enterprise Data Lakes with structured, semi-structured, and unstructured data.
• Develop scalable data models for Analytics, Machine Learning, and AI applications.
• Create and manage data ingestion, transformation, and preparation pipelines.
• Architect and manage Vector Database solutions (Pinecone, Qdrant, Milvus) for GenAI and semantic search.
• Ensure quality, security, performance, and scalability of data platforms with governance.

Skills

SQL Development

SQL Server

PostgreSQL

Oracle

MySQL

Data Lake

Dimensional Modeling

Python

Vector DB

Pinecone

Qdrant

Weaviate

Milvus

Query Tuning

GenAI

RAG

AI/ML Modeling

Education

Bachelor's in Computer Science

Tools

Pinecone

Qdrant

Weaviate

Milvus

Job description

The Senior SQL Developer will be a pivotal member of the data engineering team, specializing in the development and optimization of data solutions in a consulting environment. Based in Bangalore, this role is integral to designing and managing scalable data platforms that support enterprise analytics and AI initiatives.

Description

• 6-9 years of experience in SQL development and data engineering, with a focus on Data Lake architecture and management.
• Proficiency in advanced SQL development across various database systems like SQL Server, PostgreSQL, Oracle, and MySQL.
• Strong experience in Data Warehousing, Dimensional Data Modelling, and AI/ML data modeling techniques.
• Skilled in Python for data engineering tasks, including data processing and automation.
• Expertise in Vector Database architecture and management, with experience in tools like Pinecone, Qdrant, or Weaviate.
• Proven ability to conduct query performance tuning and database optimization, ensuring efficient data operations.
• Experience with GenAI applications, RAG techniques, and large-scale data management of structured and unstructured datasets.

Key Responsibilities

• Design, develop, and optimize complex SQL queries, stored procedures, and database objects to support enterprise data solutions.
• Build and maintain enterprise Data Lakes, ensuring the integration and governance of structured, semi-structured, and unstructured data.
• Develop scalable data models tailored for Analytics, Machine Learning, and AI applications.
• Create and manage data ingestion, transformation, and preparation pipelines to facilitate seamless data flow and accessibility.
• Architect and manage Vector Database solutions, utilizing technologies like Pinecone, Qdrant, and Milvus to support GenAI and semantic search applications.
• Ensure the quality, security, performance, and scalability of data platforms, implementing best practices in data governance and management.
• Integrate and synthesize data from multiple enterprise systems, enhancing the organizations data-driven decision-making.
• Collaborate with Business, Analytics, and AI teams to design and deliver comprehensive data solutions that align with organizational goals.

Requirements

• Bachelor's in Computer Science, Data Engineering, or a related field.