SQL Developer | Ex-TCS Mandatory | W2 Only | Remote |
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: [email protected]
Our training portal registration:
http://xlysi.catsone.com/careers/index.php?m=portal&a=apply&jobOrderID=345179&portalID=2106
Apply tot his job
Apply To this Job
• 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: [email protected]
Our training portal registration:
http://xlysi.catsone.com/careers/index.php?m=portal&a=apply&jobOrderID=345179&portalID=2106
Apply tot his job
Apply To this Job