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

Data Analyst

Company
Company Iqvia
Type
Opportunity Type Internship
Salary
Stipend / Salary 5 LPA
Location
Location Bangalore, India
Posted Date
Posted Date Today
SQL MS SQL Python Databricks Snowflake Azure AWS JavaScript client-server architecture analytical thinking communication problem solving shift flexibility
πŸ“–
Aptitude Practice Questions Open Resource β†—
Curated aptitude problems to sharpen quantitative and logical reasoning, essential for the initial assessment test at IQVIA.
πŸ“–
Company Interview Preparation Guide Open Resource β†—
Comprehensive guide covering typical interview formats and questions asked by large analytics firms like IQVIA.
πŸ“–
Comprehensive Interview Prep Resource Open Resource β†—
Detailed resource for technical and HR interview preparation, helping candidates tackle SQL and data‑analytics scenarios common at IQVIA.
πŸ“–
Algorithm & Data Structure Problem Set Open Resource β†—
Extensive problem set to practice coding and algorithmic thinking, useful for the technical round focusing on Python and SQL logic.

Bachelor’s degree in Computer Science, Information Technology, Electronics, or any related engineering discipline; minimum 60% aggregate (or CGPA 6.0/10); no active backlogs at the time of joining; batch year not specified (any recent graduate); strong communication skills in English; willingness to work in US EST shift timings; basic understanding of JavaScript and client‑server architecture.

1
Round 1: Resume Screening
2
Round 2: Aptitude/Assessment Test (focus on SQL, data concepts)
3
Round 3: Technical Interview (SQL queries, Python, data handling)
4
Round 4: HR Behavioral Interview
IQVIA is a world‑leading provider of advanced analytics, technology solutions and contract research services to the life‑sciences industry. With a presence in more than 100 countries, the company helps pharmaceutical, biotech and medical‑device firms accelerate drug development, improve patient outcomes and drive commercial success. IQVIA’s unique blend of deep domain expertise, massive healthcare data assets and cutting‑edge AI platforms makes it a preferred partner for organisations seeking data‑driven insights in a highly regulated sector. The firm’s culture emphasizes continuous learning, collaboration across geographies and a strong commitment to ethical standards, offering fresh graduates a vibrant environment to launch their careers. The Data Analyst role at IQVIA’s Bangalore office is designed for recent graduates who are eager to apply their analytical skills to real‑world healthcare problems. As a junior member of the analytics team, you will support global clients operating in US EST time zones, helping them extract, transform and visualise data that informs critical decisions in clinical trials, market access and patient safety. The position offers exposure to industry‑leading tools such as MSβ€―SQL, Databricks, Snowflake and cloud platforms (Azure/AWS), as well as opportunities to develop programming proficiency in Python and JavaScript. Key responsibilities include: designing and writing efficient SQL queries and stored procedures; performing data extraction, cleansing and validation; developing basic dashboards and reports for client stakeholders; assisting in performance tuning of database objects; collaborating with senior analysts to understand client requirements and translate them into technical solutions; participating in shift‑based support for US EST client calls; documenting data workflows and standard operating procedures; troubleshooting data‑related issues in a timely manner; continuously learning new tools and best practices in data engineering and analytics; and contributing ideas for process improvement within the team. The tech stack revolves around relational databases (MSβ€―SQL, Snowflake), big‑data processing (Databricks), cloud services (Azure/AWS), and scripting languages (Python, JavaScript). IQVIA encourages certification – a SQL certification is considered a plus – and provides internal training modules to help freshers upskill quickly. Career progression typically follows a clear path: Junior Data Analyst β†’ Analyst β†’ Senior Analyst β†’ Lead Analyst β†’ Manager, with regular performance reviews and mentorship programs. Joining IQVIA means working on impactful healthcare projects, gaining global exposure, and building a strong foundation in data analytics that is highly valued across industries.

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

Comprehensive guide covering typical interview formats, common questions, and preparation tips for Iqvia 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 (SQL, MS SQL, Python, Databricks, Snowflake, Azure, AWS, JavaScript, client-server architecture, analytical thinking, communication, problem solving, shift flexibility) & 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
Iqvia 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 Iqvia as a Data Analyst?
Preparation Tip: Highlight Iqvia's market reputation, recent tech innovations, and how your skills in SQL 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 & Tech

View Category Feed β†—
Iqvia
Data Analyst
Apply Apply Now β†—
Chat Chat with Kashii