MS SQL Server Job Vacancies in Pune

Key Responsibilities: Implement and test the AutoRek financial management solution. Develop configuration and code as per requirements. Perform unit and end-to-end testing following the testing strategy. Participate in peer reviews and support defect investigations during acceptance testing. Develop and test remediation releases to address defects and change requests.

Continuous Integration & Deployment (CI/CD):Tools: Jenkins, TeamCity, GitLab Configuration Management:Tool: ChefCloud Platform:Tool: OpenShift Monitoring and Logging:Tools: ELK Stack, Prometheus, Grafana, Datadog, BeatsCoding & Scripting:Languages: Java (for microservices), Python, Linux commandsDatabase Management:Databases: MongoDB, Oracle DB, MS SQL Server

Job description for your reference: Extensive experience with the .NET framework and other technologies: C#, Web API, and Microsoft Azure. Strong experience with the following technologies: C#, .Net Core, ASP.NET MVC, WCF, ASP.NET ,Web API, LINQ, Entity Framework, Unity (DI), JQuery, SQL, HTML and CSS.2+ years experience developing web applications on the .Net framework (C#, MVC and ASP.NET as well as CSS, HTML, JavaScript, JQuery, and MS-SQL Server).Previous experience with Service Oriented Architecture (SOA) - SOAP, WebAPI and REST web services.Minimum 1 year of experience working with GIT as source control and should understand the concepts around pull requests, branches, repositories. (GitHub, Azure Repositories). Experience working with GitHub Actions/Bitbucket, Azure DevOps, or relevant Technologies.Desired Skills:Models with validation attributes, custom validations Asynchronous programming Error handling and logging.Server-side UI table operations - sorting, searching, paging, page sizing.Entity framework with database first approach, edmx designer.Tables, views, stored procedures, functions.Optimizations - keys, indexes, partitions.Working with XML/JSON data HTML/CSS Javascript/jQuery CSS 3.0/Less/SCSS Bootstrap Responsive design.

Skills and Requirements: 1. Bachelors degree in Computer Science or Masters degree in Computer Applications.2. Microsoft Certified Solution Developer / Microsoft Certified Professional Developer will be an added advantage.3. Must have entire experience in .NET development (ASP.NET, .NET Core).4. Hands-on experience in Web Services, HTTP, IIS, REST. 5. Hands on experience in MS SQL server, MySQL and NoSQL Databases (Mongo DB).6. Good knowledge of software architecture design. 7. Experience implementing automated testing platforms and unit tests.8. Familiarity with Design patterns. 9. Proficient understanding of code versioning tools such as SVN & Github. 10. Familiarity with Azure hosting and services will be an added advantage.11. Ability to learn new technologies quickly and remain up to date with industry trends. 12..Strong problem-solving and debugging skills. 13.Very strong written and verbal communication skills for interaction with client, stake holder(s), team member(s).

Job Title - ASP.NET Full Stack Web DeveloperJob Location - Work From Anywhere / Work from Home / Any Regus centre comfortable for the candidate / Company's OfficesNo. of Vacancies - 5Technical Proficiency: For Frontend Web DevelopmentHTML5CSS3JavaScriptjQueryjQuery UIAngularJSFor Backend Web DevelopmentASP.NET MVC (VB/C#)ASP.NET Core (Optional)Restful Web APIsMS-SQL ServerExperience; 2+ yearsSalary: 45,000 INR to 60,000 INR per month (or increment of 20% in last salary -- whatever is more)Job Type: Full TimeJob Timings: Monday to Friday (8:30 AM to 6:00 PM with 1 hour lunch break) Saturday (8:30 to 12:45 PM with no lunch break)Employment Type: 1 year Contract (renewable every year)Eligibility;(1) Std. 10th Passed with 70% or above(2) Std. 12th or Diploma Passed with 60% or aboveAny one of the (3) and (4):(3) B.E. or B.Tech. in Computer Engineering / Computer Science / Information Technology aggregate all semesters 60% or above(4) MCA or M.Sc. IT aggregate all semester 60% or aboveRequired Skills: Good command over spoken and written EnglishGood Communication skills (writing)Good in MathematicsRound Details;(1) HR Interview (for walked-in candidates) OR Group Discussion (for candidates appearing in Placement Drives at their institute)(2) Aptitude Test (Arithmetic Aptitude, Data Interpretation, Logical Reasoning, Verbal Reasoning, Nonverbal Reasoning)(3) Technical Interview(4) Practical Test(5) Final InterviewNotes:For any questions/query, please write us

Job description: Minimum 5-7 years of hands-on work experience in BI and Data warehouse projects. At least 4 years of working with Microsoft database platforms MSSQL Server 2012/14/16. Very Good knowledge of T-SQL for writing performant and optimized SQL query. Hands on experience on SQL Server Integration Services(SSIS) - Datawarehouse ETLimplementation. Knowledge of SSIS ETL best practices , Error Handling ,Logging , Re- Tries , Notifications , TaskScheduling. Strong knowledge of various data warehousing methodologies and data modeling concepts. Experience of ETL load design patterns, Incremental load, Full load , Merge etc. Development experience using C# .NET or VB.Net. Experience in Analysis and Reporting solutions using dashboard visualization tools like: Tableau orPower BI etc. is Advantage. Hands-on experience of SDLC processes for BI projects. Experiences of writing documentation functional requirements , design documents, Test Cases,operation manual etc. Self-motivated , excellent troubleshooting and communication skills , team player.

3-5 years of good ETL/SQL experience. Strong in Data Warehousing concepts (SSIS). Responsible for designing, developing, testing, deploying and troubleshooting SSIS packages that implement complex ETL processes Translate business requirements into technical designs to map and load data from different sources to data warehouses Ensure quality and accuracy of the data Should have knowledge of SQL queries