Programmer Analyst (106)

Delan Associates, Inc; New York (NY); On-site; USD 120,000 - 160,000; Full time

Job summary

Delan Associates, Inc. seeks a seasoned Full Stack Developer to design and implement enterprise web applications. You will work on data-intensive solutions, build SPA front-ends with AngularJS, and develop server-side services in .NET Core/C#.

Responsibilities include optimizing data access, creating complex SQL queries, integrating REST APIs, and collaborating with QA in an Agile environment.

Qualifications

• Full stack development experience across SDLC.
• Proficiency with AngularJS, .NET Core/C#, and SQL databases.
• Strong SQL, data modeling, and REST API design.

Skills

Writing application software

Data analysis

Data access

Data structures

Databases design

Programming

Testing and implementation

Technical documentation

QA walkthrough

Agile methodologies

Enterprise software architecture

3-tier architecture

.NET/VB.NET/ASP.NET/C#

JavaScript

XML/Web Services/WCF

Single Page Applications (SPA)

AngularJS

REST API

HTML/CSS/JSON

jQuery/AJAX

SQL Server/Oracle

TOAD/PL-SQL Developer

NHibernate/ORM

LINQ/Entity Framework

SSIS

Tools

TOAD

PL/SQL Developer

Oracle

SQL Server

AngularJS

NHibernate

Kendo UI

Telerik UI

REST API

AWS

CodePipeline/CodeCommit

CodeBuild

CloudFormation

Entity Framework

Job description

Required Skills

• Writing application software, data analysis, data access
• Data structures, data manipulation, databases, design, programming, testing and implementation
• Technical and user documentation, software conversions. Experience in creating Technical Specification Documents, State Diagrams and conducting technical walkthrough with QA team.
• Exposure to environments include but are not limited to mainframe, mid-range, personal computers, laptops
• Lead in the design of program specifications and the implementation of software solutions. Extensive experience working under Agile methodologies environment, and experience with enterprise-level software architecture
• Designing 3 tiered applications
• .Net Framework including: VB.Net, ASP.NET, Experience with ADO.NET, VB6, Java Script, XML, WEB Service, VBScript, C#, Object oriented concepts and technologies
• Oracle database Backend processing and extensive experience in relational database development, for creating complex database queries, Constraints, Indexes, Views, Packages, Stored Procedures, Triggers, Cursors and Functions using TOAD, PL/SQL Developer
• Developing Web Applications using HTML, CSS, JavaScript, jQuery, AJAX, JSON. Expert knowledge using LINQ, and Entity Framework
• Knowledge of SOA trends, SOA standards including web services, XML, XSLT, SOAP, WSDLs, and WCF
• Proficient at developing Single Page Application (SPA) with AngularJS controllers, directives, factories, services, routing, DOM manipulation using JavaScript, JQuery, AngularJS, and REST API
• Developing SSIS packages for extracting, cleaning, transforming, and loading data from different sources like XML, Excel, Text files and databases (Oracle, SQL server)
• Professional experience as Full Stack (Database/.Net) developer in all the phases of Software Development Life Cycle (SDLC) including User Interaction, Design, Development, Implementation, Testing, Deployment, Customer Support, Maintenance and Enhancements of applications

Desired Skills

• Designed and developed a single page application using Angular 18, utilizing reusable components, modules, directives, with NgRx for state management, RxJS Observables for asynchronous data handling, and both Reactive and Template-driven forms for user input management
• Designed and developed cloud based solution on AWS, including REST API using AWS API Gateway, AWS RDS, and AWS Cognito; built serverless components with .Net Core/C# for Glacier migration; managed s3 Buckets and bucket policies for cloud storage and backup; created CI/CD pipeline using CodePipeline, CodeCommit, CodeBuild to deploy Lambda application with CloudFormation templates
• Designed and developed Microservices architecture using .Net Core, C# and Rest APIs, building Independent, loosely coupled, and scalable services across different functional areas of the application
• Designed and generated reports using SQL Server Reporting services (SSRS), including cross-tab, conditional, drill-down, drill-through, and parameterized reports
• Implemented NHibernate ORM for data access and persistence, mapping domain objects to relational database tables, managing sessions, transactions, and executing HQL and Criteria queries for efficient database operations
• Designed and developed interactive UI components using Telerik UI and Kendo Grid, implementing feature such as sorting, filtering, paging, inline editing and data binding to backend API for efficient data display and manipulation