Skip to content
SFMC Interview Q&A 19 min read 11 sections

How to Become a Salesforce Marketing Cloud Developer in India

Plenty of people move into Marketing Cloud work from email marketing, agency delivery, BPO process roles and non-IT degrees. The move is real. What is not real is the version sold as three weeks of drag and drop. Marketing Cloud sits on a data model, a SQL dialect, a scripting language and a set of

RL

RizeX Labs

RizeX Labs

Published

Last updated

Related programme

Salesforce Marketing Cloud Training

Email Studio, Journey Builder, AMPscript and SQL segmentation on real campaign work. A specialist track with more open roles in India than trained people.

See the curriculum

3000+ learners · 270+ hiring partners

Plenty of people move into Marketing Cloud work from email marketing, agency delivery, BPO process roles and non-IT degrees. The move is real. What is not real is the version sold as three weeks of drag and drop. Marketing Cloud sits on a data model, a SQL dialect, a scripting language and a set of APIs, and any opening worth chasing expects you to handle all of them. Below is what the work actually looks like in a week, the order to learn things in with study hours attached, the certification ladder, and the honest problem of practising a platform you cannot get a free personal copy of.

What a Marketing Cloud developer does in a normal week

Strip away the job description and the week looks like this.

You open Automation Studio and check what ran overnight. A file was supposed to land on SFTP at 2am, an Import File activity was supposed to pick it up, a Query Activity was supposed to rebuild a segmentation data extension, and a Send Email activity was supposed to fire off it. Something in that chain failed, and you work out which link.

You write SQL. Not reporting SQL, segmentation SQL. Customers who bought but were never sent the follow-up. Customers who received email A and not email B. The latest transaction per customer, deduplicated. Each one becomes a target data extension that a journey or a send reads from.

You edit email content. Content Builder blocks with AMPscript in them, pulling the customer's name, their last order, a conditional call to action that changes if their policy is expiring. You test it against a test data extension because the personalisation breaks silently if a lookup returns nothing.

You build or fix a journey. A contact did not enter. You check the entry source data extension, the entry criteria, re-entry settings, and whether the contact is on a suppression list.

You run tracking queries against data views to answer "how did the campaign do". _Sent, _Open, _Click, _Bounce, _Unsubscribe, _Job, _Journey.

Some weeks you do API work. An external system posts an event, a triggered send fires, or rows get inserted into a data extension over REST. Some weeks you build a CloudPage, usually a preference centre or an unsubscribe page that writes back to a data extension. Some weeks you are on a deliverability problem, bounces up, complaints up, and you are looking at authentication and send reputation rather than code.

The marketer-leaning role and the developer-leaning role

The title "Marketing Cloud developer" covers two very different jobs in Indian teams, and knowing which one you are applying for changes what you study.

Marketer-leaning Developer-leaning
Common titles Marketing Cloud Specialist, Email Marketing Executive, Campaign Executive Marketing Cloud Developer, SFMC Developer, Marketing Automation Developer
Daily tools Content Builder, Email Studio, Journey Builder canvas Automation Studio, Query Activity, AMPscript, SSJS, CloudPages, Postman
Main output Campaigns built, tested and sent on schedule Data models, query sets, reusable content, integrations
Code needed Personalisation strings, basic HTML edits, light AMPscript SQL daily, AMPscript often, SSJS and API work when required
Debugging expected "The email looks wrong" "The automation errored at step 3 and nobody knows why"
Usual entry route Digital marketing, email marketing, agency, BPO Any of the above plus serious SQL, or a support or QA background

The marketer-leaning role is the easier door to walk through and the harder one to grow out of. People who stay purely drag-and-drop tend to stay at campaign execution. The moment you can write the query that builds the audience and explain why the automation failed, you are in the other conversation.

If you are coming from digital marketing or BPO, the honest reading is that you already own half the developer-leaning role. You understand campaigns, segments, opt-outs, why a send window matters. What you are missing is data and code, and that part is teachable.

A note on pay before anything else

