Developer

Job title: Developer

Location: Hartford, Connecticut

Duration: 10 Months

Description:
Key Responsibilities

Requirements Analysis & Documentation

• Collaborate with OEC stakeholders and technical teams to elicit, analyze, and document business and system requirements.
• 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