Fresher Skill & Exam Preparation Hub
Curated interview checklists, syllabus breakdowns, and preparation roadmaps for private tech roles and central government exams.
SSC Exams: CGL & CHSL Preparation Central Govt
The Staff Selection Commission conducts Tier-I and Tier-II Computer-Based Tests (CBT) for central ministry appointments.
- Quantitative Aptitude: Arithmetic (Percentages, Profit & Loss, Ratio & Proportion, Time-Work-Distance) and Advanced Math (Algebra, Geometry, Trigonometry, Mensuration).
- General Intelligence & Reasoning: Analogies, Number series, Coding-Decoding, Syllogisms, Blood relations, Non-verbal pattern folding.
- General Awareness: 6-month Current Affairs (schemes, appointments, summits), Indian Polity & Constitution, Modern Indian History, and Basic Science.
- English Comprehension: Spotting the error, Cloze test, Active/Passive voice, Direct/Indirect speech, Reading comprehension.
- Skill / Typing Test: Data Entry Operator (DEO) requires 8,000 key depressions/hour. Practice on official keyboard simulation tools.
Railway Recruitment Board (RRB JE & NTPC) Railways
RRB conducts national CBT examinations for Junior Engineer (IT/Technical) and Non-Technical Popular Categories.
- CBT-1 (Screening): Mathematics (30 Qs), General Intelligence & Reasoning (25 Qs), General Science (Physics, Chemistry, Life Sciences - 30 Qs), General Awareness (15 Qs). Time: 90 Minutes.
- CBT-2 Technical IT Syllabus: Operating Systems, DBMS (SQL & Relational Schema), Computer Networks (OSI & TCP/IP model), Object-Oriented Programming (C++/Java), and Web technologies.
- Negative Marking: 1/3rd deduction for each incorrect answer — focus on precision over guesswork.
IBPS IT Specialist Officer (Scale I) Banking
Common recruitment process for IT Officers managing core banking infrastructure across nationalized banks.
- Professional Knowledge (IT): Database Management (normalization, indexing, ACID properties), Computer Networking (routing protocols, subnets, firewalls), Data Structures, Software Engineering cycles, and Cyber Security fundamentals.
- Preliminary Stage: Reasoning (50 Qs), English Language (50 Qs), Quantitative Aptitude (50 Qs). Total 150 Qs in 120 minutes with sectional cutoffs.
- Mains & Interview: In-depth IT MCQs followed by technical and banking awareness interview panel.
NIC Scientist-B & Scientific Officer Govt Tech
Recruitment for entry-level computer science engineers designing e-governance systems for the Ministry of Electronics and IT.
- Section A (Generic): Logical reasoning, quantitative analytical ability, and general mental ability (35% weightage).
- Section B (Computer Science): Algorithms, discrete mathematics, compiler design, computer architecture, distributed systems, and web services (65% weightage).
Structured Query Language (SQL) Database
Essential for software engineering, analytics, and backend support interviews.
- Aggregations & Grouping: Master
GROUP BY,HAVING, and aggregate functions (SUM,AVG,COUNT(DISTINCT)). - Joins: Understand Cartesian products, difference between
LEFT JOINvsINNER JOIN, and filtering in theONvsWHEREclause. - Window Functions: Frequently tested in tech screenings:
ROW_NUMBER(),DENSE_RANK(), and cumulative partitioning.
Core Java & Object-Oriented Design Language
A primary interview staple across enterprise and product engineering hiring in India.
- OOP Pillars: Real-world examples of Abstraction vs Encapsulation, Runtime Polymorphism, and Interface segregation.
- Collections Framework: Internal working of
HashMap, concurrency handling, and performance differences betweenArrayListandLinkedList. - Memory Management: Stack vs Heap allocations, Garbage Collection basics, and string immutability.
Spring Boot & Microservices Backend
Framework expectations for entry-level Java backend developers.
- Dependency Injection: Inversion of Control (IoC),
@Autowired,@Componentvs@Beanlifecycle. - REST APIs: HTTP methods (GET, POST, PUT, DELETE, PATCH), status codes, and exception handling using
@ControllerAdvice. - Data Persistence: Spring Data JPA repository interfaces and connection pooling.
Python & Data Manipulation Language
Prerequisites for entry-level developer, automation, and data analyst roles.
- Data Structures: Dictionary lookups, list comprehensions, tuples, and generators.
- Core Libraries: Basic parsing with
requests, tabular analysis withpandas, and JSON serialization.
Campus Aptitude & Reasoning Screening
First-round screening essentials across IT service firms (TCS, Infosys, Wipro, Cognizant, Accenture).
- Quantitative: Percentages, Profit & Loss, Work & Time formulas, and Speed-Distance-Time conversions.
- Logical: Seating arrangements, Syllogisms, Direction sense, and Blood relations.