Do not take a pay figure off any article, including this one. Bands for Marketing Cloud work in India move with experience, city, whether the employer is a product company, a consulting partner or an agency, and how much SQL and API work the role really carries. Open a live job board, filter for Marketing Cloud roles in the cities you would work in, and read what current postings say. That is real data with a date on it. An article is a guess with no date on it.

Why Marketing Cloud is a separate skill from Salesforce CRM

This trips up more people than anything else. Marketing Cloud is not a module of the CRM. It came into Salesforce by acquisition, it has its own login, its own data structures and its own security model. A Salesforce administrator with three years on Sales Cloud starts Marketing Cloud closer to the beginning than they expect.

Concept in Salesforce CRM What it becomes in Marketing Cloud
Objects and records Data extensions and rows, plus lists and subscribers in the older model
SOQL SQL, a subset of the SQL Server dialect, run in Query Activity
Apex AMPscript for content and SSJS for logic
Flow and Process Builder Automation Studio and Journey Builder
Single org with profiles and permission sets Business units with roles and permissions, parent and child
Sandboxes and change sets No equivalent. You move work between business units or tenants by hand or by API
Lightning Web Components, Visualforce CloudPages with HTML, CSS, JavaScript, AMPscript and SSJS
Record ID Subscriber Key and Contact Key, which you design rather than receive

What genuinely carries over from CRM experience: relational thinking, comfort with a multi-tenant admin console, OAuth and API concepts, the discipline of testing before deploying, and knowledge of the Contact, Lead and Campaign objects that Marketing Cloud Connect synchronises with. If you have done integration work on the CRM side, that transfers almost directly to Module 12 territory.

What does not carry over: Apex, SOQL syntax, triggers, governor limits, validation rules, the deployment tooling, and most of the declarative automation. Budget for learning a new platform, not an extension of one you know.

One more thing worth knowing. Salesforce is evolving the marketing product line, and there is a newer Marketing Cloud built closer to the core platform alongside the existing Engagement product. The data modelling, segmentation, SQL and deliverability skills in this post are the portable part. Tool screens change, the thinking does not.

Do you need to code, and how much

Yes, and less than you fear, but not zero.

SQL is the non-negotiable one. It is the single biggest predictor of whether someone from a non-IT background makes it into a developer-leaning role. Inside a Query Activity you write a SELECT against data extensions and data views and write the result to a target data extension, with overwrite, append or update behaviour. You cannot create tables, you cannot use temp tables or stored procedures, and a query that runs too long is cancelled by the platform. So set-based thinking beats clever nesting.

The working vocabulary is real but finite. SELECT, WHERE, DISTINCT, IN, BETWEEN, LIKE, IS NULL, CASE, COALESCE. Then INNER JOIN and LEFT JOIN, self joins, multi-table joins. Then GROUP BY and HAVING, subqueries, EXISTS and NOT EXISTS, and the window functions that do most of the real work: ROW_NUMBER() with PARTITION BY for deduplication and latest-record selection. Add DATEADD, DATEDIFF, CAST and CONVERT and you can build almost any audience an Indian marketing team will ask for.

AMPscript is a small language you will use constantly. It runs at send time, per subscriber, inside email content, and at page load on a CloudPage. Twenty-odd functions cover most production work: Lookup, LookupRows, LookupOrderedRows, RowCount, Row, Field, AttributeValue, IF / ELSEIF / ELSE, IIF, Concat, Substring, Length, IndexOf, Now, DateAdd, FormatDate, Empty, RaiseError, and for writing back, InsertDE, UpsertDE and UpdateDE. On CloudPages add RequestParameter, CloudPagesURL and RedirectTo. It is procedural. If you can build a nested IF in Excel, the syntax will not defeat you.

SSJS is optional for a first job and expected later. Server-side JavaScript in Marketing Cloud gives you loops, functions, the Core library loaded with Platform.Load, HTTP calls out to external services, and WSProxy for bulk platform operations that AMPscript cannot do well. Learn plain JavaScript first, then the platform libraries.

