Top 25
Prep plan
Updated weekly · Last refresh Aug 30

Arch Global Services Philippines Data Analyst Interview Questions

The questions to prepare for a Arch Global Services Philippines Data Analyst interview. Questions from real interview reports rank first. Updated weekly.

25questions
~3htotal time
Track your progressSign up free to work through all 25 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 11 questions + 3 drills · ~118 min
Validating Data Before ReportingEasy
Recently asked

Explain how to validate SQL data before reporting, including null checks, duplicates, outliers, and aggregation reconciliation.

JoinsData WranglingQualityArch Global Services Philippines
Optimizing SQL Query PerformanceHard
Recently asked

Tests your ability to diagnose and improve SQL performance in production data workflows.

Performance TuningArch Global Services Philippines
Dashboard for Accruals and PrepaymentsHard
Recently asked

Tests your ability to model metrics and design dashboards for finance-focused reporting.

data visualizationdashboard designreportingArch Global Services Philippines
Handling Bad Data Under DeadlineMedium
Recently asked

Tests your triage, data cleaning approach, and ability to deliver accurate reporting under time pressure.

Data Qualitytime managementreportingArch Global Services Philippines
SQL Joins and Subqueries in ProductionMedium
Recently asked

Tests your ability to write correct and maintainable SQL for production reporting and analytics.

SubqueriesJoinssql queriesArch Global Services Philippines
Data Extraction and CleansingMedium
Recently asked

Tests your ability to build reliable pipelines and ensure data quality for analytics at Arch Global Services Philippines.

Data Qualitydata extractionArch Global Services Philippines
Top Customers by Net SalesMedium
Practice
Practice drill

Compute top 10 customers by net sales using joins and aggregations, ordering by revenue with deterministic tie-breaking.

SubqueriesJoinsData WranglingGain DigitalTCSZest AI
Unify CRM and Google Analytics ViewHard
Practice
Practice drill

Merge CRM orders with GA events via an identity map to build a customer-level view using joins, window functions, and monthly rollups.

SubqueriesJoinsData WranglingArtefact
Deduplicate Out-of-Order Replication EventsMedium
Practice
Practice drill

Use ROW_NUMBER() to keep the earliest created_at 'Repl created' per entity and return out-of-order duplicates to delete.

Window FunctionsSubqueriesJoinsReplitQuantcast
More SQL & Data Manipulation questions with a free account
2
Behavioral & Leadership13 questions · ~104 min
Learning a New Tool FastEasy
Recently asked

Tests learning agility under delivery pressure, with emphasis on ownership, prioritization, and adapting quickly to unfamiliar technical work.

learning agilityinitiativeadaptabilityArch Global Services Philippines
More Behavioral & Leadership questions with a free account
3
More topics1 question · ~8 min
The finish line: interview-readyComplete all 25 questions plus 3 hands-on drills to finish this plan.