SQL DEVELOPER

Job Description: Oracle BI Publisher Developer

Position Type

• Work Type: Full-time

• Employment Type: Contract

Experience Required

• Minimum 1 year of hands-on experience in:

o Oracle Database: SQL development, performance tuning, data modelling

o Oracle BI Publisher: Report design, template customization, data source integration

Technical Skills

• Mandatory:

o Oracle SQL & PL/SQL

o BI Publisher report development and deployment

o XML and XSLT for template customization

• Preferred:

o Experience with Oracle E-Business Suite or Fusion Applications

o Familiarity with data visualization principles

o Basic understanding of performance metrics and report optimization

Responsibilities

• Design, develop, and maintain BI Publisher reports based on business requirements

• Write and optimize SQL queries for data extraction and transformation

• Collaborate with stakeholders to ensure report accuracy and usability

• Troubleshoot and resolve issues related to data and report performance

• Document technical specifications and maintain version control

1. As a part of ISA ERP development team Develop, test and implement scalable, maintainable, well documented, high-quality MVC / Web Application for Manufacturing or service industry.

2. The individual should have a good understanding of the Microsoft .NET Platform and MS SQL server and Stored procedures

3. Ensure adherence to standards of best engineering practice (code reviews, source code management, unit testing, etc.)

4. Help junior members in the team to get them up to speed and train them in coding practices.

Role & Responsibilities:

• Individuals are responsible for all traditional development activities analysis, design, coding, testing, and documentation.
• Add new features to existing Windows and Web-based applications in Visual Studio 2019. Interacting with the internal team.
• Transform business and design needs into innovative products.
• Drive all projects to completion within deadlines.
• Perform thorough testing to find issues ahead of time.
• Engineering software needs a more precise analysis & coding skillset 
• Enhance skillset by working with fortune 500 clients
• Interacting with the internal team. 

Qualifications:

• B.E in computer science or related fields.
• Hands-on development experience with web & database technologies (MS SQL).
• Excellent programming & communication skills Strong problem-solving, judgmental, and decision-making skills.
• Ability to work at the tactical and strategic levels of IT initiatives.
• Impressive hands-on experience in .Net technologies. Impressive hands-on experience and knowledge with C#, SQL, JSON, XML, Win Forms & MVC, Angular, JavaScript, jQuery, HTML/CSS.
• Self-Motivated, flexible & Innovative.

Design, develop and maintain web-based services and applications using .Net Core/ASP.Net, C#, REST Web API, MS SQL Server, Entity Framework, and Dapper.  Developing highly optimized cross-browser and responsive web applications using HTML5, and CSS.  Manage the full technical life-cycle of web applications during each development phase including functional & technical design, implementation, testing, deployment and maintenance.  Developing high standard Web Applications based on functional requirements, UI/UX requirements, business logic and Web APIs.  Designing database tables, views, stored procedures, and functions to store and retrieve data most efficiently from SQL database.  Writing bug-free code with the highest coding standard.  Developing high-performance, highly secure and highly scalable Web Application.  Perform unit testing, troubleshooting, debugging and code reviews for robustness, including edge cases, usability, and reliability of the software.  Manage source code check-in, checkout, and merging code.  Taking accountability and the ability to work under pressure

Hands-on experience o of using Angular with version 7 or later o in consuming complex nested API. o in using state management (e.g. NGRX, RXJS). o in using caching. o of using component library framework integration (e.g. Angular Material). o in integrating with REST web services from the application. Knowing JSON is a must. o with Git compatible source control and working with a CI/CD pipeline.  Experience on AWS services will be added advantage.  Good experience in Standard Project Development Life Cycle.  Experience on Devextreme tools will be added advantage.  Ability/ready to work on advanced technologies like Node JS is an added advantage.  Knowledge / Experience of agile development methodologies.  Very good logical skills and problem-solving ability.  Quick learner and a good team player.  Should be able to work independently and with the team.

Sr .Net Developer/ SQL Server (4 + Years)

We are a Business process Management Solutions & Services Company based out of Bangalore, looking for dynamic and self-motivated .Net/sql Server Developer, who can play a significant role in NeoLotex own flagship BPM Products.

Deliverables

•       Add new features to the different applications in the product suit

•       Troubleshoot and provide resolution to production issues. Reproduce, document and resolve product defects

•       Provide well-thought out and reliable direction, both in technical and non-technical terms to the team members

