Estimate greenfield and brownfield ETL platform work by complexity

For data-engineering solutioning teams sizing ETL platform implementations and modernisations before a proposal goes out.

Engagement type: Solo Pod
Experts: 1 lead · 1 consulted
Hours: ~30
Duration: 2 weeks

What the client needed

A firm needed to size ETL platform work: the common scenarios for greenfield implementation and brownfield modernisation, what defines a simple, medium and complex greenfield scenario, the phases and phase-wise activities, and broad end-to-end effort and timeline for low, medium and high complexity.

The brief

The questions on the table

As the client wrote them, lightly shortened. Client and respondents are not named.

Q1
In which scenarios do greenfield ETL implementations and brownfield modernisations happen?
Q2
What characterises simple, medium and complex greenfield scenarios?
Q3
What are the phases — analysis and design, build or migrate, test — and the activities in each?
Q4
What are broad end-to-end effort and timeline ranges for low, medium and high complexity?

The hours

What the work involved

01
Scenario catalogue
Greenfield on a new cloud platform, consolidation of tools, migration off legacy ETL, with the characteristics that set complexity: sources, mappings, volumes, orchestration, data quality.
02
Phase model
Analysis and design, build or migrate, test and cutover, with activities and the deliverables per phase from the lead’s Informatica and cloud-ETL programmes.
03
Effort ranges
End-to-end effort and timeline for low, medium and high complexity, with team shape.
04
Cross-check
A BI and data-analytics solutions architect from a top-tier provider reviewed the ranges.
05
Working session
With the client’s data solutioning team.

Deliverables

What the client received

Scenario and complexity definitionsWith characteristics.
Phase modelActivities and deliverables.
Effort and timeline rangesThree complexity bands.
One working sessionWith notes.

The terms

What an engagement like this costs

You buy hours in blocks and can change the expert at the end of any block, at no extra cost. Longer projects run in stages: pause after a block, pick up the next stage when you are ready.

Pricing in full →

Rate band: $65–$250 /hr; Senior specialists can be up to $500
Hour blocks: 1 · 2 · 5 · 10 · 20 · 50 · custom
This engagement: Solo Pod · ~30 hours · 2 weeks

Sizing an ETL implementation?

Describe what you need

For example: “We are replacing a legacy ETL tool with a cloud platform and need effort by complexity for the business case.”

We aim to come back with matched experts within 24 to 72 hours.