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

Data Analyst I

Company
Company Schneider Electric
Type
Opportunity Type Internship
Salary
Stipend / Salary 4-5 LPA
Location
Location Gurgaon, Haryana
Posted Date
Posted Date Yesterday
Microsoft Excel Data Analysis Invoice Management Invoice Auditing Billing Discrepancy Analysis Contract Administration Microsoft Access Analytical Reasoning Logical Thinking Attention to Detail Professional Communication Data Accuracy Quality Control
πŸ“–
Aptitude Practice Questions Open Resource β†—
Curated quantitative and logical reasoning problems to sharpen the skills needed for the online assessment at Schneider Electric.
πŸ“–
Company Interview Preparation Guide Open Resource β†—
Comprehensive guide covering typical interview formats, common questions and tips for performing well in corporate interviews like Schneider Electric.
πŸ“–
Comprehensive Interview Prep Resources Open Resource β†—
Extensive collection of interview experiences, mock questions and preparation strategies useful for freshers targeting data analyst roles.
πŸ“–
Algorithm and Data Structure Problems Open Resource β†—
Practice platform for solving coding and data‑manipulation problems that help develop logical thinking required for technical rounds.

Any university or college degree (B.Tech, B.Com, B.Sc, BA, etc.) – preferably Finance, Economics or Mathematics. Freshers / junior candidates from the 2026 batch are eligible. Minimum CGPA/percentage not specified; candidates should have no active backlogs. Mandatory fluency in English. Strong knowledge of Microsoft Excel required; MS Access knowledge is a plus. Good analytical, logical reasoning and attention to detail. Ability to work in an international, cross‑functional environment.

1
Round 1: Online Aptitude Test (quantitative, logical reasoning, English)
2
Round 2: Technical Interview (Excel, data handling, scenario‑based questions)
3
Round 3: HR Interview (fitment, communication skills, career aspirations)
Schneider Electric is a global leader in energy management and automation, operating in more than 100 countries. The company’s mission is to make energy safe, reliable, efficient and sustainable for all. In India, Schneider Electric has a strong presence across manufacturing, infrastructure and services, offering a culture that blends innovation with a focus on sustainability. Employees benefit from a collaborative environment, continuous learning programs, and exposure to cutting‑edge technologies that drive the transition to a low‑carbon future. The firm is known for its inclusive policies, robust mentorship, and clear career progression pathways for fresh talent. The Data Analyst I role in Gurgaon is an entry‑level position designed for recent graduates who are comfortable working with large data sets, spreadsheets, and financial documents. As a member of a global billing and contract data team, you will help ensure that invoices are accurate, contractual terms are correctly applied, and billing discrepancies are resolved promptly. The role bridges finance and analytics, requiring strong Excel proficiency, logical reasoning, and clear communication with internal stakeholders and external suppliers. Key Responsibilities: 1. Analyse invoices and billing data to identify errors and discrepancies. 2. Perform invoice audits using advanced Excel functions and internal tools. 3. Communicate with suppliers via phone or email to resolve billing issues. 4. Update and maintain contract‑based calculation sheets in Excel. 5. Generate and distribute regular reports on invoice analysis outcomes. 6. Support contract administration activities, ensuring data integrity. 7. Maintain a dedicated database for contracting and billing information, optionally using MS Access. 8. Collaborate with cross‑functional teams across regions to align on data standards. 9. Ensure high accuracy and quality control in all routine tasks. 10. Assist the manager with ad‑hoc analytical projects as required. Tech Stack: Microsoft Excel (pivot tables, VLOOKUP/XLOOKUP, macros), MS Access (basic queries), PowerPoint for reporting, and email/communication tools. While not a data‑science role, familiarity with data‑cleaning techniques and basic SQL concepts is advantageous. Growth Path: Successful analysts can progress to Senior Data Analyst, Business Analyst, or Finance Operations Manager roles within 2‑3 years, with opportunities to move into global finance, supply‑chain analytics, or product data teams. Schneider Electric encourages certifications in data analytics and finance, providing tuition assistance and internal training. Why Join: The position offers exposure to a multinational environment, hands‑on experience with real‑world financial data, and a clear roadmap for professional growth. Freshers gain mentorship from seasoned analysts, access to Schneider’s learning platforms, and a competitive compensation package that reflects industry standards.

Schneider Electric β€” QA & Automation Testing 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 🎯
Schneider Electric Interview Preparation Corner

Comprehensive guide covering typical interview formats, common questions, and preparation tips for Schneider Electric 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 (Microsoft Excel, Data Analysis, Invoice Management, Invoice Auditing, Billing Discrepancy Analysis, Contract Administration, Microsoft Access, Analytical Reasoning, Logical Thinking, Attention to Detail, Professional Communication, Data Accuracy, Quality Control) & 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
Schneider Electric Core Values, Learning Agility & Offer Terms
Demonstrate passion, strong communication, and readiness for full-time collaboration.
What is the difference between Implicit Wait, Explicit Wait, and Fluent Wait in Selenium? Answer β–Ό
Model Answer: Implicit Wait sets a global timeout for all element lookups. Explicit Wait pauses execution until a specific ExpectedCondition (e.g. elementToBeClickable) is met. Fluent Wait allows defining polling frequency and ignoring specific exceptions like NoSuchElementException.
Explain the Page Object Model (POM) and its advantages in Test Automation. Answer β–Ό
Model Answer: POM is a design pattern that creates an object repository for web UI elements. It separates test scripts from page locators, reducing code duplication and making maintenance easy when UI elements change.
How do you handle dynamic WebElements whose ID changes on page reload? Answer β–Ό
Model Answer: Use dynamic XPath methods like contains(), starts-with(), text(), or XPath axes (ancestor, following-sibling, parent) instead of brittle absolute paths.
What is the difference between @BeforeMethod and @BeforeClass in TestNG? Answer β–Ό
Model Answer: @BeforeClass runs once before the first test method in the current class, while @BeforeMethod executes before each individual test method.
How do you validate REST API response codes and JSON payload using Postman / RestAssured? Answer β–Ό
Model Answer: In RestAssured: given().when().get('/endpoint').then().assertThat().statusCode(200).body('status', equalTo('ACTIVE')).
Why do you want to join Schneider Electric as a Data Analyst I?
Preparation Tip: Highlight Schneider Electric's market reputation, recent tech innovations, and how your skills in Microsoft Excel 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 Non IT

View Category Feed β†—
Schneider Electric
Data Analyst I
Apply Apply Now β†—
Chat Chat with Kashii