N #2449
Applications open
Full-Time Job
Database Architect ( GCP , Data Flow , Python ) | Photon
Photon
About the role
Hi Greetings from PHOTON , Database Architect - GCP , Data Flow , Python , RDBMS & Google Cloud. Role Overview We are looking for a DataSenior Software Engineer with strong expertise in RDBMS, SQL, Python, and Google Cloud Platform to design and build scalable, reliable data-intensive applications and cloud solutions. Key Responsibilities Design and develop solutions using RDBMS, SQL, and data modeling best practices. Build cloud-native solutions using Google Cloud Spanner, Google Datastream, and Google Dataflow. Develop robust Python-based applications and data pipelines. Design data models, schemas, transformations, and data integration workflows. Work with change-data-capture (CDC), data synchronization, and distributed data processing. Develop, review, test, troubleshoot, and optimize production-quality code. Work with Git-based code repositories, branching strategies, pull requests, and code reviews. Manage and contribute to CI/CD and release pipelines, deployments, and production releases. Follow software engineering best practices around security, scalability, observability, testing, documentation, and maintainability. Collaborate with architects, engineers, and business teams to translate requirements into scalable technical solutions. Required Skills 7+ years of software/data engineering experience. Strong RDBMS and SQL skills, including query optimization and database design. Strong Python programming skills. Hands-on experience with Google Cloud Platform (GCP). Strong experience with Google Cloud Spanner. Experience with Google Datastream / CDC and Google Dataflow. Good understanding of distributed systems and data synchronization. Strong data modeling skills. Proficiency with Git/code repositories, CI/CD, release management, and engineering best practices. Good to Have Experience with Pub/Sub, Cloud Storage, Cloud Functions/Cloud Run, or other GCP services. Experience with database migration, replication, or hybrid cloud architectures. Experience designing highly available and multi-region applications. Familiarity with Agile development and automated testing. Ideal Candidate A hands-on senior engineer who combines strong database fundamentals with modern GCP engineering, can independently design and implement solutions, and follows disciplined software development and release practices. Interested Candidates pls forward the resume to E mail : rajeshdeepak.dhanasekaran@photon.com
Eligibility & process
Who can apply
Experience: 15-23 Yrs. Open to matching qualifications.
Skills & stack
Selection process
- Online Assessment / Technical Interview Rounds / HR Review
Prep kit
20 resourcesStudy material 4
Aptitude Practice Questions & Mock Tests
Curated logical, quantitative, and verbal reasoning problems for the initial online screening round.
Company-Specific Interview Preparation Corner
Detailed interview experiences, exam formats, and previous test questions for Photon and tech roles.
Technical Placement Cheat Sheets & Question Bank
High-yield coding cheat sheets, core CS fundamentals (OOP, DBMS, OS, Networks), and rapid revision guides.
Algorithm, DSA & Live Code Debugger Practice
Hands-on problem sets to improve coding speed and step-by-step memory debugging.
Company-specific guides 4
APTITUDE & LOGIC
Aptitude Practice Questions & Online Mock Tests
Curated logical, quantitative, and verbal reasoning problems to sharpen reasoning skills required for the initial screening test.
COMPANY GUIDE
Photon Interview Preparation Corner
Comprehensive guide covering typical interview formats, common questions, and preparation tips for Photon and off-campus tech roles.
MOCK TESTS & PAPERS
Comprehensive Interview Prep Resources & Syllabus
Collection of previous year questions, company-specific test patterns, and interview experiences for technical and HR rounds.
CODING PRACTICE
Algorithm and Data Structure Problem Set
Practice problems to improve coding proficiency and algorithm problem-solving speed for technical rounds.
Likely coding questions 4
Round-wise strategy 4
Round 1: Online Assessment (OA)
Aptitude, Quantitative Logic & 2 Coding Problems
Focus on accuracy and speed. Practice arrays, strings, and standard arithmetic puzzles.
Round 2: Technical Interview 1
Core Tech Stack (Cloud Platform, Database Design, Python, DBMS, Gcp Cloud, GCP, Google Cloud Services, Architecture) & Live Code Tracing
Explain your thought process aloud. Analyze time & space complexities before coding.
Round 3: System Design & Problem Solving
Database Schemas, APIs & Architecture Basics
Clarify edge cases, diagram schemas cleanly, and discuss scalability trade-offs.
Round 4: HR & Cultural Fit Discussion
Photon Core Values, Learning Agility & Offer Terms
Demonstrate passion, strong communication, and readiness for full-time collaboration.
Technical questions 5
Explain OOP (Object-Oriented Programming) principles with real-world examples in Cloud Platform. Answer
Model answer: 1. Encapsulation (data hiding via private fields/getters). 2. Abstraction (hiding implementation complexity). 3. Inheritance (code reusability). 4. Polymorphism (method overriding/overloading).
What is the time and space complexity of QuickSort vs MergeSort? Answer
Model answer: QuickSort: Average O(N log N) time, O(log N) space. Worst O(N^2). MergeSort: Guaranteed O(N log N) time, but requires O(N) auxiliary space.
Explain the difference between SQL Indexing (B-Tree vs Hash) and when not to use an index. Answer
Model answer: Indexes speed up SELECT queries via B-Trees. However, they slow down INSERT, UPDATE, and DELETE operations because indexes must be updated on disk. Avoid on low-cardinality columns (e.g., boolean flags).
What happens under the hood when you enter a URL in a browser? Answer
Model answer: 1. DNS lookup (resolves IP). 2. TCP 3-way handshake (SYN, SYN-ACK, ACK). 3. TLS negotiation for HTTPS. 4. HTTP GET request sent. 5. Server responds with HTML/CSS/JS. 6. Browser renders DOM & CSSOM tree.
What is the difference between REST and GraphQL APIs? Answer
Model answer: REST uses multiple fixed endpoints with possible over/under-fetching. GraphQL uses a single endpoint allowing clients to query exact fields in a single request.
Behavioural & HR questions 3
Why do you want to join Photon as a Database Architect ( GCP , Data Flow , Python ) | Photon?
Highlight Photon's market reputation, recent tech innovations, and how your skills in Cloud Platform directly solve their team's objectives.
Highlight Photon's market reputation, recent tech innovations, and how your skills in Cloud Platform directly solve their team's objectives.
Describe a challenging bug or academic project roadblock and how you resolved it.
Use the STAR method: Situation (project context), Task (what needed solving), Action (specific tools/logic applied), Result (quantifiable positive outcome).
Use the STAR method: Situation (project context), Task (what needed solving), Action (specific tools/logic applied), Result (quantifiable positive outcome).
How do you handle strict deadlines or sudden scope changes?
Explain your prioritization strategy, proactive communication with mentors/peers, and agile mindset.
Explain your prioritization strategy, proactive communication with mentors/peers, and agile mindset.
Competitive Package (Best in Industry)
Full-Time Job
Bengaluru, India
Nov 07, 2026