HTML and CSS for email is its own craft. Table-based layout, inline styles, media queries, dark mode behaviour. It is not modern web HTML, and that surprises people who have built websites.

There is a trap in all of this that the trainers here see every batch. Candidates know the syntax and not the execution. They can write a LookupRows and cannot say when it runs, where it runs, or what data it can reach. Learn the three execution contexts as a single fact and repeat it until it is automatic: SQL runs on a schedule in Automation Studio, against data extensions and data views in one business unit, writing to one target data extension, and never sees a live subscriber. AMPscript runs at send time per subscriber inside the message, or at page load on a CloudPage. SSJS runs in those same places and also in a Script Activity inside an automation, and it alone can make an outbound HTTP call. Say that clearly in an interview and you sound like someone who has actually worked.

The skill sequence, in order, with study hours

This follows the order of the curriculum used in training, which is built so that each phase makes the next one possible. Hours are focused study and practice, not hours with a video open in a background tab.

# Phase What it covers Hours
1 Platform shape Cloud service models, SFMC architecture, Studios and Builders, business unit basics 12 to 15
2 Contact Builder and the data model Data extension types, sendable and non-sendable, primary and composite keys, retention policies, send relationships, attribute groups, data relationships, Contact Key against Subscriber Key, list-based against contact-based models 30 to 35
3 Email Studio and Content Builder Templates, content blocks, shared and reusable content, personalisation strings, dynamic and rules-based content, A/B testing, send classifications, sender and delivery profiles 25 to 30
4 AMPscript Syntax, variables, data extension functions, string and date functions, conditional logic, FOR loops, dynamic URLs, conditional CTAs, data writing, error handling 35 to 45
5 Compliance and subscriber management CAN-SPAM, GDPR, CCPA, publication lists, suppression and exclusion lists, unsubscribe handling, Enhanced FTP and SFTP, file drops, encryption, import and extract 15 to 18
6 Tracking and reporting Metrics, tracking extracts, the data views, SQL-based reporting, send and campaign level analysis 20 to 25
7 SQL and Automation Studio Basic SQL through window functions, plus Import File, Filter, Query, Data Extract, Script, Wait and Verification activities, scheduled, triggered and file-drop automations 50 to 60
8 Journey Builder, basic then advanced Entry sources, decision and engagement splits, wait activities, update contact, exit criteria, goals, re-entry rules, suppression, versioning, testing, monitoring 25 to 30
9 Mobile Studio MobileConnect, keywords, opt-in and opt-out, MO and MT messages, SMS in journeys, MobilePush basics 8 to 10
10 Web Studio and CloudPages Landing pages, microsites, Smart Capture, form processing, data extension writeback, URL parameters, security considerations 20 to 25
11 SSJS JavaScript fundamentals, Platform.Load, Core library, HTTP functions, WSProxy retrieve and create and update, pagination and filtering 30 to 40
12 APIs and integrations REST and SOAP basics, installed packages, OAuth 2.0, access tokens, the Data Extension, Journey, Contact and Triggered Send APIs, Postman collections, Marketing Cloud Connect and synchronised data extensions 35 to 45
13 Security, deliverability, transactional messaging Roles and permissions, API users, credential management, sender and IP reputation, IP warming, SPF, DKIM, DMARC, bounce management, triggered and transactional sends, Einstein features 25 to 30
14 Testing, deployment, debugging Test data extensions, preview and test, rendering, negative and regression testing, UAT, environment management, migration by hand, and the failure list: email not sending, contact not entering a journey, automation failure, import failure, file not detected, API 400 and 401 and 403 25 to 30
15 Two end-to-end projects An airline campaign system and an insurance or supply chain system, each with a relational data model, segmentation SQL, AMPscript personalisation, journeys, CloudPages, API integration and reporting 60 to 80

That totals roughly 420 to 520 hours. Divide by the hours you can genuinely give it each week and you have your own answer, without anyone selling you a month count.

Two practical notes on the order.

