SQL Developer

Technical Project/Product Lead

We are seeking a Technical Project/Product Lead with 8-10 years of experience in Microservice.Net Technologies with at least 2-4 years of experience in technical project lead. As a Project Lead, you will be responsible for leading business and technology outcomes for assigned programs or projects.

Educational Qualification:

The ideal candidate should possess educational background in Engineering along with a proven track record of delivering successful projects.

Technology/Skills:

• Expertise in Microsoft.NET Technologies and MVC Architecture.

• Strong design experience including experience in architecture and design patterns.

• DevOps/ Cloud experience is an added advantage.

• Strong experience in integration architecture including API Gateway, Service Catalogs etc.

• Strong experience in integration design for secured and scalable API’s and Webservices.

• Excellent communication and interpersonal skills, with the ability to build strong relationships with stakeholders at all levels.

• Proven ability to lead cross-functional teams and deliver projects on time, within budget, and to the required quality standards.

Roles & Responsibilities:

• Lead and manage end-to-end technical project, ensuring successful planning, execution, and delivery within scope, budget, and timeline.

• Collaborate with cross-functional teams, including software developers, architects, quality assurance, and stakeholders to define project requirements, objectives, and deliverables.

• Provide technical guidance and expertise in Microsoft .NET, MS SQL, ASP.NET Core, and Azure to the project team, assisting with problem-solving, troubleshooting, and decision-making.

• Ensure adherence to software development best practices, coding standards, and quality assurance processes throughout the project lifecycle.

• Act as a liaison between technical and non-technical stakeholders, effectively communicating project updates, progress, and risks.

• Conduct regular project status meetings, providing comprehensive reports and updates to project sponsors and stakeholders.

• Stay up to date with industry trends, emerging technologies, and best practices in Microsoft .NET, MS SQL, ASP.NET Core, and Azure, and apply this knowledge to project execution.

Detailed JD: 

Responsibilities:

- Interface with product owners and software architects to review and finalize requirements

- Participate in the full SDLC including analysis, design, development, testing, deployment, and support

of new features and applications

- Actively lead and participate in agile ceremonies (Standups, Refinements, Retrospectives, Planning,

and Requirement discussions)

- Communicate effectively, clearly, and thoroughly with the Scrum Team and Stakeholders

- Provide innovative solutions to complex problems

- Design, develop and modify software applications/systems according to specifications

- Develop technical documentation including services, object, and data model

- Create high quality code and perform code reviews

- Create unit and integration tests to ensure the code quality and functionality

- Proactively learn and share knowledge of technology and compare advantages and disadvantages of

alternative solutions/technologies

- Identify areas needing process improvements and see them through to resolution

- Support and coach other Developers, provide technical guidance

- Help onboard new team members

Tech Stack:

C#, .NET Core, XUnit, Entity Framework Core, MS SQL Server, PostgreSQL, Git, JIRA, Web API

Microsoft Azure Data Integration Engineer

Job Description: 

Microsoft Azure Data Integration Developer who will design and build cutting-edge user experiences for our client’s consumer-facing desktop application. The Senior Software Developer will work closely with product owners, UX designers, front-end, and back-end developers to help build the next-generation platform. 

Key Skills:

• 3+ years of experience in an enterprise or consumer software development environment using C# and designing and supporting Azure environments
• Expert level programming skills in creating MVC and Microservices architecture
• Experience with modern frameworks and design patterns like .Net core
• Strong knowledge of C# language
• Hands-on experience using the Azure administration portal and iPaaS
• Demonstrable experience deploying enterprise workloads to Azure
• Hands-on experience in Azure function apps, app service, logic apps and storage, Azure Key vault integration, and Azure Sql database.
• Solid understanding of object-oriented programming.
• Experience developing user interfaces and customizing UI controls/components

·      Microsoft Azure Certification, Business Continuity, or Disaster Recovery planning experience is a plus

Responsibilities:

• Architect, design & build a modern web application for consumers
• Explore configuring hybrid connectivity between on-premises environments and Azure, and how to monitor network performance to comply with service-level agreements.
• Collaborate with UI/UX teams to deliver high-performing and easy-to-use applications
• Participate in code reviews with staff as necessary to ensure a high-quality, performant product
• Develop a deep understanding of client goals and objectives, and articulate how your solutions address their needs
• Unit testing/test-driven development
• Integration testing
• Deploying Azure VMs (Windows Server) in a highly available environment
• Regularly reviewing existing systems and making recommendations for improvements.
• Maintenance
• Post-deployment production support and troubleshooting

Technical Expertise and Familiarity:

• Cloud Technologies: Azure, iPaaS
• Microsoft: .NET Core, ASP.NET, MVC, C#
• Frameworks/Technologies: MVC, Microservices, Web Services, REST API, Java Script, JQuery, CSS, Testing Frameworks
• IDEs: Visual Studio, VS Code
• Databases: MS SQL Server, Azure SQL
• Familiarity with Agile software development methodologies.
• Advanced knowledge of using Git source control system.
• Azure, AWS, and GCP certifications preferred.

• Manage different versions of complicate code and distribute them to different teams in the organization utilizing TFS.
• Develop an ASP.Net application to input and manage a production schedule, production statistical analysis and trend reporting.
• Create routines for importing data utilizing XML, CSV and comma delimitate files.
• Filter and cleanse OLTP data with complex store procedures and SSIS packages in the staging area.
• Develop a dimensional database and OLAP cube using SSAS for analysis, maintenance and good customer service.
• Involve in development and implementation of SSIS, SSRS and SSAS application solutions for various business units across the organization.
• Extract the data from XML and load it to dimensional model.
• Maintain SQL scripts, indexes, complex queries for data analysis and extraction.
• Create advanced reports like dashboard and scoreboard using SharePoint and power pivot for better presentation of data.
• Create cubes in SSAS reports which require complex calculations such as calculation of the premium for a particular policy.
• Create SharePoint sub sites, lists, libraries, folders and apply site permissions according to the given requirement.
• Work with business analysts, subject matter experts, and other team members to determine data extraction and transformation requirements.
• Develop T-SQL functions and store procedures to support complex business requirements.
• Create and configure an OLTP replication database for disaster recovery purpose.
• Designed/Implemented/Maintain OLAP servers and processes to replicate production data to the server.

• Experience in either of these Relational DB’s MS SQL Server / PostgreSQL / AWS Aurora DB / MySQL / Oracle / NOSQL DBs (MongoDB / DynamoDB / DocumentDB) in an application development environment and eagerness to switch DB.
• Design database tables, views, indexes
• Write functions and procedures for Middle Tier Development Team
• Work with any front-end developers in completing the database modules end to end (hands-on experience in parsing of JSON & XML in Stored Procedures would be an added advantage).
• Query Optimization for performance improvement
• Design & develop SSIS Packages or any other Transformation tools for ETL

• Banking / Insurance / Retail domain would be a plus.
• Interaction with a client a plus

• Knowledge in a Cloud Platform (AWS / Azure)
• Knowledge on version control system (SVN / Git)
• Exposure to Quality and Process Management
• Knowledge in Agile Methodology

• Team building (attitude to train, work along, mentor juniors)
• Communication skills (all kinds)
• Quality consciousness
• Analytical acumen to all business requirement
• Think out-of-box for business solution