
KEY RESPONSIBILITIES
· Develop high-quality database solutions.
· Use T-SQL to develop and implement procedures and functions.
· Review and interpret ongoing business report requirements.
· Research required data.
· Build appropriate and useful reporting deliverables.
· Analyze existing SQL queries for performance improvements.
· Suggest new queries.
· Develop procedures and scripts for data migration.
· Provide timely scheduled management reporting.
· Investigate exceptions with regard to asset movements.
MUST-HAVES FOR THIS GIG
T-SQL, Stored Procedure, Functions, Triggers, XML Operations, JSON support on SQL 2016 and above SSIS, SSRS, CTE, EAV Data structure, Integration with NoSQL(MongoDB), SQL Server Indexes, Bulk Insert, BCP, CMD Shell ,Memory Optimization, Performance Tunning, Query Optimization, Database Designing, Table Joins, SQL Server Job agent
Backup and Maintenance plan ,Data Migration, Good Communication
NICE-TO-HAVES FOR THIS GIG:
- Working knowledge of mobile development activity.
- Working knowledge of web hosting solution on IIS7.
Experience working with an offshore –onsite development process

Similar jobs

Net Developer with 4-7 years of experience with experience with :
- Full development lifecycle with ASP.NET, C#.NET, VB.NET, MS SQL,
- Proficiency with Oracle SQL, PL/SQL and Stored Procedure
- API Development

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.


About Merchandise Operation (Merch Ops): Merchandise Operations (Merch Ops) is a merchandise management system, it is positioned as a host system in the retail solutions, it has ability to maintain the Master/Foundation data, create and manage Purchase Orders, create, and manage Prices & Promotions, perform Replenishment, effective inventory control and financial management. Merc Ops provides Business users with consistent, accurate, and timely data across an enterprise by allowing them to get the:
Right Goods in the...
• Right Silhouettes, Sizes and Colors; at the...
• Right Price; at the...
• Right Location; for the...
• Right Consumer; at the...
• Right Time; at the...
• Right Quantity.
About Team:
• Proven, passionate bunch of disruptors providing solutions that solve real-time supply chain problems.
• Well mixed experienced team with young members and experienced in product, domain, and Industry knowledge.
• Gained Expertise in designing and deploying massively scalable cloud native SaaS products
• The team currently comprises of associates across the globe and is expected to grow rapidly.
Our current technical environment:
• Software: React JS, Node JS, Oracle PL/SQL, GIT, Rest API. Java script.
• Application Architecture: Scalable three tier web application.
• Cloud Architecture: Private cloud, MS Azure (ARM templates, AKS, HD insight, Application gateway, Virtue Networks, Event Hub, Azure AD) • Frameworks/Others: Tomcat Apache, RDBMS, Jenkins, Nginx, Oracle Type ORM, Express.
What you'll be doing:
• As a Staff Engineer you will be responsible for the design of the features in the product roadmap
• Creating and encouraging good software development practices engineering-wide, driving strategic technical improvements, and mentoring other engineers.
• You will write code as we expect our technical leadership to be in the trenches alongside junior engineers, understanding root causes and leading by example
• You will mentor engineers
• You will own relationships with other engineering teams and collaborate with other functions within Blue Yonder
• Drive architecture and designs to become simpler, more robust, and more efficient.
• Lead designs discussion and come up with robust and more efficient designs to achieve features in product roadmap
• Take complete responsibility of the features developed right from coding till deployments
• Introduce new technology and tools for the betterment of the product
• Guides fellow engineers to look beyond the surface and fix the root causes rather than symptoms.
What we are looking for:
• Bachelor’s degree (B.E/B.Tech/M.Tech Computer science or related specialization) and minimum 7 to 10 years of experience in Software development, has been an Architect, within the last 1-2 years minimum. • Strong programming experience and background in Node JS and React JS.
• Hands-on development skills along with architecture/design experience.
• Hands-on experience on designing, building deploying and maintenance of enterprise cloud solutions.
• Demonstrable experience, thorough knowledge, and interests in Cloud native architecture, Distributed micro-services, Multi-tenant SaaS solution and Cloud Scalability, performance, and High availability
• Experience with API management platforms & providing / consuming RESTful APIs
• Experience with varied tools such as REST, Hibernate, RDBMS, Docker, Kubernetes, Kafka, React.
• Hands-on development experience on Oracle PL/SQL.
• Experience with DevOps and infrastructure automation.

Responsibilities
• Participate in requirements analysis
• Collaborate with internal teams to produce software design and architecture
• Write clean, scalable code using .NET programming languages
• Test and deploy applications and systems
• Revise, update, refactor and debug code Requirements
• At least 5 years of experience with .NET
• Experience with ASP.NET
• MS SQL knowledge
• JavaScript experience
Nice to have
• .NET Core experience
• Entity Framework Core knowledge
• Experience with Angular • Experience with AWS (or Azure, GCP)
• Knowldege of CI/CD (GitLab, TeamCity, TFS Release)

- 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.

2. Maintain and customise existing android and iOS apps
3. Develop new products


Skill set: ASP.Net, Web, MySQL, C+, HTML, ASP.Net Angular(good to have),
Job Description as mentioned below: ·
MS SQL; Database design,
Stored Procedure, Functions,
Views, triggers, and advanced queries ·
C# version 4 or higher. ·
Visual Studio 2013 or later. ·
ASP.NET web forms knowledge ·
Advanced JQuery/JavaScript ·
Ability to understand the existing applications and work on enhancements · Ability to understand requirements quickly · Documentation skills , Requirement Analysis ·
Good Communication skills


The Position Summary
In this role, you will work with Huron and client team members throughout the entire implementation lifecycle, including planning, configuration, design, build, testing, training, change management, go-live, and post-production support. The Consulting Associate will be responsible for all aspects of Oracle EPM Cloud system implementation including requirement gathering, application design, application configuration, and implementation.
Must have skill: Require
Java: Core Java, Spring Framework, RESTful API
Front End: Angular, React js
Database: Oracle, PL/SQL
Application Server: WebLogic
**Should be Aware of**
CI/CD pipeline
Good to have the Testing Tools knowledge
Sonarqube, Junit, Mockito
Interested kindly share cv at adityawadhera(dot)cw@ hcg(dot)com



Knowledge of Node.js and frameworks available for it (such as Express, StrongLoop, etc depending on your technology stack)
Understanding the nature of asynchronous programming and its quirks and workarounds
Good with REST Api and integration of many API's in our backend
Good understanding of server-side templating languages (such as Jade, EJS, etc depending on your technology stack)
Understanding accessibility and security compliance
User authentication and authorization between multiple systems, servers, and environments
Integration of multiple data sources and databases into one system
Understanding fundamental design principles behind a scalable application
Understanding differences between multiple delivery platforms, such as mobile vs. desktop, and optimizing output to match the specific platform
Creating database schemas that represent and support business processes
Implementing automated testing platforms and unit tests
Proficient understanding of code versioning tools, such as Git
Good Code writing skills
Integration with Shopfy, Zoho, ERP, CRM is a plus.

