Questions 201–262 of 262

  1. Why not use horizontal lines as transaction boundaries?

    Asked once · last asked Nov 18 · Concept · Mid-level

  2. 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

  3. 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

  4. What is the primary difference between a Decision shape and a Business Rules shape?

    Asked once · last asked Nov 19 · Concept · Mid-level

  5. 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

  6. 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

  7. 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

  8. 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

  9. 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

  10. 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

  11. 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

  12. 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

  13. 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

  14. 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

  15. How would you move data into Salesforce, and what tool would you use?

    Asked once · last asked Nov 19 · Tooling · Mid-level

  16. How would you generate metadata across structured and unstructured data like PDFs, images, and binary files?

    Asked once · last asked Nov 20 · Design · Senior

  17. How would you automatically generate the document summary and categorization tags for the metadata?

    Asked once · last asked Nov 20 · Design · Senior

  18. How do you make data structured and normalized across different data sources?

    Asked once · last asked Nov 20 · Scenario · Mid-level

  19. 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?”
  20. 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

  21. What is the M language in Power Query, and when would you use it?

    Asked once · last asked Feb 27 · Concept · Mid-level

  22. Which transformation is used to convert columns to rows?

    Asked once · last asked Apr 12 · Concept · Junior

  23. Can you give an example of how a Normalizer transformation works?

    Asked once · last asked Apr 12 · Concept · Junior

  24. What is a data load process?

    Asked once · last asked Apr 14 · Concept · Junior

  25. What is EDIFACT, and when would you use it?

    Asked once · last asked Apr 24 · Concept · Mid-level

  26. 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?”
  27. 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

  28. How does data typically move into Snowflake from a lakehouse architecture?

    Asked once · last asked Jul 16 · Concept · Mid-level

  29. What is a document loader?

    Asked once · last asked Nov 20 · Concept · Junior

  30. What is the difference between data cleaning and data transformation?

    Asked once · last asked Jul 17 · Concept · Junior

  31. What limitations of PDF libraries can you think of right away?

    Asked once · last asked Jul 17 · Concept · Mid-level

  32. How would you parse satellite image data for a computer vision project?

    Asked once · last asked Aug 3 · Scenario · Mid-level

  33. What is Databricks Auto Loader?

    Asked once · last asked Aug 11 · Concept · Junior

    Other ways it was asked
    • “What is Auto Loader?”
  34. How do you identify and integrate data sources into a data platform?

    Asked once · last asked Aug 26 · Scenario · Mid-level

  35. How do you unpivot columns in Power BI?

    Asked once · last asked Aug 28 · Tooling · Junior

  36. 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

  37. 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

  38. 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

  39. How would you extract and move data from a database?

    Asked once · last asked Sep 3 · Scenario · Mid-level

  40. How would you read data directly from a database rather than using an API?

    Asked once · last asked Sep 3 · Scenario · Mid-level

  41. What sources could provide students' marks for an AI chatbot that gives personalized recommendations?

    Asked once · last asked Sep 5 · Scenario · Mid-level

  42. What is Tableau Prep, and why do we need it?

    Asked once · last asked Sep 9 · Concept · Junior

  43. 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

  44. What would you configure in a data pipeline to fetch files from an external system?

    Asked once · last asked Sep 9 · Scenario · Mid-level

  45. What tools or utilities can you use to fetch files from an external system?

    Asked once · last asked Sep 9 · Tooling · Mid-level

  46. 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?”
  47. 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

  48. How do you use Google Cloud Dataflow to process data?

    Asked once · last asked Sep 10 · Tooling · Mid-level

  49. What is Snowpipe?

    Asked once · last asked Sep 18 · Concept · Junior

  50. How do you interface with sensors to collect data?

    Asked once · last asked Sep 22 · Design · Mid-level

  51. How do you manage manual data within an organization?

    Asked once · last asked Sep 28 · Scenario · Mid-level

  52. How would you provide data to a chatbot?

    Asked once · last asked Sep 30 · Design · Mid-level

  53. How would you load cleaned data into a data warehouse?

    Asked once · last asked Oct 18 · Scenario · Mid-level

  54. How will you integrate data from the different sources?

    Asked once · last asked Nov 2 · Design · Mid-level

  55. What are Power Platform dataflows used for?

    Asked once · last asked Nov 4 · Concept · Mid-level

  56. How can data be exposed from SAP?

    Asked once · last asked Nov 5 · Tooling · Mid-level

  57. How would you connect a dynamically sized keyword list to a dataset?

    Asked once · last asked Nov 18 · Scenario · Junior

  58. Which source formats should a document-processing system support?

    Asked once · last asked Nov 18 · Concept · Mid-level

  59. What steps would you take to import a dataset into MySQL?

    Asked once · last asked Nov 18 · Tooling · Junior

  60. What does execution level mean in Boomi scripting?

    Asked once · last asked Nov 19 · Concept · Mid-level

  61. What actions can you perform with the Boomi FTP Connector?

    Asked once · last asked Nov 19 · Tooling · Mid-level

  62. 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

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.