Database Architect at Unlink Technologies Private Limited · Noida · 6 - 10 years · ₹25L - ₹35L / yr · Profitable · Posted 22 Sep 2025

Title: Data Platform / Database Architect (Postgres + Kafka) — AI‑Ready Data Infrastructure
Location: Noida (Hybrid). Remote within IST±3 considered for exceptional candidates.
Employment: Full‑time
About Us
We are building a high‑throughput, audit‑friendly data platform that powers a SaaS for financial data automation and reconciliation. The stack blends OLTP (Postgres), streaming (Kafka/Debezium), and OLAP (ClickHouse/Snowflake/BigQuery), with hooks for AI use‑cases (vector search, feature store, RAG).
Role Summary
Own the end‑to‑end design and performance of our data platform—from multi‑tenant Postgres schemas to CDC pipelines and analytics stores—while laying the groundwork for AI‑powered product features.
What You’ll Do
• Design multi‑tenant Postgres schemas (partitioning, indexing, normalization, RLS), and define retention/archival strategies.
• Make Postgres fast and reliable: EXPLAIN/ANALYZE, connection pooling, vacuum/bloat control, query/index tuning, replication.
• Build event‑streaming/CDC with Kafka/Debezium (topics, partitions, schema registry), and deliver data to ClickHouse/Snowflake/BigQuery.
• Model analytics layers (star/snowflake), orchestrate jobs (Airflow/Dagster), and implement dbt‑based transformations.
• Establish observability and SLOs for data: query/queue metrics, tracing, alerting, capacity planning.
• Implement data security: encryption, masking, tokenization of PII, IAM boundaries; contribute to PCI‑like audit posture.
• Integrate AI plumbing: vector embeddings (pgvector/Milvus), basic feature‑store patterns (Feast), retrieval pipelines and metadata lineage.
• Collaborate with backend/ML/product to review designs, coach engineers, write docs/runbooks, and lead migrations.
Must‑Have Qualifications
• 6+ years building high‑scale data platforms with deep PostgreSQL experience (partitioning, advanced indexing, query planning, replication/HA).
• Hands‑on with Kafka (or equivalent) and Debezium/CDC patterns; schema registry (Avro/Protobuf) and exactly‑once/at‑least‑once tradeoffs.
• One or more analytics engines at scale: ClickHouse, Snowflake, or BigQuery, plus strong SQL.
• Python for data tooling (pydantic, SQLAlchemy, or similar); orchestration with Airflow or Dagster; transformations with dbt.
• Solid cloud experience (AWS/GCP/Azure)—networking, security groups/IAM, secrets management, cost controls.
• Pragmatic performance engineering mindset; excellent communication and documentation.
Nice‑to‑Have
• Vector/semantic search (pgvector/Milvus/Pinecone), feature store (Feast), or RAG data pipelines.
• Experience in fintech‑style domains (reconciliation, ledgers, payments) and SOX/PCI‑like controls.
• Infra‑as‑Code (Terraform), containerized services (Docker/K8s), and observability stacks (Prometheus/Grafana/OpenTelemetry).
• Exposure to Go/Java for stream processors/consumers.
• Lakehouse formats (Delta/Iceberg/Hudi).

