
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
Company: IDFC First Bank
About the company:
IDFC Limited was set up in 1997 to finance infrastructure projects in India. With time, the company diversified into asset management, institutional broking and investment banking. In 2014, the Reserve Bank of India granted in-principal approval to IDFC Limited to set up a new bank in the private sector.
Role Overview:
QA Overview: A Quality Analyst with a focus on Automation and Manual Testing is responsible for ensuring the quality of software products across web, mobile, and API platforms. This role involves designing, implementing, and executing test plans, both manually and through automated testing tools, to identify and address defects. The Quality Analyst will also be proficient in database testing, ensuring the integrity and reliability of data interactions within the system.
Job Description
Job Title: QA tester
Location: Chennai
Compensation: Commensurate with Experience
Experience: 5-10 Years
Qualification- Graduation: Bachelor of Science (B.Sc) / Bachelor of Technology (B.Tech) / Bachelor of Computer Applications (BCA)
Post-Graduation: Master of Science (M.Sc) /Master of Technology (M.Tech) / Master of Computer Applications (MCA)
- Proven experience in both manual and automated testing.
- Strong proficiency in automation tools (e.g., Selenium, Appium) and scripting languages.
- Experience with web, mobile, API, and database testing.
- Familiarity with agile development methodologies.
- Excellent analytical and problem-solving skills.
- Key Competencies: - Automation scripting (e.g., Java, Python, JavaScript), SQL and database querying skills - Attention to detail - Collaboration and communication - Analytical thinking
Key Responsibilities:
- Test Planning and Design: Develop comprehensive test plans based on project specifications. Design and document test cases for web, mobile, API, and database testing. Collaborate with development teams to understand system requirements.
- Automation Testing: Develop and maintain automated test scripts using industry-standard tools (e.g., Selenium, Appium). - Execute automated test suites and Analyse results. - Identify opportunities for test automation and implement efficient testing strategies.
- Manual Testing: Execute manual test cases for functional, regression, and performance testing. - Document and report defects, providing detailed information for developers. - Conduct exploratory testing to identify unforeseen issues.
- Web, Mobile, and API Testing: Perform end-to-end testing of web and mobile applications. - Validate API functionality and integration points. - Ensure compatibility across different browsers and mobile devices.
- Continuous Integration: Design, implement and maintain CI pipelines for automated testing and deployment - Integrate automated tests into CI workflows to enable early detection of defects - Continuously assess and optimize CI processes for speed, efficiency and reliability
- Database Testing: Develop and execute SQL queries to validate data integrity. - Verify data transformations and migrations. - Identify and address performance issues related to database interactions.
- Collaboration: Work closely with developers, product managers, and other stakeholders to understand requirements and user stories. - Participate in agile ceremonies, providing input on quality-related aspects.
- Test Documentation: Maintain detailed and organized documentation of test cases, results, and issues. - Create and update testing documentation as the application evolves.
What kind of work will you get?
We are looking for a Golang developer.
Examples of technical tasks:
Working on our backend SDK to implement APIs that will be consumed by the frontend widgets
Designing APIs for different auth recipes
Architecting auth flows
You will also be given non technical tasks like product brain storming, competitor analysis and writing documentation.
Note: Compensation is as per the applicant's geography
Requirements
Well versed in Golang with 2+ years of professional experience
Familiar with and comfortable working with Web frameworks like FastAPI, Django and Flask
Familiar with HTTP networking in Golang
Strong understanding of async and sync modes in Golang
Bonus:
Contributed to open source, or have your own open source repo with a community and many github stars
Built an in-house authentication or authorization solution or worked with solutions such as Keycloak, Auth0, Ory, Okta etc
Roles and Responsibilities
1) Understand client requirements and functionalities.
2) Write well-designed, testable, efficient code.
3) Responsible for solving complex technical issues.
4) Ensure quality projects are delivered within defined timelines.
5) Active involvement in client communication to understand functional requirements.
6) Maintain high standards of quality for code, documentation and other deliverables.
At least 3 years' experience as a Node.js developer.
Extensive knowledge of JavaScript, web stacks, libraries, and frameworks.
Mandatory experience in MongoDB and MySql.
Knowledge of front-end technologies such as HTML5 and CSS3.
Superb interpersonal, communication, and collaboration skills.
Exceptional analytical and problem-solving aptitude.
What we are looking for:
=> Bachelors/Masters degree in Computers/IT or equivalent.
=> 5-8 years of relevant experience in web development.
=> Strong PHP, MySQL & Codeigniter (MVC Framework) hands-on experience (at least 12-15 projects).
=> Database schema design and query optimization.
=> AWS hands-on experience with EC2, ELB, RDS, CloudFront, Lambda, code deploy, etc.
=> Experience with e-commerce platforms, payment gateways will be a big advantage, especially on content-heavy platforms.
=> Hands-on experience and a good understanding of GIT Commands.
=> Good to have experience with the RESTful API.
=> Ability to decipher and write complex database queries for analysis and optimization.
=> Troubleshoot, test, and maintain the core product software and databases to ensure strong optimization and functionality.
=> Understanding of scalability issues and their solutions.
=> Need to be articulate with a good degree of written & oral communication skills.
=> Exposure to UI/UX would be a added value.
=> We are looking for an immediate joiner (within 15 days or less).
=> This role may include night shifts.
Head Office: Koramangala, Bengaluru, Karnataka, India.
Work Location: Work From Home
Working Days: Monday to Friday
Shift & Timming: Regular (09:00 AM to 06:00 PM) / Night (08:00 PM to 05:00 AM)
Working Hours: 9 Hrs
The Telesales Person is responsible for generating sales through outbound telephone calls. They will contact potential customers, introduce products or services, and persuade them to make purchases or take desired actions. The role requires excellent communication skills, a persuasive demeanor, and a goal-oriented mindset to achieve sales targets.
- Bachelor’s Degree in Computer Science or equivalent
- 8-12 years’ of industry experience in programming web applications, mobile and/or large scale enterprise products
- Deep knowledge of C#, ASP, .NET, MVC, .Net core
- Deep knowledge and extensive experience working on Ruby or React and JavaScript, as required
- Experience with XML, ADO/ADO.NET, LINQ, AJAX, IIS
- Extended experience with SQL, relational and non-relational databases
- Experience in TFS and Visual Studio
- Hands on experience with SDLC and programming design patterns
- Experience with Agile methodology
- Skillful at reviewing new feature impact on an application and recognizing potential risks
- Uses time effectively and efficiently
- Quickly learns new technologies
- Detailed oriented, professional and possesses a positive work attitude
- Communicate professionally both verbally and in writing
- Effective time management skills
- Knowledge on UI technologies will be plus
PRINCIPAL DUTIES AND RESPONSIBILITIES:
- Develops software solutions by studying information needs, conferring with users, studying systems flow, data usage, and work processes, investigating problem areas, following the software development lifecycle.
- Conducts systems analysis and makes recommendations to improve the system to achieve an outcome.
- Promotes internal best practices and coding conventions to write and execute tests for your own code, including creating comprehensive unit tests.
- Contributes to Technical Requirements Documents.
- Requests constructive feedback for designs early in the process.
- Communicates successfully with large teams and many stakeholders.
- Provides mentorship for Software Engineers and participates in interview panels to hire new Software Engineers.
- Assists in removing obstacles for the team to yield successful sprints.
- Performs peer code reviews to ensure quality of the codebase.
- Ability to decompose and delegate work to junior engineers.
- Updates job knowledge by studying state-of-the-art development tools, programming techniques and computing equipment; participating in educational opportunities, reading professional publications, maintaining personal networks, participating in professional organizations.
- Works effectively with multiple projects and features.
- All other duties as assigned.
Mandatory Requirement/ Preference:
- 4 years of experience for delivering enterprise solutions or products using full SDLC
- 4 years of work experience with enterprise solutions for Microsoft platform (SQL Server, stored procedures, WCF, C#.net, Entity Framework)
- Extensive knowledge and experience with creating and maintaining stored procedure in MS SQL Server.
- Working with WEB API added advantage







