SQL Developer – Data Lake, AI & Data Engineering

Ample Success HR; Bengaluru; On-site; INR 1,200,000 - 2,200,000; Full time

Job summary

Ample Success HR is seeking an experienced SQL Developer in Bengaluru to build scalable data platforms and AI-ready data models. You will design data pipelines, optimize SQL solutions, and architect vector databases to support GenAI initiatives across enterprise analytics.

The role requires strong expertise in Data Lake architecture, data modelling, and Python-based data processing, with a focus on large-scale datasets and governance.

Qualifications

• Experience designing and maintaining Data Lakes for enterprise data.
• Strong SQL development across SQL Server, PostgreSQL, Oracle, MySQL, etc.
• Data modelling for analytics, ML, and AI-ready datasets.
• Experience with vector databases and GenAI-ready architectures.

Responsibilities

• Design, develop, and optimize complex SQL queries and objects.
• Build and govern enterprise Data Lakes for diverse data types.
• Model scalable data structures for analytics and ML applications.
• Develop data pipelines for ingestion, transformation, and prep.
• Architect Vector DB solutions for GenAI, embeddings, and RAG.
• Ensure data quality, security, governance, and performance.
• Integrate data from multiple enterprise systems and APIs.
• Collaborate with Business, Analytics, DS, and AI teams.

Skills

Advanced SQL

Data Lake Architecture

Data Warehousing

AI/ML Data Modelling

Python Data Processing

Query Optimization

Data Governance

Vector Database Design

Large-scale Data Handling

Job description

Seeking an experienced SQL Developer with strong expertise in Data Lake architecture, Data Engineering, AI/ML data modelling, and Vector Database design. The candidate will be responsible for building scalable data platforms, developing optimized SQL solutions, designing AI-ready data models, and supporting enterprise analytics 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 (ML), and AI applications.
• - Develop and maintain data ingestion, transformation, and data 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 multiple 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 (SQL Server, PostgreSQL, Oracle, MySQL, etc.).
• - Data Lake Architecture, Development, and Maintenance
• - Data Warehousing & Dimensional Data Modelling
• - AI/ML Data Modelling and Feature Engineering
• - Python for Data Engineering, Data Processing, and Automation
• - Query Performance Tuning & Database Optimization
• - Data Governance & Data Quality Management
• - Vector Database Architecture and Management (Pinecone, Qdrant, Weaviate, Milvus, Chroma, or similar)
• - Experience handling large-scale structured and unstructured datasets

Preferred Skills;

• - Experience with GenAI, RAG (Retrieval-Augmented Generation), Embeddings, and LLM-based applications
• - PySpark and Distributed Data Processing
• - 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, ML, and GenAI technologies

Ideal CandidateA 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 to support advanced analytics, AI, and GenAI initiatives.