SQL Developer | Ex-TCS Mandatory | W2 Only | Remote |
About The Position
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 HR Xlysi LLC, Expert Portal Solutions 251 Milwaukee Ave, Buffalo grove, IL 60089 Web : http://www.xlysi.com E-mail: hr@xlysi.com Our training portal registration: http://xlysi.catsone.com/careers/index.php?m=portal&a=apply&jobOrderID=345179&portalID=2106
Requirements
- Ex-TCS Mandatory
- W2 Only
Responsibilities
- 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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Career Level
Mid Level
Education Level
No Education Listed
