SQL Developer | Ex-TCS Mandatory | W2 Only | Remote |

Chicago, IL - USA

Monthly Salary: Not Disclosed

Posted on: 2 days ago

Vacancies: 1 Vacancy

Job Summary

Duties:

Reverse engineer read and author MS Access 2003/VBA code; Untangle 100k lines of legacy logic to document workflows and stabilize critical functions
Design and implement SQL Server schemas (approx. 500 fields with 100 Q and A fields flowing into system) to support modernized processing
Build robust ETL/data ingestion pipelines (e.g. parsing output files and loading into SQL DB for downstream processing); Automate validation and reconciliation
Integrate with Infor: design interfaces/APIs/bridge tables and orchestrations to pass configuration/estimator data between Access/SQL and the Infor ecosystem
Maintain on prem performance and reliability: indexing query tuning statistics management isolation levels and transactional integrity
Establish coding standards version control and technical documentation for legacy and modern components; Implement unit/integration test harnesses
Partner with business (estimators dealers) to map legacy rules to modern data structures; Convert tribal knowledge into testable specifications
Prepare for the S4 migration (start-to-finish planning) by isolating dependencies defining cutover strategies and drafting rollback/safety nets
Drive secure handling of ERP data (authentication role-based access auditing) and plan for multi-year on prem operation before any cloud move

Xlysi LLC Expert Portal Solutions
251 Milwaukee Ave Buffalo grove IL 60089
Web :
E-mail:

Our training portal registration:

Experience:

Duties:Reverse engineer read and author MS Access 2003/VBA code; Untangle 100k lines of legacy logic to document workflows and stabilize critical functionsDesign and implement SQL Server schemas (approx. 500 fields with 100 Q and A fields flowing into system) to support modernized processingBuild ro...