First, start basic SQL in parallel with Phase 2 rather than waiting for Phase 7. The data model only becomes intuitive when you can query it, and SELECT, WHERE and JOIN take a weekend.

Second, phases 1 to 8 make you employable for the marketer-leaning role. Phases 9 to 15 are what turn you into the developer-leaning one. If you need income sooner, the split is a legitimate plan, provided you keep going afterwards.

The certification ladder and when to sit each exam

The order that works is Email Specialist, then Administrator, then a branch to Developer or Consultant.

Marketing Cloud Email Specialist. The entry credential and the right first target. It covers Email Studio, Content Builder, subscriber and list management, tracking, and basic deliverability. Sit it after phases 1 to 6, so somewhere around 130 to 160 hours in. It is the certificate that gets a fresher profile past a screening filter for campaign roles.

Marketing Cloud Administrator. Account configuration, business units, roles and permissions, data management, automation, Marketing Cloud Connect setup and troubleshooting. Sit it after phases 7, 8 and 13, once you have actually built automations and can reason about permissions.

Then branch. Marketing Cloud Developer is the technical one: AMPscript, SSJS, the APIs, data modelling, CloudPages, security. Take it if you want the build side. Marketing Cloud Consultant is the solution-design one: requirement gathering, data architecture, campaign and journey design, deployment. It lists the Email Specialist credential as a prerequisite, so check the current exam guide before you book anything.

Beyond that, Marketing Cloud Account Engagement and Marketing Cloud Personalization are separate credentials for separate products. They are not the next rung of this ladder.

Before you book any of these, read the current official exam guide for the sections, weightings, question count, pass mark, fee and the maintenance requirement. Salesforce revises these. Anything you read in a blog post about exam mechanics, again including this one, has a shelf life.

Be clear-eyed about what a certificate does. It gets your profile read. It does not survive a technical round. The trainers here put it bluntly: candidates fail on demonstration, not knowledge. They know the topic and cannot show it. A Developer certificate with no queries you can open and explain is a weaker position than no certificate and a repository full of work.

Practising without a licence, and where the free options actually stop

This is the hardest part of this particular path and the part most guides skip.

There is no free, permanent, self-serve Marketing Cloud org. The Salesforce Developer Edition that everyone recommends gives you a CRM org. It is not Marketing Cloud Engagement. Anyone telling you to sign up for a free SFMC developer edition is describing something that does not exist. Accept that early and plan around it instead of hunting for it.

Here is what the free options genuinely give you, and exactly where each one runs out.

Free option What it genuinely gives you Where it stops
Trailhead Marketing Cloud Engagement trails Vocabulary, product tours, concept checks, the official framing of features Mostly reading and quizzes. You cannot build a journey or run a query in a live tenant
Salesforce Developer Edition (CRM) A real free CRM org with Contacts, Leads, Campaigns, reports It is the CRM side only. You can model what Marketing Cloud Connect would synchronise, but cannot complete the connection
SQL Server Express, or any free T-SQL sandbox Genuine, fully transferable SQL practice. Recreate the data views as tables and write real segmentation queries Query Activity behaviour, target data extension overwrite and update rules, and platform runtime limits only appear in a real tenant
Postman with any public REST API OAuth 2.0 flows, headers, request bodies, status codes, collections, environments and variables SFMC endpoints need a tenant subdomain and an installed package with a client ID and secret
A code editor plus email rendering test tools Responsive HTML email templates, dark mode handling, client quirks You cannot render AMPscript or preview against subscriber data
Browser console or Node Core JavaScript, loops, functions, JSON handling for SSJS Platform.Load, the Core library and WSProxy exist only inside Marketing Cloud
An employer, partner or training tenant Everything, including the parts above that stop Requires being inside a company, a Salesforce partner, or a training provider that has a real account

The SQL row is the important one. Install SQL Server Express or open a free T-SQL sandbox, create tables called _Sent, _Open, _Click, _Bounce, _Unsubscribe and _Job with the real column names, load a few thousand rows of made-up data into them, and write the queries the job asks for. Non-openers in the last 90 days. Customers who received email A and not email B. Latest transaction per customer with ROW_NUMBER(). This costs nothing and it transfers one to one into a Query Activity on day one of a real job.

