Developer

Title: Developer Location: 450 Columbus Blvd Hartford, Connecticut 06103 – Hybrid (Candidate Must Be Local) Hybrid work schedule. On site One Day a Week. Duration: 10+ months (Candidate Must Be Local) - USC/GC Position Summary Key Responsibilities Requirements Analysis & Documentation • Translate business needs into user stories and acceptance criteria, maintaining a refined Azure DevOps product backlog. • Document current and future state workflows, integration points, and data dependencies. • Create and validate data mapping documents between legacy and modern systems. • Develop interface mapping documentation to align legacy screens and functions with modernized application components. • Define and maintain functional, non-functional, and reporting requirements, ensuring end-to-end traceability. Software Development & Technical Implementation · Design, develop, and refactor components using ASP.NET MVC, Entity Framework, and Azure App Service. · Contribute to CI/CD pipeline setup and optimization using Azure DevOps and Azure Git Repositories. · Work with Azure SQL databases to design schema, implement stored procedures, and optimize performance. · Collaborate with data engineers on SSIS-based ETL processes and data migration activities. · Participate in code reviews, ensuring adherence to best practices for performance, maintainability, and security. Data Migration Validation & Testing · Develop and maintain omnipotent (comprehensive, reusable) data validation scripts to verify migrated data after each migration cycle in test environments. · Validate record counts, referential integrity, field-level transformations, and business rule consistency across environments. · Identify and analyze data discrepancies, collaborating with developers and data teams to resolve issues. · Maintain documentation for data validation procedures, testing outcomes, and transformation logic. · Support system, integration, and user acceptance testing (UAT) by creating and executing test cases. · Log and manage defects and testing results using Azure DevOps. Agile/Scrum Collaboration • Serve as an active member of a cross-functional, self-managed Scrum team responsible for delivering working software increments. • Participate in all Scrum ceremonies—including daily stand-ups, sprint planning, reviews, and retrospectives. • Work closely with the Product Owner to refine and prioritize backlog items and define sprint goals. • Contribute to a culture of continuous improvement, team collaboration, and shared accountability. Technical Skills & Qualifications Required: · Proficiency in ASP.NET MVC and Entity Framework for web application development. · Strong understanding of Azure platform services, including Azure SQL, App Service, Azure DevOps, CI/CD pipelines, and Azure Git Repositories. · Expertise in developing and executing automated data validation/testing scripts (SQL or other scripting languages). · Strong grasp of relational databases, data modeling, and data mapping techniques. · Experience documenting and validating legacy-to-modern data and interface mappings. · Proficiency in Azure DevOps for managing work items, test cases, and defect tracking. · Solid understanding of Agile/Scrum principles and practices. · Proficiency in Microsoft Office Suite, including Excel (for data analysis) and Visio (for process mapping). Preferred: · Experience with legacy system modernization or public-sector transformation projects. · Knowledge of security, access control, and user role management in enterprise applications. · Familiarity with API documentation, system integration, and report validation. Key Deliverables • User Stories with Acceptance Criteria • Functional & Non-Functional Requirements • Current/Future State Process Maps • Legacy-to-Modern Data Mapping Documents • Legacy-to-Modern Interface Mapping Documents • Developed and Tested .NET Components • Data Validation and Migration Testing Scripts • Test Plans, Test Cases, and Test Results • Traceability Matrix • Deployment Artifacts via Azure DevOps CI/CD • Status Reports and Issue Logs