KASHII UPDATEZ Everyday Student Requirements & Python Coding Tutorials by Python Kashi
KashiiUpdatez
REQUIREMENT_ID_180 โ€ข 3-DAY_ACTIVE_POLICY

Software Engineer โ€“ Analytical Engineering

Company
Company Bristolmyerssquibb
Type
Opportunity Type Internship
Salary
Stipend / Salary 12 LPA - 15 LPA
Location
Location Hyderabad, Telangana
Posted Date
Posted Date Today
SQL Spark Python Data Modeling dbt AWS Airflow Tableau Power BI Looker Git SVN Agile AI/ML Predictive Modeling JIRA Confluence ServiceNow Oracle Amazon Redshift PostgreSQL CDP Impala Amazon Athena
๐Ÿ“–
Aptitude Practice Questions Open Resource โ†—
Curated logical and quantitative problems to sharpen the reasoning skills needed for the online screening round.
๐Ÿ“–
Technical Interview Preparation Guide Open Resource โ†—
Comprehensive coverage of core concepts like SQL, Python, Spark and data modeling to help you ace the technical interview.
๐Ÿ“–
Comprehensive Interview Preparation Portal Open Resource โ†—
A oneโ€‘stop resource for interview experiences, sample questions and tips specific to BMS and similar pharma tech roles.
๐Ÿ“–
Coding Practice Problems Open Resource โ†—
Handsโ€‘on coding challenges on data structures and algorithms to build confidence for the coding segment of the interview.

Graduation degree (B.Tech/B.E., B.Sc., M.Sc.) in Computer Science, Physics, Mathematics, Data Science, Pharmaceutical Science, Engineering or related fields; Minimum 60% aggregate (or CGPA 6.5/10); Graduation batch 2022โ€‘2026; No active backlogs at the time of application; 1โ€‘3 years of relevant experience in analytical engineering, data modeling or similar roles.

1
Round 1: Online Aptitude Test (logical reasoning, quantitative, verbal)
2
Round 2: Technical Interview (SQL, Python, Spark, data modeling, scenarioโ€‘based questions)
3
Round 3: HR Interview (fitment, communication, career goals)
Bristol Myers Squibb (BMS) is a global biopharmaceutical leader with a legacy of discovering, developing and delivering innovative medicines across therapeutic areas such as oncology, cardiovascular, immunology and virology. With a presence in more than 60 countries, BMS combines cuttingโ€‘edge science with a strong commitment to patient outcomes, fostering a culture of collaboration, integrity and continuous learning. The companyโ€™s Indian operations, headquartered in Hyderabad, serve as a strategic hub for dataโ€‘driven decision making, supporting research, commercial, and operational teams worldwide. The role of Software Engineer โ€“ Analytical Engineering sits at the intersection of data engineering and analytics. As an analytical engineer, you will transform raw, heterogeneous data into clean, businessโ€‘ready datasets that power dashboards, reports, and AI/ML models. You will work closely with data scientists, product owners, and business analysts to design, build, and maintain scalable data pipelines, centralized data layers, and reusable data products. The position offers earlyโ€‘career engineers a fastโ€‘track to mastering endโ€‘toโ€‘end data workflows while gaining exposure to modern cloud and BI technologies. **Key Responsibilities** 1. Design, develop and maintain ELT pipelines using Spark, Python and SQL to ingest and transform largeโ€‘scale datasets. 2. Build and document centralized data models (star/snowflake schemas) that serve multiple analytics useโ€‘cases. 3. Collaborate with AI/ML teams to provide highโ€‘quality, wellโ€‘documented data foundations for predictive models. 4. Implement data quality checks, testing frameworks and monitoring using Airflow DAGs. 5. Optimize query performance and storage costs on AWS data services (Redshift, Athena, S3). 6. Create and maintain visualisations and dashboards in Tableau, Powerโ€ฏBI or Looker for business stakeholders. 7. Versionโ€‘control all code and configuration using Git/SVN and follow Agile sprint cycles. 8. Produce technical documentation in Confluence and support knowledgeโ€‘transfer sessions. 9. Participate in code reviews, pairโ€‘programming and continuous improvement initiatives. 10. Engage with crossโ€‘functional teams to gather requirements, translate business questions into data solutions, and present findings clearly. **Tech Stack**: SQL, Apache Spark (PySpark), Python, dbt (preferred), AWS (S3, Redshift, Athena), Apache Airflow, Tableau/Powerโ€ฏBI/Looker, Git/SVN, Agile tools (JIRA, Confluence), Oracle, PostgreSQL, CDPโ€ฏImpala. **Growth Path**: Starting as an Analytical Engineer, you can progress to Senior Analytical Engineer, Data Platform Lead, or move into specialized AI/ML engineering or product analytics roles. BMS encourages internal mobility, mentorship programs, and sponsorship for certifications (AWS, dbt, Tableau). **Why Join BMS?** You will be part of a purposeโ€‘driven organization that impacts millions of lives, work with stateโ€‘ofโ€‘theโ€‘art data technologies, and receive strong support for professional development. The Hyderabad campus offers a collaborative environment, flexible workโ€‘fromโ€‘home options, and a balanced workโ€‘life culture that values employee wellโ€‘being.

Bristolmyerssquibb โ€” 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 ๐ŸŽฏ
Bristolmyerssquibb Interview Preparation Corner

Comprehensive guide covering typical interview formats, common questions, and preparation tips for Bristolmyerssquibb 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, Spark, Python, Data Modeling, dbt, AWS, Airflow, Tableau, Power BI, Looker, Git, SVN, Agile, AI/ML, Predictive Modeling, JIRA, Confluence, ServiceNow, Oracle, Amazon Redshift, PostgreSQL, CDP Impala, Amazon Athena) & 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
Bristolmyerssquibb 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 Bristolmyerssquibb as a Software Engineer โ€“ Analytical Engineering?
Preparation Tip: Highlight Bristolmyerssquibb'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 โ†—
Bristolmyerssquibb
Software Engineer โ€“ Analytical Engineering
Apply Apply Now โ†—
Chat Chat with Kashii