Interview preparation

Cresta interview process & preparation

Cresta currently has 99+ live openings on OnJob.io, concentrated in Data Analyst, Sales / Business Development and Software Engineer roles. There are no leaked or company-specific questions here — instead, prepare with the general, role-based interview rounds and most-asked questions for those role types below, then practise them free with OnJob's AI mock interview.

Practise with AI mock interview See live Cresta jobs

Honest note: OnJob.io does not publish leaked or company-confidential interview questions. The guides below are general, role-based preparation — the standard rounds and commonly-asked questions for the role types Cresta is currently hiring for. Use them to prepare; your real Cresta interview may differ.

What to expect when interviewing for Data Analyst, Sales / Business Development and Software Engineer roles at companies like Cresta

Cresta is currently advertising these role types on OnJob.io. Each guide is the general interview structure and most-asked questions for that role — prepare with it, then rehearse free with the AI mock interview.

General Data Analyst interview prep

17 live roles at Cresta

SQL, Excel, statistics and storytelling with data — the analyst interview for product, BI and analytics teams across India.

Typical Data Analyst interview rounds

1 SQL round. Joins, aggregations, window functions and query writing.
2 Excel / spreadsheet round. Lookups, pivot tables and formulas.
3 Case / analytics round. Business case: define metrics, analyse and recommend.
4 Tool & viz round. Power BI / Tableau dashboards and stakeholder communication.

Commonly-asked Data Analyst questions

What is the difference between INNER JOIN, LEFT JOIN and FULL OUTER JOIN?
Write a SQL query to find the second-highest salary in a table.
What is the difference between WHERE and HAVING?
Explain window functions like ROW_NUMBER(), RANK() and DENSE_RANK().
What is the difference between mean, median and mode, and when is each misleading?
How do you handle missing or null values in a dataset?
Explain the difference between a primary key and a foreign key.
What is normalisation, and why does it matter for analysis?

Full Data Analyst prep AI mock interview

General Sales / Business Development interview prep

14 live roles at Cresta

Pitching, objection handling, pipeline and targets — the sales / BD interview for SaaS, startups and inside-sales teams.

Typical Sales / Business Development interview rounds

1 Screening / fit. Motivation, communication and comfort with targets.
2 Role-play / mock pitch. Sell a product, handle objections, close.
3 Behavioural & track record. Past numbers, deals closed and how you hit quota.
4 Manager round. CRM, sales process and how you handle rejection.

Commonly-asked Sales / Business Development questions

Sell me this pen (or our product) right now.
Walk me through your sales process from lead to close.
How do you handle objections like 'it's too expensive' or 'we're happy with our current vendor'?
How do you qualify a lead — what makes it worth your time?
Tell me about the biggest deal you closed and how you did it.
How do you handle rejection and stay motivated?
What is your approach to cold calling or cold outreach?
How do you build rapport with a prospect quickly?

Full Sales / Business Development prep AI mock interview

General Software Engineer interview prep

9 live roles at Cresta

Coding, data structures, algorithms and system design — the core software engineering loop used by product companies and startups across India.

Typical Software Engineer interview rounds

1 Online assessment. Timed coding problems on arrays, strings and hashing on HackerRank or HackerEarth.
2 DSA / problem solving. 1–2 live coding rounds on data structures, algorithms and complexity analysis.
3 System design. Designing a scalable service (mid/senior); low-level design for early-career.
4 Hiring manager / culture fit. Past projects, ownership, behavioural questions and team fit.

Commonly-asked Software Engineer questions

Reverse a linked list, both iteratively and recursively.
Find the two numbers in an array that add up to a target sum.
Detect whether a linked list has a cycle.
What is the difference between a process and a thread?
Explain time and space complexity (Big O) with examples.
How does a hash map work internally, and what happens on collisions?
Find the longest substring without repeating characters.
What is the difference between an array and a linked list?

Full Software Engineer prep AI mock interview

General Backend Developer interview prep

8 live roles at Cresta

APIs, databases, concurrency and system design — the server-side engineering interview across product companies and fintech.

Typical Backend Developer interview rounds

1 DSA round. Coding problems plus complexity analysis.
2 Language & runtime. Deep dive on your primary language (Java/Node/Python/Go) and its concurrency model.
3 Database & API design. Schema design, indexing, transactions and REST/gRPC API design.
4 System design. Designing scalable, fault-tolerant backend services.

Commonly-asked Backend Developer questions