•       Take ownership of customer issues, including troubleshooting, identification of root cause and issue resolution

•       Create clear and concise Knowledge documents and ensure maintenance of the same

•       Understand requirement through discussions with Client/Business Team, or by studying / analyzing the Function Specification Document (FSD), and converting the requirements in to technical implementations using technical documentation and unit test cases

•       White box testing (unit test) manual and automated

•       Utilize established development tools, guidelines, and conventions including ASP.NET, ASP.NET Core, SQL Server, JavaScript, JQuery, React JS and .NET Core, Web API

•       Database design and development (Microsoft SQL Server). Analyze existing SQL queries for performance improvements

Core Competencies

•       A sense of ownership and pride in his/her performance and its impact on the company’s success

•       Understanding of Software Development Life Cycle

•       Technical Skills to work with C#,.NET, .NET Core (Windows and Linux),  ASP.NET Core MVC, ASP.NET Web Forms, Win Forms, Windows Services, Service Workers, WCF/Web API, JavaScript & JQuery, React JS, Stored Procedures, HTML, CSS, IIS

•       Should have sound knowledge of .NET and .NET Cores frameworks

•       Should have good experience with MS SQL Server

•       Job Scheduling in Windows, Linux and SQL Server

•       Ability to write APIs using WCF and .NET Core

•       Experience with micro services or service Oriented Architectures

•       Exposure to AWS or Azure deployment

•       Familiar with various design and architectural patterns

•       Experienced with writing clean, readable, and easily maintainable code

•       Good oral and written communication skills

•       Other required soft skills to work in a team

Qualification

•        Any bachelor degree

•        4+ years of Relevant experience

Other Details

•       5 days working – Monday to Friday

•       Office Time – 9 30am to 6 30pm

•       Work Mode – Work from office

•       Preferably looking for immediate joiner

• Experience in .Net Core, MVC framework, WebAPI
• Deep understanding of programming principles and OOPS concepts.
• Strong Coding Discipline
• Comprehensive knowledge on Good Practices, Coding guidelines, General Programming Paradigms
• Excellent verbal communication skills and good interpersonal skills.
• Good experience in Error handling & debugging techniques
• Strong Logical, analytical & problem solving skills
• Ability to build well maintained libraries & tools based on the business needs
• Experience in mentoring the teams and helping them
• Azure / AWS DevOps knowledge is desirable but not a must.

• Should have strong knowledge and hands-on experience in JDK 1.8+ 
•  Should have worked in Struts, Ajax, Spring MVC, Spring Boot and Angular 
• Should have strong expertise in SOA and Microservices • Experience in Insurance domain would be an added advantage
• The responsibilities of Java technical leads include working with developers to ensure quality network frameworks, mentoring junior level staff, and identifying issues that affect product delivery.
• Experience of Software Engineering Process and in Design J2EE Design Patterns.
• Code Review and Best practices, Unit Testing
• Team mentoring

• MUST HAVES:
1. Top  Mandatory Skills: 6+ Years in: JAVA / J2EE, Spring MVC ,Springboot, Microservices
2. Domain Experience:- BFSI (Minimum 2 yrs latest)
3. Joining time / Notice Period: Immediately

Position: Full Stack Developer

Location: Remote

Experience: 2-3 Years

.Net Core, Angular / AngularJS, PL/SQL is must

Skill Set:

• .Net Core, Angular JS - skills are a must
• Must have done WebAPI's.
• Implemented single Sign on - added advantage
• A bit of Pl/sql or Sql is an added advantage
• Must be aware of Agile Methodologies
• Must be aware of code versioning tool like GitHub/Bitbucket
• Exposure to tools like JIRA/Confluence is an added advantage
• Must be aware of Dependcy Injection pattern

• Provide development and maintenance services for .NET application.
• Develop and implement best practices for .NET programming.
• Review codes and provide recommendations for improvements.
• Identify the key problems and develop a solution within business and technical context.
• Design, develop, test, review and document .NET application programs.
• Evaluate user requests to determine budget, time, feasibility and compatibility of the new or modified program.
• Analyze technical architecture and provide recommendations.
• Coordinate with users to analyze and propose application solutions to meet business needs.
• Participate in all stages of the software development life cycle including coding, designing and documentation.
• Develop support processes to integrate .NET applications into in-house and third party applications.
• Prepare and maintain system-level, program-level and user-level documentations.
• Act as a technical lead for development and integration of .NET applications.