11+ Slowly changing dimensions Jobs in India

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).

Hybrid 3- days office

Max 27 lpa

Must-Have Skills:

5–10 years of experience in Data Engineering or Master Data Management.

5+ years hands-on experience with Informatica MDM (Multi-Domain Edition).

Strong understanding of MDM concepts: golden record, hierarchy management, trust/survivorship, data governance.

Proficient in:

Informatica MDM Hub Console, Provisioning Tool, Services Integration Framework (SIF).

ActiveVOS workflows, user exits (Java), and match/merge tuning.

SQL, PL/SQL, and data modeling for MDM.

Experience integrating MDM with upstream and downstream systems (ERP, CRM, Data Lake, etc.).

Knowledge of data quality integration using Informatica Data Quality (IDQ).

Key Responsibilities:

● Configure and implement Informatica MDM Hub, including subject area models, base

objects, landing tables, and relationships.

● Develop and fine-tune match & merge rules, trust scores, and survivorship logic for

creating golden records.

● Design and build ActiveVOS workflows for data stewardship, exception handling, and

business process approvals.

● Collaborate with data stewards and business teams to define data standards, ownership

models, and governance rules.

● Integrate data from various source systems via batch processing, REST APIs, or

message queues.

● Set up and maintain data quality checks and validations (in conjunction with

Informatica Data Quality (IDQ)) to ensure completeness, accuracy, and consistency.

● Build and customize Informatica MDM User Exits (Java), SIF APIs, and business entity

services as needed.

● Support MDM data loads, synchronization jobs, batch group configurations, and

performance tuning.

● Work with cross-functional teams to ensure alignment with overall data architecture and

governance standards.

● Participate in Agile ceremonies, sprint planning, and documentation of technical designs

and user guides.

Nice-to-Have Skills:

● Experience with Informatica EDC and Axon for metadata and governance integration.

● Exposure to cloud deployments of Informatica MDM (on GCP, Azure, or AWS).

● Familiarity with data stewardship concepts, data lineage, and compliance

frameworks (GDPR, HIPAA, etc.).

● Basic knowledge of DevOps tools for MDM deployments (e.g., Git, Jenkins)

Role Overview:

We are seeking a seasoned Lead Platform Engineer with a strong background in platform development and a proven track record of leading technology design and teams. The ideal candidate will have at least 8 years of overall experience, with a minimum of 5 years in relevant roles. This position entails owning module design and spearheading the implementation process alongside a team of talented platform engineers.

At MontyCloud, you'll have the opportunity to work on cutting-edge technology, shaping the future of our cloud management platform with your expertise. If you're passionate about building scalable, efficient, and innovative cloud solutions, we'd love to have you on our team.

Responsibilities:

• Lead the design and architecture of robust, scalable platform modules, ensuring alignment with business objectives and technical standards.
• Drive the implementation of platform solutions, collaborating closely with platform engineers and cross-functional teams to achieve project milestones.
• Mentor and guide a team of platform engineers, fostering an environment of growth and continuous improvement.
• Stay abreast of emerging technologies and industry trends, incorporating them into the platform to enhance functionality and user experience.
• Ensure the reliability and security of the platform through comprehensive testing and adherence to best practices.
• Collaborate with senior leadership to set technical strategy and goals for the platform engineering team.

Must have skills:

• Expertise in Python programming, with a solid foundation in writing clean, efficient, and scalable code.
• Proven experience in serverless application development, designing and implementing microservices, and working within event-driven architectures.
• Demonstrated experience in building and shipping high-quality SaaS platforms/applications on AWS, showcasing a portfolio of successful deployments.
• Comprehensive understanding of cloud computing concepts, AWS architectural best practices, and familiarity with a range of AWS services, including but not limited to Lambda, RDS, DynamoDB, and API Gateway.
• Exceptional problem-solving skills, with a proven ability to optimize complex systems for efficiency and scalability.
• Excellent communication skills, with a track record of effective collaboration with team members and successful engagement with stakeholders across various levels.
• Previous experience leading technology design and engineering teams, with a focus on mentoring, guiding, and driving the team towards achieving project milestones and technical excellence.

Good to Have skills:

• AWS Certified Solutions Architect, AWS Certified Developer, or other relevant cloud development certifications.
• Experience with the AWS Boto3 SDK for Python.
• Exposure to other cloud platforms such as Azure or GCP.
• Knowledge of containerization and orchestration technologies, such as Docker and Kubernetes.

Experience:

• Total Experience: 8 + years of experience in Software or Platform Engineering
• Minimum 5 years of experience in roles directly relevant to platform development and team leadership
• Minimum 4 years of experience in developing applications with Python
• Minimum 3 years of experience in serverless application development
• Minimum 3 years of experience in building event-driven architectures

Education:

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

Interview Process:

• Coding Assignment
• L1- code review
• F2F Round with Director of Engineering

Job Description:

• Looking for a SAP SD Architect with 10 years of experience.
• Experience in working with SD contract management processes (Master data, validity, pricing, Billing Plans, and Invoicing).
• Experience in RAR is required.

• 4-8 years Asp.net web API
  ● Asp.net core 1
  ● Asp.net core 2
  ● Asp.net core 2.1

Preferred Skills:-

• Micro-services with C#
• Having worked in a product development environment is desirable.
• Having worked in the finance and banking domain is desirable.
• Docker and Linux knowledge is desirable

Role – Java lead

Location – Bangalore

Job Description:

• Strong in java and Spring MVC

• Experience in client interaction

• Good communication skill

• Good interpersonal skill

• Team Handling skills