ZoomInfo Technologies Data Engineer Interview Questions
The questions to prepare for a ZoomInfo Technologies Data Engineer interview. Questions from real interview reports rank first. Updated weekly.
Find the first non-repeating character in a string using frequency counting and a second pass in O(n) time.
ZoomInfo TechnologiesCount case-insensitive English letters in a string while ignoring digits, spaces, and punctuation.
ZoomInfo TechnologiesCompare star and snowflake schemas for warehouse design, including trade-offs in normalization, query simplicity, and analytics performance.
ZoomInfo TechnologiesExplain how FULL OUTER JOIN and LEFT JOIN differ when reconciling customer records across systems.
ZoomInfo TechnologiesTests SQL techniques for detecting and removing duplicates safely.
ZoomInfo TechnologiesAggregate ZoomInfo Engage activities by type and date, include zero-activity combinations, and calculate day-over-day changes.
ZoomInfoZoomInfo TechnologiesFind the second highest distinct salary from a single table using basic PostgreSQL ordering and limiting.
eClinicalWorks
Informatica
Spectraforce TechnologiesUse joins, CTEs, and monthly aggregation to compute Google Maps active users and month-over-month growth.
Engine
GoogleZoomInfo TechnologiesSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Approach for maintaining data quality and integrity across ETL pipelines.
ZoomInfo TechnologiesApproach for handling schema changes and data quality checks in a high-volume data lake pipeline.
ZoomInfo TechnologiesBuild and maintain a reporting model for dashboards using dimensional design, ELT, data quality checks, and scheduled transformations.
ZoomInfo Technologies