If you are considering paid training, the single question to ask before paying is whether you get hands-on time in a real Marketing Cloud tenant with your own login, and for how many weeks. Recorded videos and slide decks you can find cheaply. Tenant access is the thing that is actually scarce, and it is the only reason to pay a premium.

Building something demonstrable when you cannot get an org

You can build a convincing body of work without ever logging into a tenant, as long as you are honest about what it is. Do not dress design work up as production experience. Interviewers go five levels deep on a claimed project. Which table, what requirement, why this approach over the other one, what was your role. Fabricated project experience does not survive that. Design work that you own completely does.

Take one of the standard project domains, an airline or an insurance business, and build these five artefacts.

1. A written data model. Entities for customer, booking, flight, payment and loyalty, or customer, policy, claim, premium and agent. For each data extension: field list with data types, which field is the primary key, whether it is sendable and what it sends on, the retention policy and why, the send relationship, and the naming convention you chose. Then the attribute group design showing the 1:1 and 1:N relationships. Two or three pages. This one document answers most Contact Builder interview questions on its own.

2. A SQL repository. Ten to fifteen queries in a public Git repository. Each file carries the business requirement in a comment at the top, the query, and a note on which target data extension it writes to and whether it overwrites, appends or updates. Include the awkward ones: deduplication, latest record per customer, inactive customers, purchased-but-not-emailed, received-A-not-B. Include the sample data so anyone can run them.

3. Email templates with the AMPscript written in. Two or three responsive HTML emails with the personalisation blocks written out and commented, explaining what each lookup fetches and what happens when it returns nothing. Say plainly that these were built outside a tenant.

4. A campaign runbook. One campaign documented end to end as a step list: file lands on SFTP with this naming pattern, File Drop automation triggers, Import File activity loads into a staging data extension, Query Activity builds the segmentation data extension, journey entry source reads it, decision split routes on an attribute, email sends, tracking query reports on it the next morning. Then a failure column beside each step. What breaks, what error you would see, what you would check first. Debugging knowledge is what separates candidates in technical rounds, and you can build this from reading alone.

5. A Postman collection. OAuth token request, insert rows into a data extension, trigger a journey API entry event, retrieve journey status. Point it at mock endpoints if you must. Document what a 400, a 401 and a 403 each mean in this context and what you would change for each.

Then record yourself, eight to ten minutes, walking through the data model and two of the queries out loud. Watch it back. That recording is the difference between knowing the material and being able to show it, and showing it is what you are actually being tested on.

How interviews map onto all of this

Interview question banks for this role cluster into the same areas every time: core platform fundamentals, Email Studio and Content Builder, Journey Builder, Automation Studio, AMPscript, SQL and data views, Contact Builder and the data model, APIs and integrations, integration with other Salesforce products and middleware, deliverability and compliance and security, MobileConnect and MobilePush, analytics and attribution, and architecture and system design.

Read that list against the phase table above and the plan writes itself. The first seven clusters map to phases 1 to 8 and carry most of the questions in a first-round screen. The last six show up when the role is genuinely senior or the panel is an architect.

One more habit worth building before you sit in front of anyone. Answer in a fixed shape: the situation, the approach you took, the reason you chose it, and the result. Not "actually sir basically in our project we had one requirement and basically". The content of your answer may be identical either way. The impression is not.

Where to start this week

Pick the phase table, start at Phase 1, and start basic SQL on the side the same week. Write down the hours you actually put in, because the plan only works if the hours are real. Build the data model document early, even before you understand everything in it, and improve it as you go, because it forces every Contact Builder concept to become concrete.

If you want the sequence delivered with hands-on tenant access and the two end-to-end projects built under review rather than alone, that is what the Salesforce Marketing Cloud training at RizeX Labs is structured around. And whatever you decide about training, check current pay bands on a live job board before you make any career decision based on them.

Last updated 13 October 2026