Explain the difference between SQL and NoSQL, and when you'd choose each.
What is database indexing and how does it speed up queries?
Explain ACID properties in a database transaction.
What is the difference between REST and GraphQL?
How do you handle concurrency and race conditions in your backend?
What is a deadlock and how do you prevent it?
Explain caching strategies — write-through, write-back and cache invalidation.
What is the difference between horizontal and vertical scaling?

Full Backend Developer prep AI mock interview

General Digital Marketing interview prep

5 live roles at Cresta

SEO, performance ads, content and analytics — the digital marketing interview for agencies, startups and growth teams.

Typical Digital Marketing interview rounds

1 Fundamentals round. SEO, SEM, social, email and the marketing funnel.
2 Channel deep-dive. Your strongest channel — Google/Meta ads, SEO or content.
3 Analytics & case. Read a campaign's data and recommend optimisations.
4 Strategy & culture fit. Campaign planning, budgets and collaboration.

Commonly-asked Digital Marketing questions

What is the difference between SEO and SEM?
Explain the marketing funnel (awareness → consideration → conversion).
What is the difference between CPC, CPM, CPA and ROAS?
How do you measure the success of a digital marketing campaign?
What are the main Google ranking factors you optimise for?
Walk me through how you'd plan a campaign with a fixed budget.
What is A/B testing and how do you run one on an ad or landing page?
How do you reduce a high bounce rate on a landing page?

Full Digital Marketing prep AI mock interview

General DevOps Engineer interview prep

4 live roles at Cresta

CI/CD, cloud, containers, Kubernetes and infrastructure-as-code — the DevOps / SRE interview for cloud-native and scaling teams.

Typical DevOps Engineer interview rounds

1 Linux & scripting. Shell scripting, permissions, processes and networking.
2 CI/CD & automation. Pipelines, build/release flow and IaC.
3 Cloud & containers. AWS/Azure/GCP, Docker and Kubernetes.
4 Troubleshooting / scenario. Debug a failing deployment or a production incident.

Commonly-asked DevOps Engineer questions

What is the difference between continuous integration, delivery and deployment?
Explain how Docker works and the difference between an image and a container.
What is Kubernetes and what problems does it solve?
Explain the difference between a Kubernetes Deployment, Pod and Service.
What is infrastructure as code, and why use Terraform?
How would you set up a CI/CD pipeline for a microservices app?
How do you troubleshoot a server that's running out of memory?
Explain blue-green vs canary deployments.

Full DevOps Engineer prep AI mock interview

Rehearse your Cresta interview, free

Run a realistic AI mock interview for your target role and get instant feedback on your answers — or take a timed mock test to check your fundamentals before the real thing.

AI mock interview Free mock test Cresta jobs

Interview prep at other companies

Cresta interview — FAQs

How do I prepare for a Cresta interview?

Prepare by role: identify the role you're applying for, then practise the standard interview rounds and most-asked questions for that role type. Cresta is currently hiring for Data Analyst, Sales / Business Development and Software Engineer roles, so focus there. Use OnJob's free AI mock interview to rehearse with instant feedback, and review the role-specific question lists below. These are general role-based questions, not leaked Cresta questions.

What questions are asked in a Cresta interview?

We don't publish leaked or company-specific Cresta questions. What we do provide is the general, frequently-asked interview questions for the role types Cresta hires for — such as Data Analyst, Sales / Business Development and Software Engineer roles. For example, Data Analyst interviews commonly cover: What is the difference between INNER JOIN, LEFT JOIN and FULL OUTER JOIN? Write a SQL query to find the second-highest salary in a table. What is the difference between WHERE and HAVING? Prepare with these general questions and OnJob's free AI mock interview.

How many rounds does a Cresta interview have?

It depends on the role. A typical Data Analyst interview runs across 4 rounds — SQL round, Excel / spreadsheet round, Case / analytics round, Tool & viz round. Round counts vary by company and seniority; treat this as the general structure to prepare for, not a guarantee of Cresta's exact process.

Is Cresta hiring right now?

Yes — Cresta has 99+ live openings on OnJob.io, refreshed daily, mostly for Data Analyst, Sales / Business Development and Software Engineer roles. Browse the live Cresta jobs and see your AI match score on each before you apply.

Free forever — no credit card

Get matched to Cresta roles you're ready for

Create a free profile to see your AI match score on every live Cresta opening, practise the interview, and apply in one click.

Create my free profile Browse Cresta jobs