SQL Developer – Data Lake, AI & Data Engineering

SQL Developer –Data Lake, AI, andData

Engineering

Experience: 5–8 years | Location: Bengaluru/Hybrid

Role Summary

We are seeking an experienced SQL Developer with strong expertise in data lake

architecture, data engineering, AI/ML-ready data modelling, and vector database

design. The role will focus on building scalable data platforms, developing optimized

SQL solutions, designing analytics- and AI-ready data models, and supporting

enterprise analytics, semantic search, and GenAI initiatives.

Key Responsibilities

• Design, develop, and optimize complex SQL queries, stored procedures, views, and database

objects.

• Build, maintain, and govern enterprise data lakes for structured, semi-structured, and

unstructured data.

• Design scalable data models for analytics, machine learning, and AI applications.

• Develop and maintain data ingestion, transformation, and preparation pipelines.

• Architect and manage vector database solutions supporting GenAI, semantic search,

embeddings, and RAG-based applications.

• Ensure data quality, security, performance, governance, and scalability across platforms.

• Integrate data from enterprise systems, databases, APIs, and business applications.

• Collaborate with business, analytics, data science, and AI teams to deliver enterprise data

solutions.

Mandatory Skills

• Advanced SQL development across SQL Server, PostgreSQL, Oracle, MySQL, or similar

platforms.

• Data lake architecture, development, maintenance, and governance.

• Data warehousing and dimensional data modelling.

• AI/ML data modelling and feature engineering.

• Python for data engineering, data processing, and automation.

• Query performance tuning and database optimization.

• Data governance and data quality management.

• Vector database architecture and management using Pinecone, Qdrant, Weaviate, Milvus,

Chroma, or similar platforms.

• Experience handling large-scale structured and unstructured datasets.

Preferred Skills

• Experience with GenAI, RAG, embeddings, and LLM-based applications.

• PySpark and distributed data processing experience.

• Experience with Power BI or enterprise reporting platforms.

• Knowledge of MLOps, AI data pipelines, and modern data architectures.

Key Attributes

• Strong analytical and problem-solving skills.

• Ability to independently own end-to-end data platform solutions.

• Excellent communication and stakeholder management skills.

• Passion for data engineering, AI, machine learning, and GenAI technologies.

Ideal Candidate

The ideal candidate is a hands-on SQL Developer who can build and maintain enterprise data lakes,

design AI/ML-ready data models, develop Python-based data solutions, and architect vector database

platforms that support advanced analytics, AI, and GenAI initiatives.