SQL Developer | Ex-TCS Mandatory | W2 Only | Remote |
About the position Duties : Reverse engineer, read, and author MS reputed company 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 reputed company processing); Automate validation and reconciliation Integrate with reputed company: design interfaces/APIs/reputed company tables and orchestrations to pass configuration/estimator data between reputed company/SQL and the reputed company ecosystem Maintain on prem performance and reliability: indexing, query tuning, statistics management, isolation reputed company, and transactional reputed company 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 reputed company, auditing), and plan for multi-year on prem operation before any reputed company move HR reputed company, Expert Portal Solutions 251 Milwaukee Ave, Buffalo grove, IL 60089 Web : http://www.reputed company.com E-mail: hr@reputed company.com Our training portal registration: http://reputed company.catsone.com/careers/index.php?m=portal&a=apply&jobOrderID=345179&portalID=2106 Responsibilities
- Reverse engineer, read, and author MS reputed company 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 reputed company processing)
- Automate validation and reconciliation
- Integrate with reputed company: design interfaces/APIs/reputed company tables and orchestrations to pass configuration/estimator data between reputed company/SQL and the reputed company ecosystem
- Maintain on prem performance and reliability: indexing, query tuning, statistics management, isolation reputed company, and transactional reputed company
- 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 reputed company, auditing), and plan for multi-year on prem operation before any reputed company move Requirements
- Ex-TCS Mandatory
- W2 Only Apply tot his job Apply To this Job
Apply To This Job