Similar jobs (10)
10+ years of experience in Data Architecture, Data Engineering, or Data Platforms
• Strong expertise in IBM DB2 / On-Prem Relational Databases
• Strong expertise in PostgreSQL
• Hands-on experience with the Azure Data Ecosystem, including:
▪ Azure Data Factory (ADF)
▪ Azure Data Lake Storage Gen2 (ADLS Gen2)
▪ Azure Databricks / Synapse Analytics
▪ Azure Event Hub / Service Bus
▪ Azure Functions
Data Platform Engineer
Design, automate, and scale our data platform — this is an engineering role, not a traditional "DBA job.
Must-have :
- Data modeling & schema design (from first principles, not just maintenance)
- PostgreSQL (deep, hands-on — partitioning, replication, tuning)
- Any distributed NoSQL store (Cassandra, ScyllaDB, or similar wide-column/distributed DB) (real production experience)
- Python (automation & tooling, not just scripting)
- DevOps & CI/CD (building pipelines, not just using them)
- Terraform (infrastructure-as-code)
You'll:
- Design schemas, partitioning strategies, and lead the Postgres → Cassandra migration end-to-end
- Own PostgreSQL performance, replication, and zero-downtime schema changes
- Build Python-based automation to eliminate repetitive DB work
- Own CI/CD pipelines and Terraform-based infra provisioning
- Drive uptime, DR, monitoring, and incident response
- Own multi-tenant security (RLS, least-privilege access) and data governance
Experience: 4–9 years, data/database/platform engineering in demanding production environments.
Bonus: Kafka/Debezium (CDC), Redis, Flyway/Liquibase, GDPR/DPDP exposure.
Job description: Data Architect – Databricks / AWS
Job Summary
We are looking for an experienced Data Architect to define and drive the target data architecture for the Horizon MVP and its future evolution. The role will be responsible for designing a scalable, secure, governed cloud data platform covering ingestion, storage, processing, analytics, APIs, and downstream data consumption.
The architect will work closely with Data Engineering, Backend, DevOps, QA, and business stakeholders to establish architecture standards and ensure the platform is ready for advanced analytics, AI/ML, vector storage, and future LLM-based capabilities.
- Job Title: Data Architect
- Experience: 8+ Years
- Relevant Architecture Experience: 3+ Years in Data Architecture
- Location: Chennai / Pune
- Work Mode: Hybrid – 3 Days WFO
- Budget: Up to 24 LPA
- Payroll: Haparz
- Notice Period: Immediate Preferred
Key Responsibilities
- Define the target data architecture for the Horizon MVP and establish an architecture roadmap for future scalability.
- Design end-to-end architecture covering data ingestion, storage, processing, serving, reporting, APIs, and downstream applications.
- Establish canonical data models and schemas for travel signals, corridors, sources, evidence, scores, and generated insights.
- Define data normalization strategies for structured, semi-structured, and unstructured data from multiple external sources.
- Design and govern the Databricks platform architecture, including Unity Catalog, data schemas, access controls, and governance standards.
- Establish data-retention, lineage, data-quality, security, privacy, and compliance controls.
- Define secure integration patterns between Databricks, AWS PRODIGY, SharePoint, external APIs, and downstream applications.
- Design scalable data processing for 30-day signal windows, convergence/divergence scoring, corridor ranking, and spike detection.
- Define architecture patterns that support future vector storage, embeddings, LLM integration, and multi-year analytics.
- Design reliable batch and API-driven ingestion frameworks for structured and unstructured data.
- Review technical designs, identify architectural risks, and provide technical direction to engineering teams.
- Guide backend, data engineering, DevOps, and QA teams in implementing architecture standards.
- Ensure architecture decisions align with enterprise security, RBAC, PII handling, privacy, and operational requirements.
- Communicate architecture decisions, trade-offs, and technical recommendations effectively to technical and business stakeholders.
What We’re Looking For
- 8+ years of experience in data engineering, data platforms, or data architecture, with at least 3+ years in a Data Architect capacity.
- Strong hands-on experience designing cloud-based data platforms, lakehouses, or analytical platforms.
- Advanced knowledge of Databricks, Apache Spark/PySpark, Delta Lake, and Unity Catalog.
- Strong understanding of AWS data services, IAM, networking, and secure cloud integration patterns.
- Strong expertise in data modelling, metadata management, data lineage, data quality, retention, and governance.
- Experience architecting batch and API-based ingestion pipelines for structured, semi-structured, and unstructured data.
- Understanding of AI/ML workloads, feature pipelines, vector databases, embeddings, and LLM integration patterns.
- Experience designing APIs and downstream data-serving architectures.
- Strong knowledge of PII protection, RBAC, data privacy, and enterprise security controls.
- Excellent architectural communication and stakeholder-management skills.
What you'll need
- Bachelor's degree in Computer Science, Engineering, Information Systems, or a related technical field.
- 5+ years of professional data engineering experience.
- Experience designing and building cloud-native data solutions.
- Strong expertise with Google Cloud Platform, including BigQuery. Experience developing transformation frameworks using dbt.
- Strong SQL and Python programming skills.
- Experience with PostgreSQL or other relational databases.
- Experience orchestrating workflows using Apache Airflow or Cloud Composer.
- Experience implementing Infrastructure as Code using Terraform. Experience building CI/CD pipelines using GitHub Actions, GitLab CI, Jenkins, or similar platforms.
- Experience developing scalable batch and streaming data pipelines. Strong problem-solving skills with the ability to balance scalability, reliability, and cloud cost optimization.
Preferred Qualifications
- Experience with Pub/Sub, Datastream, Dataflow, Cloud Storage, Cloud Functions, or Cloud Run.
- Experience building multi-tenant SaaS platforms.
- Experience implementing metadata-driven governance, lineage, and data quality frameworks.
- Experience supporting AI, machine learning, or customer-facing analytics platforms.
- Experience with Kubernetes and Docker.
About the Role
We are looking for a Senior Data Engineer with strong hands-on expertise in Databricks, Python, PySpark, and SQL to build scalable, high-performance data engineering solutions. You’ll architect and develop large scale, high-performance data pipelines capable of handling massive real-time and batch data volumes across multiple business systems. Databricks is the core enterprise data and processing platform for this role. You will also use Apache Airflow for workflow orchestration and dbt for ELT transformations, and will contribute to designing reliable, secure, and governed data platforms that enable analytics, reporting, and AI-driven use cases.
Key Responsibilities
- Design and implement large-scale data pipelines using Python/PySpark, Databricks, and Microsoft Fabric.
- Develop and optimize data processing workloads in Databricks using PySpark and Spark SQL, with a strong focus on scalability, reliability, performance, and maintainability.
- Develop and maintain dbt models including layered architecture, incremental models, snapshots, macros, testing, and documentation.
- Design, develop, and maintain Apache Airflow DAGs for orchestrating reliable, scalable, and observable data pipelines.
- Design and implement data quality, observability, and governance frameworks, including automated testing, monitoring, lineage, access control, and data privacy standards.
- Partner with analytics, product, and business stakeholders to turn requirements into trustworthy datasets, and raise the engineering bar through design discussions, code reviews, and mentoring junior engineers.
Required Skills
- Strong expertise in Python for developing scalable, modular, and production-ready data engineering applications.
- Strong expertise in PySpark, including DataFrame API, Spark SQL, Structured Streaming, partitioning strategies, joins, caching, handling data skew, and Spark performance optimization.
- Strong hands-on experience with Databricks for data ingestion, transformation, processing, and optimization, including Delta Lake, Unity Catalog, Databricks Workflows, notebooks, jobs, and Databricks-native data engineering capabilities.
- Strong experience in Databricks/Spark performance tuning, including query and job optimization, partitioning, file sizing, caching, join optimization, handling data skew, and efficient use of compute resources.
- Hands-on experience with Delta Lake, including transactional data processing, schema management, incremental data processing, and reliable batch and streaming data pipelines.
- Hands-on experience in developing dbt projects using layered architecture, incremental models, snapshots, macros/Jinja, testing, documentation, and deployment best practices.
- Expertise in advanced SQL and data modelling — dimensional modeling, slowly changing dimensions, schema evolution, and query optimization.
- Hands-on experience in developing and managing Apache Airflow DAGs, scheduling workflows, dependency management, retries, backfills, and operational monitoring.
- Hands-on experience with at least one major cloud platform (AWS, Azure or GCP).
- Strong problem-solving skills and the ability to work independently with business and analytics stakeholders.
Nice to Have
- Hands-on exposure to Microsoft Fabric for data integration and analytics.
- Experience using AI coding assistants (e.g. Claude Code, GitHub Copilot) as part of a development workflow.
- Familiarity with modern DevOps practices, including CI/CD pipelines, Infrastructure as Code (IaC), and containerization (Docker/Kubernetes).
- Domain expertise in financial services.

