Developer - Web Based app / SQL Server

Role Details:
- Role: Overseas Contractor - Developer - Web Based app / SQL Server.
- Experience: 7-10 years.
- Location: Berkeley Heights, New Jersey.
- Contract Type: Long-term contract.
- Focus: Product analyst role with mandatory Frontier reconciliation product experience.

Role Summary:
- Domain: Financial reconciliation systems.
- 7-10 years of professional software development experience.
- Minimum 5 years of experience developing enterprise web applications.
- Strong experience working on financial systems reconciliation platforms, accounting applications, banking systems, or transaction processing solutions.
- Experience supporting applications in production environments.

Mandatory Skills:
- Frontier.
- ASP.NET (Webforms).
- ASP.NET MVC.
- C#.
- MS SQL Server.

Good to Have Skills:
- .Net Core.
- .Net Framework.
- Bootstrap/CSS/CSS3.
- HTML/HTML5.
- T-SQL.

Additional Requirements:
- Experience with web-based applications and SQL Server including scripting skills and data manipulation.
- Experience with disputes/chargebacks.
- Financial reconciliation experience.
- 3+ years of Frontier experience (or equivalent enterprise reconciliation software experience).
- SQL Server and PowerShell experience.

Application Development:
- Design, develop, enhance, and maintain web-based applications supporting financial reconciliation processes.
- Develop robust, scalable, and secure solutions using Microsoft technology stack.
- Participate in full Software Development Life Cycle (SDLC) activities including requirements analysis, design, coding, testing, deployment, and support.
- Troubleshoot and resolve application defects and production issues.

Database Development:
- Design and develop SQL Server databases, tables, views, stored procedures, functions, and triggers.
- Optimize complex SQL queries and improve application database performance.
- Implement data validation, reconciliation logic, and exception handling processes.
- Support database tuning, maintenance, and performance monitoring.

Financial Reconciliation Solutions:
- Develop reconciliation workflows for financial transactions across multiple source systems.
- Build automated matching and exception management processes.
- Work closely with finance operations and business stakeholders to understand reconciliation requirements.
- Develop reports, dashboards, and audit-ready data extracts.

Database Expertise:
- Data modeling and database design.
- Performance tuning and indexing strategies.
- Handling large volume transactional datasets.
- Data migration and ETL processes.

Technical Proficiency:
- C#.
- ASP.NET MVC.
- ASP.NET Core.
- .NET Framework.
- .NET Core.
- REST APIs.
- SQL Server 2016, 2019, 2022.
- T-SQL.
- Stored Procedures.
- Query Optimization.
- Entity Framework.
- JavaScript.
- HTML5.
- CSS3.

Additional Experience:
- Azure DevOps.
- Git.
- CI/CD pipelines.
- IIS.
- SSIS.
- SSRS.
- Power BI (preferred).

Location: Berkeley Heights, New Jersey, United States

Skills required for this job:

• .NET Core
• .NET Framework
• ASP.NET
• ASP.NET MVC
• Accounts reconciliation
• C#
• Chargebacks
• Microsoft Power BI
• Microsoft SQL Server
• PowerShell
• Transact-SQL
• Web application development