Senior Database Developer - Data Modeling & DB Design Schema

About Increasingly Technologies
About
Ecommerce retailers are facing massive competition today - many more eCommerce sites as well as Amazon, Flipkart. Ecommerce retailers needed to drive up revenue from every single customer.
The solution - The platform helps any retailer drive up sales of collections/looks/kits/bundles. Using AI and great UX Increasingly has won awards including Ecommerce Innovation of the Year.
Increasingly is an AI-powered cross-sell platform. Since 2016, we have been working to reinvent cross-selling. We've taken inspiration from Amazon bundling and built on that idea.
Today we are the world-leading cross-selling technology that ambitious and intelligent retailers choose. As a team, we are an incredible mix of e-commerce experts, developers, data scientists, and machine learning engineers.
Company video

Photos
Connect with the team
Similar jobs

Role: Perl Developer
Location: Remote
Experience: 6–8 years
Shift: General
Job Description
Primary Skills (Must Have):
- Strong Perl development skills.
- Good knowledge of Python and T-SQL / SQL Server to create compatible code.
- Hands-on experience with ADO, Git, and release management practices.
Secondary Skills (Good to Have):
- Familiarity with monitoring/alerting tools.
- Exposure to automation tools.
Day-to-Day Responsibilities
- Perform application code conversion for compatibility between Sybase and MS SQL.
- Work on existing Perl-based codebase, ensuring maintainability and compatibility.
- Convert code into Python where feasible (as part of the migration strategy).
- Where Python conversion is not feasible, create compatible code in Perl.
- Collaborate with the team on release management and version control (Git).
· Participate in analysis, design, and new development of Appian based applications
· Build applications: interfaces, process flows, expressions, data types, sites, integrations, etc.
· Proficient with SQL queries and with accessing data present in DB tables and views
· Experience in Analysis, Designing process models, Records, Reports, SAIL, forms, gateways, smart
services, integration services and web services
· Experience working with different Appian Object types, query rules, constant rules and expression
rules
Primary Responsibilities:
· Responsible for systems analysis for a designated set of applications
· Work closely with BA and System Architect & Delivery Manager. Own the accurate translation of
business requirements in the form of high-level design and system requirements specifications.
· Ensure sign-off of SRS and High-Level Design Specification
· Assist the PM in the estimation of effort to deliver the solution based on the SRS and the timelines.
· Liaise with Infra teams in the production of an infrastructure solution design and requirements as
and when the proposed solution involves infrastructure components
· Provide further clarity and detail to feasible options proposed by BA and help in selection of the
right option in consultation with the Design Authority.
· Work closely with the Application Development team (Tech Delivery Lead) and Testing teams (Test
Manager and Test Engineer) to ensure that the Low-level design, test plans and test cases are aligned to
the approved SRS.
· Participate in progress review meetings and review and sign-off deliverables produced by technical
delivery team and testing teams.
Qualifications
- B.Sc. (Computer Science), B.E
· Minimum 5 years of experience in Insurance domain
· At least 4 years of experience in Implementing BPM solutions using Appian 19.x or higher.
· Over 5 years in Implementing IT solutions using BPM or integration technologies.
· Experience in Scrum/Agile methodologies with Enterprise level application development projects
· Good understanding of database concepts and strong working knowledge any one of the major
databases e g Oracle SQL Server MySQL
Additional information
Skills Required
·
· Appian BPM application development and System Analysis
· 8-10 years of proven software System Analysis and design experience
· Ability to work on large and complex projects.
· Strong technical knowledge of existing Insurance/F&A application
· Excellent documentation, communication, and presentation skills
· Ability to understand business requirements, analyze and translate them into system
requirements