About the Role
You'll be at the forefront of designing and implementing robust data platform solutions that power advanced analytics, AI, and machine learning. Working with modern cloud technologies, you'll build scalable data foundations that enable clients to make smarter, data-driven decisions.
Key Responsibilities
- Build scalable data pipelines using Snowflake, AWS, GCP, and Databricks.
- Design and optimize data models for AI and machine learning workloads.
- Develop reliable data foundations for MLOps, governance, and data lineage.
- Integrate data from multiple sources into modern data platforms.
- Leverage Snowpark ML and Snowflake's native AI capabilities.
- Ensure data platforms are secure, scalable, and high-performing.
What We're Looking For
- 5+ years of hands-on experience with Snowflake.
- Strong proficiency in SQL and Python.
- Experience with AWS, Azure, or GCP.
- Knowledge of cloud storage services such as S3, ADLS, or GCS.
- Strong understanding of Dimensional Modeling and Data Vault.
- Experience with Scala or Java is a plus.
Tech Stack
- Data Warehouse: Snowflake
- Programming: SQL, Python, Scala (Good to Have), Java (Good to Have)
- Cloud: AWS, Azure, GCP
- Storage: S3, ADLS, GCS
- AI/ML: Snowpark ML, MLOps
Perks & Benefits
- Public Speaking & Communication Program
- Mentoring Program with Senior Support Leads
- 360° Progress Reviews
- Weekly Learning Sessions & Guilds
- Paid Certifications
- Hackathons & Innovation Days
- Recognition & Rewards Programs
- Team Socials & Annual Offsites
- Employee Assistance Program (24/7 Wellbeing Support)
The Data People Shaping Tomorrow
Our client helps organizations unlock the power of data through modern cloud, analytics, and AI solutions. We believe in creating an environment where talented technologists can learn, innovate, and make a real impact while building cutting-edge data platforms for global clients. If you're passionate about data engineering and want to work with the latest technologies in AI, cloud, and analytics, we'd love to hear from you.
Description
We are looking for Senior Data Engineers to join our Data Platform team and build scalable, high-performance data platforms that power data processing, analytics, and downstream applications.
The ideal candidate will have strong experience in distributed data processing, ETL pipelines, and Big Data technologies, with hands-on expertise in Apache Spark and Python Scala.
You will be responsible for designing, developing, and optimizing large-scale data pipelines while collaborating closely with cross-functional engineering teams to build reliable, production-grade data solutions.
Key Responsibilities
- Design, develop, and maintain scalable ETL and data processing pipelines for large-scale datasets.
- Build and optimize distributed data applications using Apache Spark and Python Scala.
- Develop reliable, high-performance data pipelines for batch and streaming workloads.
- Design and manage data workflows using Apache Airflow.
- Build and operate data workloads on AWS, with strong usage of Amazon S3 for large-scale data storage.
- Work with large datasets to ensure data quality, consistency, reliability, and performance.
- Collaborate with engineering, product, analytics, and other platform teams to deliver robust data solutions.
- Optimize data workflows for scalability, reliability, performance, and cost efficiency.
- Troubleshoot production issues, identify bottlenecks, and continuously improve platform performance.
Requirements
Candidates who demonstrate:
- 5+ years of experience in Data Engineering, Big Data Engineering, or a similar role.
- Strong hands-on experience with Apache Spark and Scala.
- Experience designing, building, and maintaining large-scale ETL pipelines.
- Strong hands-on experience with AWS, particularly Amazon S3.
- Hands-on experience with Apache Airflow for workflow orchestration and scheduling.
- Strong SQL skills and a solid understanding of distributed data processing concepts.
- Experience working with batch and/or streaming data pipelines.
- Excellent debugging, problem-solving, and performance optimization skills.
- Strong communication and collaboration skills.
Good to Have
- Experience with Databricks and the broader Databricks data platform.
- Familiarity with streaming technologies such as Apache Kafka.
- Experience working on large-scale data platforms handling high-volume data workloads.
- Exposure to additional AWS data services and cloud-native data architectures.
The recruiter has not been active on this job recently. You may apply but please expect a delayed response.
Hiring : Senior Databricks AI Architect
Exp : 15 - 18 yrs
Work Location : Pune WFO
Skills :
10 +years of experience in Data Engineering, Data Architecture, Analytics, or Software Engineering.
Minimum 5 years of hands-on experience with Databricks (Mandatory).
Strong expertise in designing and implementing enterprise-scale data platforms on Databricks.
Hands-on experience with AI-powered engineering tools such as Databricks Genie, Cursor, GitHub Copilot, or similar AI platforms.
Strong proficiency in Python, SQL, Spark, Delta Lake, and Databricks notebooks.
Excellent communication, stakeholder management
Job Title : Senior Data Engineer – Databricks
Experience : 14 to 20 Years
Location : HSR Layout, Bangalore
Work Mode : Hybrid – 3 Days WFO
Shift : 11:30 AM – 07:30 PM IST
Positions : 2
Notice Period : Immediate Joiners Only
Interview : 1 Technical Round + 2 Client Rounds
Role Overview :
We are looking for a Senior Data Engineer to build and lead enterprise-scale data platforms for a Switzerland-based commodity client.
The role requires a strong hands-on Data Engineering professional with expertise in Databricks, PySpark, Python, SQL, and AWS, along with technical leadership and stakeholder management experience.
Must-Have Skills :
- 14 to 20 years of Data Engineering experience
- Databricks & Apache Spark / PySpark
- Python & SQL
- AWS Cloud
- Lakehouse Architecture
- ETL / ELT & Distributed Data Processing
- Batch & Streaming Pipelines
- Data Pipeline Optimization & Data Modeling
- CDC & Incremental Processing
- Git, CI/CD & Testing
- Data Quality, Monitoring & Observability
- Technical Leadership & Stakeholder Management
Key Responsibilities :
- Design and build scalable data pipelines using Databricks, PySpark, Python, SQL, and AWS.
- Own data products from design through production.
- Develop batch / streaming pipelines and reusable ETL / ELT frameworks.
- Optimize pipelines for performance, scalability, reliability, and cost.
- Design scalable data architectures and data models.
- Implement data quality, monitoring, lineage, and CI/CD practices.
- Lead technical discussions and mentor engineering teams.
- Collaborate with business stakeholders, architects, product owners, and engineering teams.
- Remain hands-on while providing technical leadership.
Ideal Candidate :
A 14 to 20 years experienced, hands-on Data Engineering leader with strong Databricks + PySpark + AWS expertise, excellent communication, stakeholder management, and experience delivering enterprise-scale data platforms.
🔴 Super Urgent : Only Bangalore-based immediate joiners.
The recruiter has not been active on this job recently. You may apply but please expect a delayed response.
Strong Databricks Architect Profile with end-to-end Lakehouse ownership
2
Mandatory (Experience 1) – Must have 10+ years of software engineering experience with atleast 5+ years in Data Engineering with hands on exposure to Databricks and strong ownership of end-to-end data pipeline development.
3
Mandatory (Experience 2) – Must have atleast 5+ years of expertise across the Databricks ecosystem — Delta Lake, Delta Live Tables, Autoloader, Structured Streaming, Workflows, Unity Catalog
4
Mandatory (Tech skill 1) – Must have worked at architecture level, owning end-to-end design through deployment
5
Mandatory (Tech skill 2) – Must have strong experience with Python and SQL for data processing and Apache Spark for performance tuning & scalability
6
Mandatory (Tech skill 3) – Must have experience in large-scale data warehousing & advanced data modeling (3NF and dimensional) across batch and real-time systems
7
Mandatory (AI Exposure) – Must have at least a basic working understanding of how AI services or tools work
8
Mandatory (Communication) – Must have strong stakeholder management & requirement-gathering experience with US or UK clients
9
Mandatory (Company) – Must come from a B2B IT services or IT consulting background
10
Mandatory (Note) – CTC is inclusive of 5% variable
11
Preferred (Tech skill 1) – Azure Databricks or Azure data services experience (project runs on Azure DevOps)
12
Preferred (Tech skill 2) – MLflow or MLOps practices and AI use cases (RAG, AI/BI)
13
Preferred (Tech skill 3) – CI/CD, Databricks Asset Bundles (DABs) or equivalent packaging, Terraform or IaC, reusable deployment templates
14
Preferred (Integrations) – ServiceNow or enterprise system integrations
15
Preferred (Certifications) – Databricks (Data Engineer Associate or Professional, ML or GenAI tracks), Azure or AWS cloud certifications





