Remote - .Net/Sr Software Developer - Hybrid Onsite - Chicago, IL

Title: Sr Software Developer

Location:  Chicago, IL

Duration:  2-3 years

• Tech stack is C#, SQL Server, T-SQL, LINQ, SSIS, Angular (a plus), WebAPI, Microservices, WCF, Web Services.
• Involve in the phases of software Life Cycle Development.
• Analyze, design, develop, implement and test applications.
• Design and develop user interfaces of application modules.
• Develop build scripts and deploy the application.
• Participate in code integration and system testing. Create unit test cases and test the application.
• Uses the Agile/ Scrum model as part of the daily and sprint work routine, updating, user stories, tasks and Defects statues in Rally and Participates in team huddles to update the code development, deployment, and test automation status of the application.
• Participate in requirements discussion with business to provide inputs on feasibility of implementation based on application architecture.
• Responsible for requirement gathering, development/ enhancement of application framework
• Design databases, tables and Indexes.
• Create many stored procedures with input and output parameters to be utilized by micro services.
• Develop SQL Queries to fetch complex data from different tables in remote databases using joins, and database links.
• Create Custom SSIS Packages using C# in Script task to handle issues related to excel and flat files and to send custom emails to users.
• Implement data validation rules in SSIS Packages. Deployed individual packages created environmental variables and scheduled jobs. Created packages in SSIS with error handling.
• Utilize business intelligence reports daily, hourly and on-demand basis by using the Data Gateways as necessary.
• Design complex data intensive reports and visualizations utilizing various graph features such as gauge, funnel, line for better business analysis.
• Aggregate Functions, Filter Functions, Time & Date Functions and Logical Functions in Data Analysis Expressions (DAX) for various fact calculations and efficient data visualization.
• Host and consume RESTful Web services using API .
• Develop Micro services using RESTful services to provide all the CRUD capabilities.
• Develop Restful Web Services for applications to allow external applications to access data and also to consume external services.
• Test and debug program units in conjunction with other units and/or systems.
• Test SQL databases and perform bug fixes.
• Develop User Interface (UI) and Application Program Interface (API) automated tests that adhere to the coding standards by frequently analyzing the repository with Sonar Lint and SonarQube servers to determine the quality gate.
• Triages application defects for all that impact test case automation execution and delivery, and work on the Critical Production Issues on Priority basis.
• Configure fiddler for auto-generated documentation for all REST API calls.
• Document web application test results for dynamic test elements, functional tests, and document object model (DOM)