Questions 201–262 of 262
Why not use horizontal lines as transaction boundaries?
Asked once · last asked Nov 18 · Concept · Mid-level
Which ingestion pattern does a metadata-driven framework use, and how does it determine which pattern to apply?
Asked once · last asked Nov 18 · Concept · Senior
How would you import a new stored procedure into Boomi and pass its input and output parameters using the Database Connector?
Asked once · last asked Nov 19 · Tooling · Mid-level
What is the primary difference between a Decision shape and a Business Rules shape?
Asked once · last asked Nov 19 · Concept · Mid-level
How would you transform JSON into a more complex structure in Boomi, such as converting an object into an array, access any required DDPs in a script, and pass the result to a target? Show a few lines of code.
Asked once · last asked Nov 19 · Write code · Senior
How do you retrieve a DDP value in a Boomi script when the value, such as an employee ID, varies by record?
Asked once · last asked Nov 19 · Tooling · Mid-level
What is ExecutionUtil, and why would you use it to access a DDP from a script?
Asked once · last asked Nov 19 · Concept · Mid-level
What is the difference between committing by profile and committing by number of rows in the Database Connector?
Asked once · last asked Nov 19 · Concept · Senior
How would you use a Salesforce object to filter records received from a database by a parameter?
Asked once · last asked Nov 19 · Tooling · Mid-level
How would you retrieve a file and move it to another directory on the same SFTP server, and how many connections or actions would you need?
Asked once · last asked Nov 19 · Tooling · Mid-level
If SuccessFactors provides one email-information object with multiple addresses, how would you select a personal or work email based on a parameter and send the selected address to the target?
Asked once · last asked Nov 19 · Scenario · Mid-level
In SuccessFactors, how can a qualifier identify the type of email address in an email-information object?
Asked once · last asked Nov 19 · Concept · Mid-level
If a source field is optional but the target requires it, how would you send it as an empty value in a JSON object?
Asked once · last asked Nov 19 · Scenario · Mid-level
If today is the 19th and you need a date from six days earlier, how would you calculate and compare that relative date in Boomi, and would you use a DDP or DPP?
Asked once · last asked Nov 19 · Tooling · Mid-level
How would you move data into Salesforce, and what tool would you use?
Asked once · last asked Nov 19 · Tooling · Mid-level
How would you generate metadata across structured and unstructured data like PDFs, images, and binary files?
Asked once · last asked Nov 20 · Design · Senior
How would you automatically generate the document summary and categorization tags for the metadata?
Asked once · last asked Nov 20 · Design · Senior
How do you make data structured and normalized across different data sources?
Asked once · last asked Nov 20 · Scenario · Mid-level
How do you fetch data from the bronze layer to the silver layer?
Asked once · last asked Aug 25 · Scenario · Mid-level
Other ways it was asked
- “How do you load the latest or updated data from the bronze layer to the silver layer?”
Show an example of what a table might look like before it is unpivoted in Power BI.
Asked once · last asked Aug 28 · Tooling · Junior
What is the M language in Power Query, and when would you use it?
Asked once · last asked Feb 27 · Concept · Mid-level
Which transformation is used to convert columns to rows?
Asked once · last asked Apr 12 · Concept · Junior
Can you give an example of how a Normalizer transformation works?
Asked once · last asked Apr 12 · Concept · Junior
What is a data load process?
Asked once · last asked Apr 14 · Concept · Junior
What is EDIFACT, and when would you use it?
Asked once · last asked Apr 24 · Concept · Mid-level
How would you extract text from PDF files?
Asked once · last asked Jun 12 · Tooling · Mid-level
Other ways it was asked
- “How did you extract text from the PDFs?”
Why might you convert Excel files to PDF for processing, and what role can pandas play in a document-processing pipeline?
Asked once · last asked Jun 12 · Tooling · Mid-level
How does data typically move into Snowflake from a lakehouse architecture?
Asked once · last asked Jul 16 · Concept · Mid-level
What is a document loader?
Asked once · last asked Nov 20 · Concept · Junior
What is the difference between data cleaning and data transformation?
Asked once · last asked Jul 17 · Concept · Junior
What limitations of PDF libraries can you think of right away?
Asked once · last asked Jul 17 · Concept · Mid-level
How would you parse satellite image data for a computer vision project?
Asked once · last asked Aug 3 · Scenario · Mid-level
What is Databricks Auto Loader?
Asked once · last asked Aug 11 · Concept · Junior
Other ways it was asked
- “What is Auto Loader?”
How do you identify and integrate data sources into a data platform?
Asked once · last asked Aug 26 · Scenario · Mid-level
How do you unpivot columns in Power BI?
Asked once · last asked Aug 28 · Tooling · Junior
When merging consecutive turns in diarized transcript data, should grouping be based on the text or the speaker label?
Asked once · last asked Aug 28 · Concept · Mid-level
After designing a CSV import pipeline with background jobs, validation, error reporting, and progress feedback, what additional capability might users request next?
Asked once · last asked Sep 2 · Scenario · Mid-level
When importing a CSV file into a data workflow, what steps do you take beyond the import itself?
Asked once · last asked Sep 3 · Scenario · Mid-level
How would you extract and move data from a database?
Asked once · last asked Sep 3 · Scenario · Mid-level
How would you read data directly from a database rather than using an API?
Asked once · last asked Sep 3 · Scenario · Mid-level
What sources could provide students' marks for an AI chatbot that gives personalized recommendations?
Asked once · last asked Sep 5 · Scenario · Mid-level
What is Tableau Prep, and why do we need it?
Asked once · last asked Sep 9 · Concept · Junior
How would you read and ingest a file received from an external party into a data pipeline?
Asked once · last asked Sep 9 · Scenario · Mid-level
What would you configure in a data pipeline to fetch files from an external system?
Asked once · last asked Sep 9 · Scenario · Mid-level
What tools or utilities can you use to fetch files from an external system?
Asked once · last asked Sep 9 · Tooling · Mid-level
Can you explain a simple data pipeline that reads a file from a source and loads its data into BigQuery?
Asked once · last asked Sep 9 · Design · Mid-level
Other ways it was asked
- “Can you explain a simple data pipeline from reading a file from a source and loading the data into BigQuery?”
How would you use a Python script to process data, format files, or change file configurations in a data pipeline?
Asked once · last asked Sep 9 · Tooling · Mid-level
How do you use Google Cloud Dataflow to process data?
Asked once · last asked Sep 10 · Tooling · Mid-level
What is Snowpipe?
Asked once · last asked Sep 18 · Concept · Junior
How do you interface with sensors to collect data?
Asked once · last asked Sep 22 · Design · Mid-level
How do you manage manual data within an organization?
Asked once · last asked Sep 28 · Scenario · Mid-level
How would you provide data to a chatbot?
Asked once · last asked Sep 30 · Design · Mid-level
How would you load cleaned data into a data warehouse?
Asked once · last asked Oct 18 · Scenario · Mid-level
How will you integrate data from the different sources?
Asked once · last asked Nov 2 · Design · Mid-level
What are Power Platform dataflows used for?
Asked once · last asked Nov 4 · Concept · Mid-level
How can data be exposed from SAP?
Asked once · last asked Nov 5 · Tooling · Mid-level
How would you connect a dynamically sized keyword list to a dataset?
Asked once · last asked Nov 18 · Scenario · Junior
Which source formats should a document-processing system support?
Asked once · last asked Nov 18 · Concept · Mid-level
What steps would you take to import a dataset into MySQL?
Asked once · last asked Nov 18 · Tooling · Junior
What does execution level mean in Boomi scripting?
Asked once · last asked Nov 19 · Concept · Mid-level
What actions can you perform with the Boomi FTP Connector?
Asked once · last asked Nov 19 · Tooling · Mid-level
How would you transform company data after extracting it?
Asked once · last asked Nov 20 · Scenario · Junior
Page 1 · Page 2
More ETL and Data Pipelines interview questions
- All ETL and Data Pipelines interview questions
- ETL Basics and Data Pipeline Architecture Interview Questions
- Dbt Interview Questions
- Data Pipeline Orchestration and Deployment Interview Questions
- Incremental Loading, CDC, and Streaming Interview Questions
- ETL Data Quality and Validation Interview Questions
- Data Pipeline Performance Optimization Interview Questions
- Data Pipeline Monitoring and Troubleshooting Interview Questions
- Data Migration Interview Questions
How this list is made
Every question here was asked by a real interviewer in a real job interview that a candidate ran MeetAssist in. After the call, the interviewer's questions are pulled from the transcript. Practice sessions, tests, exams and anything that was not a job interview are dropped.
Questions are rewritten so they make sense on their own: names of people, employers and clients are removed, and speech-to-text mistakes are fixed. Small talk, logistics and questions about one candidate's own résumé are left out. Rephrasings of the same question are merged, and the count is the number of different interviews it came up in.
The interviews come from candidates who use MeetAssist, so they lean towards software, data and AI roles: the shares describe these interviews, not every ETL and Data Pipelines interview. Answers to the most asked questions are written and checked by an editor; a "common mistake" is shown only when reviews of real answers in these interviews show it, with the count.
398 interviews, 224 candidates, Nov 2025 to Nov 2026. Updated every month with new interviews.
Or add the Chrome extension