KASHII UPDATEZ Everyday Student Requirements & Python Coding Tutorials by Python Kashi
JD #2467
Applications open Full-Time Job

Data Analyst

Deloitte

  • Multiple locations (USA)
  • 58.7k - 115.8k USD per annum
  • 1+ Years
  • Posted Nov 09, 2026
HR
Recruiter contact
Recruiter / hiring contact
No public email in this post. Use a source-linked contact instead.

About the role

Deloitte is one of the world’s leading professional services firms, offering consulting, audit, tax, and advisory services to a diverse set of clients across industries. With a strong focus on innovation, Deloitte’s Human Capital practice helps organisations transform their HR function using AI, cloud technologies and data‑driven insights. The firm’s Government & Public Services (GPS) practice serves federal, state, local agencies and public education institutions, delivering large‑scale, high‑impact projects that shape public policy and improve citizen services.

The Oracle HCM Cloud Core HR Analyst role sits within Deloitte’s HR Strategy & Technology team. As an analyst, you will work on end‑to‑end implementation of Oracle HCM Cloud for public‑sector clients, ensuring seamless integration with existing enterprise systems. You will collaborate with functional, security, reporting and technical teams to translate business requirements into robust technical solutions, while adhering to Deloitte’s delivery methodology and quality standards.

Key Responsibilities

  • Design, develop and support integrations between Oracle HCM Cloud and connected enterprise applications using middleware tools.
  • Create data mapping documents, develop inbound/outbound interfaces, and maintain integration specifications.
  • Participate in integration testing cycles, track defects, and drive resolution to ensure end‑to‑end validation.
  • Execute data conversion activities – extraction, cleansing, transformation, loading, reconciliation and cut‑over preparation.
  • Work closely with HR, security, reporting and technical stakeholders to understand dependencies and capture project requirements.
  • Maintain comprehensive project documentation, status reports, risk registers and technical deliverables throughout the implementation lifecycle.
  • Support deployment, go‑live and post‑production stabilization, following Deloitte’s delivery methods and quality gates.
  • Provide knowledge transfer and training to client teams on integration processes and best practices.
  • Contribute to continuous improvement initiatives by identifying automation opportunities and recommending enhancements.
  • Uphold Deloitte’s professional standards, ensuring confidentiality, compliance and ethical conduct.

Tech Stack: Oracle HCM Cloud, REST/SOAP APIs, XML/JSON, middleware platforms (e.g., Dell Boomi, MuleSoft), SQL, data‑migration tools, Agile project management tools (Jira, Confluence).

Growth Path: Starting as an Analyst, high performers can progress to Senior Analyst, Consultant, Manager and eventually Senior Manager/Director, leading large‑scale transformation programs and shaping Deloitte’s HR technology practice.

Why Join Deloitte? Deloitte offers a collaborative, inclusive culture where learning is continuous. Fresh talent gets exposure to complex, high‑visibility public‑sector projects, mentorship from industry experts, and a clear career progression framework.

The firm’s commitment to work‑life balance, flexible work arrangements and a comprehensive benefits package makes it an attractive destination for ambitious professionals seeking to make a tangible impact on the future of work.

Eligibility & process

Who can apply

Bachelor’s degree in any discipline; minimum 1+ years of experience delivering Oracle HCM Cloud technical solutions; must be legally authorized to work in the United States without sponsorship; ability to obtain and maintain Public Trust clearance; willingness to travel up to 50% of the time; strong communication and teamwork skills; no backlogs at the time of joining.

Skills & stack

Oracle Hcm Cloud Integration Development Data Mapping Middleware (Boomi Mulesoft) REST APIs SOAP XML

Selection process

  1. Round 1: Online assessment (aptitude & logical reasoning)
  2. Round 2: Technical interview (focus on Oracle HCM, integration concepts, problem‑solving)
  3. Round 3: HR interview (behavioural fit, motivation, cultural alignment)

Prep kit

20 resources
Study material 4
Company-specific guides 4
Likely coding questions 4
Round-wise strategy 4
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 (Oracle Hcm Cloud, Integration Development, Data Mapping, Middleware (Boomi, Mulesoft), REST APIs, SOAP, XML) & 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 Deloitte Core Values, Learning Agility & Offer Terms Demonstrate passion, strong communication, and readiness for full-time collaboration.
Technical questions 5
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.
Behavioural & HR questions 3
Why do you want to join Deloitte as a Data Analyst?
Highlight Deloitte's market reputation, recent tech innovations, and how your skills in Oracle Hcm Cloud directly solve their team's objectives.
Describe a challenging bug or academic project roadblock and how you resolved it.
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?
Explain your prioritization strategy, proactive communication with mentors/peers, and agile mindset.
Deloitte 58.7k - 115.8k USD per annum
Recruiter Resume Apply
Chat Chat with Kashii