KASHII UPDATEZ Everyday Student Requirements & Python Coding Tutorials by Python Kashi
REQUIREMENT_ID_1528 • 3-DAY_ACTIVE_POLICY N

Lead Software Engineer

Company
Company Pri India It Services
Type
Opportunity Type Full-Time Job
Salary
Stipend / Salary Competitive Package (Best in Industry)
Location
Location Pune, India
Posted Date
Posted Date Yesterday
Apply on Official Website ↗
Software Continuous Integration Advance SQL Spring Boot Development Java SQL Continuous Integration
📖
Aptitude Practice Questions & Mock Tests Open Resource ↗
Curated logical, quantitative, and verbal reasoning problems for the initial online screening round.
🎯
Company-Specific Interview Preparation Corner Open Resource ↗
Detailed interview experiences, exam formats, and previous test questions for Pri India It Services and tech roles.
📝
Technical Placement Cheat Sheets & Question Bank Open Resource ↗
High-yield coding cheat sheets, core CS fundamentals (OOP, DBMS, OS, Networks), and rapid revision guides.
💻
Algorithm, DSA & Live Code Debugger Practice Open Resource ↗
Hands-on problem sets to improve coding speed and step-by-step memory debugging.

Experience: 7-12 Yrs. Open to matching qualifications.

1
Online Assessment / Technical Interview Rounds / HR Review
This role is ideal for an experienced technical leader passionate about building large-scale data platforms, semantic services, metadata-driven systems, and high-performance data workloads. The successful candidate will lead the design and development of critical platform capabilities supporting semantic modelling, query generation, query optimisation, data access, metadata management, customer onboarding, and platform modernisation initiatives. The position requires strong expertise in distributed systems, Java development, database technologies, platform engineering, cloud-native architectures, API design, and performance optimisation. The role combines hands-on engineering leadership with cross-functional collaboration across Product and Data Platform teams. Role • Drive design decisions for scalable metadata-driven architectures. • Own complex technical problems spanning semantic models, query generation, execution frameworks, and platform services. • Evaluate emerging technologies and recommend innovative solutions aligned with business objectives. • Develop highly scalable query generation and execution frameworks. • Build metadata-driven capabilities supporting business-friendly access to complex data assets. • Contribute to platform features that improve usability, discoverability, governance, and performance. • Develop high-performance APIs, microservices, and platform services. • Optimise distributed systems handling large query volumes and complex analytical processing. • Improve platform resiliency, scalability, observability, and operational health. • Drive platform standardisation and engineering best practices. • Drive improvements in SQL generation, query planning, query execution, and metadata processing. • Analyse production performance patterns and implement preventative improvements. • Partner with database and infrastructure teams to optimise application performance at scale. • Design solutions that support high concurrency, low latency, and predictable platform behaviour. • Support customer onboarding and migration activities. • Drive technical readiness for customer adoption initiatives. • Collaborate with stakeholders to reduce delivery risk and improve execution transparency. • Ensure platform capabilities meet customer expectations for reliability, scalability, and performance. • Lead root cause analysis and production issue remediation. • Promote automation and operational maturity across engineering teams. • Improve deployment processes, release quality, and platform observability. • Establish engineering quality standards and reusable platform patterns. • Mentor engineers and foster a culture of technical excellence. • Lead design reviews and promote engineering best practices. All About You • Strong experience designing and developing large-scale distributed software systems. • Strong experience building microservices using Spring Boot or equivalent frameworks. • Deep understanding of software architecture, system design, and distributed computing principles. • Expert-level experience with SQL, database design, and query optimisation. • Experience developing cloud-native applications and containerised services. • Strong understanding of API design and service-oriented architectures. • Experience with CI/CD, DevSecOps, automated testing, and platform automation. • Proven ability to lead complex technical initiatives across multiple teams. • Exposure and understanding of complete SDLC • Experience in AGILE methodology • Experience in working in global teams and should be technically strong • Good communication skill is mandatory

Pri India It Services — Data Analytics & SQL Interview Guide

Previously asked questions, exam syllabus, coding benchmarks & round strategy.

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.

Open Resource ↗
COMPANY GUIDE 🎯
Pri India It Services Interview Preparation Corner

Comprehensive guide covering typical interview formats, common questions, and preparation tips for Pri India It Services and off-campus tech roles.

Open Resource ↗
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.

Open Resource ↗
CODING PRACTICE 💻
Algorithm and Data Structure Problem Set

Practice problems to improve coding proficiency and algorithm problem-solving speed for technical rounds.

Open Resource ↗
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 (Software, Continuous Integration, Advance SQL, Spring Boot, Development, Java, SQL, Continuous Integration) & 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
Pri India It Services Core Values, Learning Agility & Offer Terms
Demonstrate passion, strong communication, and readiness for full-time collaboration.
What is the difference between WHERE and HAVING clauses in SQL? Answer ▼
Model Answer: WHERE filters rows before any groupings are applied, while HAVING filters aggregated groups after GROUP BY has executed.
Explain SQL Window functions: ROW_NUMBER(), RANK(), and DENSE_RANK(). Answer ▼
Model Answer: ROW_NUMBER() assigns unique sequential integers. RANK() assigns identical ranks to ties and skips ranks. DENSE_RANK() assigns identical ranks to ties without skipping rank numbers.
How do you handle NULL and missing values during data cleaning in Python/Pandas? Answer ▼
Model Answer: Use .isna().sum() to identify missing values. Impute with mean/median using .fillna() or remove with .dropna(subset=[...]) depending on variance impact.
What is the difference between Star Schema and Snowflake Schema in Data Warehousing? Answer ▼
Model Answer: Star Schema has denormalized dimension tables directly connected to the central Fact table. Snowflake Schema normalizes dimension tables into sub-dimensions to minimize redundancy.
How do you calculate MoM (Month-over-Month) growth in SQL? Answer ▼
Model Answer: Use LAG(revenue, 1) OVER (ORDER BY month) to fetch the previous month's revenue and compute (revenue - prev_revenue) / prev_revenue * 100.
Why do you want to join Pri India It Services as a Lead Software Engineer?
Preparation Tip: Highlight Pri India It Services's market reputation, recent tech innovations, and how your skills in Software directly solve their team's objectives.
Describe a challenging bug or academic project roadblock and how you resolved it.
Preparation Tip: 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?
Preparation Tip: Explain your prioritization strategy, proactive communication with mentors/peers, and agile mindset.

More Fresh Requirements in Software Engineering

View Category Feed ↗
Pri India It Services
Lead Software Engineer
Apply ↗
Chat Chat with Kashii