Data Conversion Developer (SQL Validation & Reconciliation)
Data Conversion Developer (SQL Validation & Reconciliation) Albany, NY area (Hybrid) · Contract · Immediate start
About the role:
Our client is running a large public sector systems modernization in New York’s Capital Region. They’re moving legacy data onto a new platform, and every conversion run has to be checked before go-live. You’ll build and own the SQL validation layer. You’ll turn source-to-target mappings into reusable validation scripts, reconcile every run and report clearly on what passed, what failed and why.
What you’ll do:
- Develop reusable SQL validation scripts from source-to-target mappings and business rulesReconcile source, converted and rejected record counts for every conversion run
- Validate key mapping, required fields, uniqueness, data types, formats, code translations and null/default handling
- Test referential integrity and other agreed business rulesReconcile critical aggregates such as balances, quantities and counts by category
- Tune long-running validation queries against large conversion data sets
- Re-run validations after fixes and report results by conversion run
- Pinpoint root cause on failed records and work with onshore and offshore Java developers to get them fixed
- Save scripts, results and reports in the project repository
- What you bring 4+ years writing production SQL on data conversion, migration, ETL or data quality projects
- Strong SQL: joins, aggregations, subqueries/CTEs, window functions and query tuning
- Experience turning mapping docs, transformation specs and data models into validation logic
- Proven record and aggregate reconciliation work
- Experience with Oracle, SQL Server, Db2, PostgreSQL or a similar database
- Clear communication with technical, business and offshore teams
- Able to work hybrid in the Albany area
Nice to have:
- Data conversion experience on a state or public sector system (NYS a plus)
- Informatica, SSIS or similar ETL tools
- Legacy or mainframe source data (COBOL, Db2, VSAM)
- Jira, ALM or similar defect tracking
This role is managed exclusively by Stealth Talent Solutions, a certified minority-owned talent firm.