Skip to content

DEV Community

Fintech Data Correctness Labs Series' Articles

Back to Anton Gameza's Series

Cover image for Free fintech data engineering lab: find a missing dollar with Python + SQLite

Oct 21

Free fintech data engineering lab: find a missing dollar with Python + SQLite

#python #database #tutorial #fintech

3 min read

Cover image for Free SQL practice: why SUM(DISTINCT) doesn't fix inflated payment totals

Oct 21

Free SQL practice: why SUM(DISTINCT) doesn't fix inflated payment totals

#sql #database #tutorial #opensource

5 min read

Oct 22

Replaying payment events: test the second run, not just the first

#dataengineering

2 min read

Oct 22

Your SQLite backup restored. Does its checkpoint still match the data?

#python #dataengineering #sqlite

4 min read

Oct 22

Parsing money in Python: reject bad precision before choosing how to round

#python #dataengineering #testing

4 min read

Oct 22

An old event timestamp can still leak future information into training data

#dataengineering #sql #machinelearning #python

4 min read

Oct 22

A deleted CDC row still needs a version: a Python counterexample

#dataengineering #python #testing

4 min read

Oct 22

BETWEEN can double-count a fact at an SCD2 version boundary

#sql #dataengineering #sqlite #testing

4 min read

Oct 22

A backfill can match row counts and totals while still being wrong

#dataengineering #python #testing

4 min read