KASHII UPDATEZ Everyday Student Requirements & Python Coding Tutorials by Python Kashi
REQUIREMENT_ID_348 β€’ 3-DAY_ACTIVE_POLICY

System Engineer – Data Analyst

Company
Company CGI
Type
Opportunity Type Internship
Salary
Stipend / Salary 5-7 LPA
Location
Location Bangalore, Karnataka
Posted Date
Posted Date Today
Power BI DAX Power Query Python Pandas NumPy Matplotlib Seaborn SQL Data Modeling ETL Data Cleansing Data Visualization Business Intelligence ESG Reporting Communication
πŸ“–
Aptitude and Reasoning Practice Open Resource β†—
Helps you sharpen quantitative and logical reasoning skills essential for the online assessment at CGI.
πŸ“–
Technical Interview Preparation Guide Open Resource β†—
Covers common data‑analytics and programming questions asked in CGI technical rounds.
πŸ“–
Comprehensive Interview Coaching Open Resource β†—
Provides structured interview strategies, mock interviews and HR round tips useful for CGI hiring process.
πŸ“–
Coding Practice Platform Open Resource β†—
Offers a wide range of algorithmic problems to improve coding speed and accuracy for CGI technical assessments.

Bachelor’s degree in Computer Science, Information Technology or related engineering discipline; minimum 60% aggregate or equivalent CGPA; graduating batch 2025, 2026 or 2027; no active backlogs at the time of joining; strong analytical mindset and proficiency in Power BI, Python and SQL.

1
Round 1: Online aptitude & technical assessment
2
Round 2: Technical interview (coding, data modeling, Power BI case study)
3
Round 3: HR interview (fitment, communication, career goals)
CGI is a global IT and business consulting firm with a strong presence in India, known for delivering end‑to‑end digital transformation services across multiple industries. With more than four decades of experience, CGI combines deep domain expertise with cutting‑edge technology to help clients modernise their operations, improve security posture and drive data‑centric decision making. The company’s culture emphasises collaboration, continuous learning and a client‑first mindset, offering employees exposure to large‑scale projects and a clear career progression path. In India, CGI’s Bangalore delivery centre is a hub for analytics, cyber security and cloud solutions, attracting talent that thrives on solving complex business problems. The System Engineer – Data Analyst role sits within the Cyber Security practice and focuses on turning raw data into actionable insights for internal and client stakeholders. The incumbent will work with structured and unstructured datasets sourced from on‑premise systems, cloud platforms and ESG reporting tools. By leveraging Power BI, Python and SQL, the analyst will design, develop and maintain interactive dashboards, automate reporting pipelines and ensure data quality throughout the analytics lifecycle. The position offers a blend of technical depth and business acumen, making it ideal for candidates who enjoy both coding and storytelling with data. Key Responsibilities: 1. Design, develop and maintain interactive Power BI dashboards and reports that meet business requirements. 2. Extract, cleanse, transform and validate data from multiple sources using SQL and Python. 3. Build robust data models, define KPIs and implement DAX calculations for accurate performance tracking. 4. Automate recurring reporting workflows to improve efficiency and reduce manual effort. 5. Conduct data quality assessments and resolve data inconsistencies across reporting solutions. 6. Collaborate with business stakeholders to gather requirements, translate them into analytical solutions and present findings. 7. Support ESG and sustainability reporting initiatives by integrating relevant metrics into visualisations. 8. Participate in code reviews, documentation and knowledge‑sharing sessions within the analytics team. 9. Stay updated with emerging tools and best practices in data engineering, visualization and cloud analytics. 10. Troubleshoot and resolve issues related to data pipelines, dashboards and performance. Tech Stack: Power BI (DAX, Power Query), Python (Pandas, NumPy, Matplotlib, Seaborn), SQL (T‑SQL, window functions), ETL concepts, data modelling, ESG reporting frameworks, basic exposure to cloud data platforms (Azure/AWS). Growth Path: Starting as a System Engineer, high performers can progress to Senior Analyst, Data Architect, Analytics Manager or specialize further into Cyber Security analytics and Cloud Data Engineering. CGI encourages certifications (e.g., Microsoft Power BI, AWS, Azure) and offers internal mobility across domains. Why Join CGI: Employees benefit from a global brand reputation, mentorship from seasoned consultants, a collaborative environment that values innovation, and a structured learning ecosystem. The role provides hands‑on experience with enterprise‑grade data platforms, exposure to ESG initiatives and a clear roadmap for career advancement.

CGI β€” 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 🎯
CGI Interview Preparation Corner

Comprehensive guide covering typical interview formats, common questions, and preparation tips for CGI 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 (Power BI, DAX, Power Query, Python, Pandas, NumPy, Matplotlib, Seaborn, SQL, Data Modeling, ETL, Data Cleansing, Data Visualization, Business Intelligence, ESG Reporting, Communication) & 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
CGI 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 CGI as a System Engineer – Data Analyst?
Preparation Tip: Highlight CGI's market reputation, recent tech innovations, and how your skills in Power BI 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 β†—
CGI
System Engineer – Data Analyst
Apply Apply Now β†—
Chat Chat with Kashii