Hands-on experience with RESTful services, API design are must.
Knowledge of microservices architecture is must.
Knowledge of design patterns is a must.
Strong knowledge of Exception handling and logging mechanism is a must.
Agile scrum participation experience. Work experience with several agile teams on an application built
with microservices and event-based architectures to be deployed on hybrid (on-prem/cloud)
environments.
Good knowledge of Spring framework (MVC, Cloud, Data and Security. Etc) and ORM frameworks like JPA/Hibernate.
Experience in managing the Source Code Base through Version Control tools like SVN, GitHub,
Bitbucket, etc.
Experience in using and configuration of Continuous Integration tools Jenkins, Travis, GitLab, etc.
Experience in the design and development of SaaS/PaaS-based architecture and tenancy models.
Experience in SaaS/PaaS-based application development used by a high volume of
subscribers/customers.
Awareness and understanding of data security and privacy.
Experience in performing Java Code Reviews using review tools like SonarQube, etc.
Good understanding of end-to-end software development lifecycle. Ability to read and understand
requirements and design documents.
Good Analytical skills and should be self-driven.
Good communication with interpersonal skills.
Open to learning new technologies and domains.
A good team player and ready to take up new challenges. Active communication and coordination with
Clients and Internal stakeholders
Requirements: Skills and Qualifications
6-8 years of experience in developing Java/J2EE-based Enterprise Web Applications
Languages: Java, J2EE, and Python
Databases: MySQL, Oracle, SQL Server, PostgreSQL, Redshift, MongoDB
DB Script: SQL and PL/SQL
Frameworks: Spring, Spring Boot, Jersey, Hibernate and JPA
OS: Windows, Linux/Unix.
Cloud Services: AWS and Azure
Version Controls/ DevOps tools: Git, Bitbucket and Jenkins.
Message brokers: RabbitMQ, and Kafka
Deployment Servers: Tomcat, Docker, and Kubernetes
Build Tools: Gradle/Maven
Roles & Responsibilities:
- Analyze, design, implement and integrate functional requirements in the solutions.
- Deliver fully tested source code complying with quality indicators objectives.
- Develop new functionality on our existing software products.
- Maintaining and supporting multiple projects and deadlines.
- Ability to communicate clearly with clients.
- Working within a Team to determine needs and applying / customizing existing technology to meet those needs.
- Proper Reporting & Documentation.
Required Skills:
- Should have a strong knowledge of OOPS with working knowledge of MVC.
- Experience with Microsoft .NET technologies including, ASP.NET, MVC, Entity Framework.
- Proven Skills with C#, SQL, JavaScript/DHTML, HTML-CSS, AJAX, jQuery, Web Services, etc.
- Ability to complete all phases of software development life cycle.
- Should have working knowledge of using a latest development tools and techniques.
- Basic knowledge of front end UI design preferred.
- Must have good problem solving and analytical skills.
- Must be a team player, having good communication skills in English, self-starter.
Qualifications
Eligibility Criteria:
- Candidate should be any graduate/post graduate in Computer Science or related degree program.
- Excellent communication & presentation skills.
- Freshers can also apply.
- Experience is preferred.
JOB LOCATION- NAVSARI-


- Strong experience in developing enterprise web applications.
- Expertise on the Microsoft technology stack (.NET, C#, ASP.NET, MVC, Web API, SQL Server)
- Candidates should have solid understanding of object-oriented programming and programming principles NET, C ,MVC, XML, MS Sql Database debugging and analysing code.
- Candidates should have experience with SDLC to include the following stages requirements analysis design coding testing documentation and implementation.
- Experience with .Net core Web API MVC C# Entity Framework
- Troubleshooting & analysing skills.
- Development experience required for Continuous improvement program.
- Good problem-solving capabilities in Developed applications.
- Exposure to Angular is an added advantage
• Exposure to latest Technology
• Opportunity working in different platforms
• Rapid Career Growth
• Friendly Knowledge sharing Environment
Criteria:
• BE/MTech/MCA/MSc
• 3+yrs Hands on Experience in TSQL / PL SQL / PG SQL or NOSQL
• Immediate joiners preferred/ Maximum notice period between 15 to 30days
• Candidates will be selected based on logical / technical and scenario-based testing
Note: Candidates who have attended the interview process with TnS in the last 6 months will not be
eligible.
Job Description:
Technical Skills Desired:
- 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
Functional Skills Desired:
- Banking / Insurance / Retail domain would be a plus.
- Interaction with a client a plus
Good to Have Skills:
- Knowledge in a Cloud Platform (AWS / Azure)
- Knowledge on version control system (SVN / Git)
- Exposure to Quality and Process Management
- Knowledge in Agile Methodology
Soft skills: (additional)
- 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




