Sr. SQL Developer (Banking Domain experience)

.Overall 5+ years of experience in application development using Java with creating and deploying microservices using the Spring Boot framework







• Strong experience in Maven.







• Good experience in unit(Junit) and integration testing.







• Experience in Microservices is a must.







Experience in designing and developing REST based services / Microservice development.







• Candidate should have good communication skills (written and verbal)







Excellent analytical and problem solving skills







Any one of these database Mongo, Maria, RMQ, Postgres, or other NoSQL servers







• Experience in AWS and CI/CD







5+ Years







Design, develop, and maintain robust, scalable, and secure backend services and APIs.







• Collaborate with frontend developers to integrate user-facing elements with server-side logic.







Write clean, efficient, and maintainable code following best practices and coding standards.







• Optimize performance and ensure high availability of backend services.







• Implement security measures to protect sensitive data and prevent vulnerabilities.







Design and manage databases, ensuring data integrity and efficient query performance.







Debug, troubleshoot, and resolve issues in production and development environments.







• Conduct code reviews and provide constructive feedback to team members.







Stay up-to-date with emerging backend technologies, frameworks, and best practices.







• Participate in Agile/Scrum ceremonies and contribute to sprint planning and estimations.

About Simpl 

The thrill of working at a start-up that is starting to scale massively is something else. Simpl (FinTech startup of the year - 2020) was formed in 2015 by Nitya Sharma, an investment banker from Wall Street and Chaitra Chidanand, a tech executive from the Valley, when they teamed up with a very clear mission - to make money simple, so that people can live well and do amazing things. Simpl is the payment platform for the mobile-first world, and we’re backed by some of the best names in fintech globally (folks who have invested in Visa, Square and Transferwise), and has Joe Saunders, Ex Chairman and CEO of Visa as a board member.

Everyone at Simpl is an internal entrepreneur who is given a lot of bandwidth and resources to create the next breakthrough towards the long term vision of “making money Simpl”. Our first product is a payment platform that lets people buy instantly, anywhere online, and pay later. In the background, Simpl uses big data for credit underwriting, risk and fraud modelling, all without any paperwork, and enables Banks and Non-Bank Financial Companies to access a whole new consumer market.

In place of traditional forms of identification and authentication, Simpl integrates deeply into merchant apps via SDKs and APIs. This allows for more sophisticated forms of authentication that take full advantage of smartphone data and processing power.

--------

We’re looking for polyglot developers who love to code. You should have >3 years of experience building high-quality products. You should have the ability to write clean code and must’ve worked on one of Ruby, NodeJS, Golang or Python

Responsibilities

1. Develop new features - build POCs, get feedback, and scale is our default mode
2. Building reusable and platform specific components
3. Translating designs and wireframes into high-quality code
4. Optimizing services for maximum performance
5. Ensure faster release cycles by managing distribution over the cloud 

Requirements

1. Hands-on experience in all aspects of software development - analysis, coding, writing tests, deployment, the works.
2. Knowledge of relational databases, SQL, ACID and distributed locking
3. Solid OOPS understanding.
4. Good exposure to building distributed systems, micro-services architecture.
5. Continuous delivery experience
6. Exposure to building platforms (not just products) would be a plus

Job Brief

The job requires .Net Sr Backend Developer. This Developer is expected to have strong technical skills, work closely with the other team members in development and ability to work stand alone. Ability to work on a small team with minimal supervision, Troubleshoot, test and maintain the core product software and databases to ensure strong optimization and functionality

Skills Requirement

• Bachelor’s degree in Computer Science or related field plus 3-5 Years of .Net relevant experience
• Familiarity with the .NET framework, SQL Server, and design/architectural patterns (e.g. Model-View-Controller (MVC))
• Knowledge of .NET languages (e.g. C#, Visual Basic .NET)
• Familiarity with architecture styles/APIs (REST, RPC)
• Understanding of Agile methodologies
• Good knowledge of databases like MySql, SQL. Ability to write optimized SQL queries and good knowledge of Stored Procedures.
• Sound knowledge of testing frameworks like NUnit, XUnit or MS test.
• Strong attention to detail
• Basic understanding of MultiThreading concepts
• Sound knowledge of Linq.
• Proven knowledge of WCF or Restful Web service creation
• Basic knowledge of frontend scripting languages like JavaScript, jQuery
• Sound knowledge of Design principle, OOPs concepts & Solid Principle
• Sound knowledge of Entity framework
• Experience with GitHub, Tortoise SVN Version Control
• Strong attention to detail
• Knack for writing clean, readable, and easily maintainable code
• Sound analytical, problem-solving, and communication skills.
•  

Responsibilities

• Translate application storyboards and use cases into functional applications
• Design, build and maintain efficient, reusable, and reliable code
• Ensure the best possible performance, quality, and responsiveness of applications
• Identify bottlenecks and bugs, and devise solutions to mitigate and address these issues
• Help maintain code quality, organization, and automatization
• Utilizing Microsoft's .NET infrastructure to create software solutions that meet clients' requirements.
• Collaborating with coworkers to facilitate the creation of large, complex developments, as required.
• Reformulating existing code to ensure adherence to stipulated guidelines.
• Checking your code to detect and remedy errors and omissions.
• Testing your outputs to ensure that they are in excellent working order.
• Deploying developments and monitoring uptake by the target audience.
• Using clients' feedback to inform the creation of subsequent versions of each development.
• Remaining abreast of coding and technological changes that will impact your work.

https://www.oziva.in/">OZiva is India's leading clean, plant based nutrition brand, combining modern science and ancient Ayurveda. We aim towards driving the paradigm shift from curative health care to preventive healthcare by focusing on the two fundamental pillars of fitness - nutrition and exercise.

OZiva is a startup founded by IIT, INSEAD and Mumbai University alumni with an existing vision to help people lead a healthier and better lifestyle.

We run a powerful, high impact, fast paced operation with cutting edge technology and good old-fashioned passion for making people healthier and fitter.

• Work with product managers to understand product requirements and make them live.
• Ownership of end to end development

• Startup mindset of getting things done and focussing on business goals
• Proven problem solving skills
• 3+ years Hands on experience in designing and developing applications using server side technology (Java, Spring Boot / Node.js, Express)
• Excellent knowledge of Relational Databases, SQL and ORM technologies
• Good knowledge of design patterns
• Proficiency in REST architecture
• Experience with test-driven development
• Experience with Git/CI/CD/Gradle/Maven
• Inclination towards writing quality and performant code

• Experience in Agile development
• Performance tuning, testing, refactoring and automation
• Experience working with AWS Cloud and Devops technologies (terraform , cloudformation, ansible)
• Experience running a production environment

• Creating, designing and developing data models
• Prepare plans for all ETL (Extract/Transformation/Load) procedures and architectures
• Validating results and creating business reports
• Monitoring and tuning data loads and queries
• Develop and prepare a schedule for a new data warehouse
• Analyze large databases and recommend appropriate optimization for the same
• Administer all requirements and design various functional specifications for data
• Provide support to the Software Development Life cycle
• Prepare various code designs and ensure efficient implementation of the same
• Evaluate all codes and ensure the quality of all project deliverables
• Monitor data warehouse work and provide subject matter expertise
• Hands-on BI practices, data structures, data modeling, SQL skills

Hard Skills for a Data Warehouse Developer:

• Hands-on experience with ETL tools e.g., DataStage, Informatica, Pentaho, Talend
• Sound knowledge of https://www.freelancermap.com/it-projects/sql-1084" target="_blank">SQL
• Experience with SQL databases such as Oracle, DB2, and SQL
• Experience using Data Warehouse platforms e.g., SAP, Birst
• Experience designing, developing, and implementing Data Warehouse solutions
• Project management and system development methodology
• Ability to proactively research solutions and best practices

Soft Skills for Data Warehouse Developers:

• Excellent Analytical skills
• Excellent verbal and written communications
• Strong organization skills
• Ability to work on a team, as well as independently

Requirement:-
1. Strong PHP Core programming expertise
2. MySQL DB Model Design and Programming expertise
3. Strong skills in either Joomla or WordPress - at least one is needed.
4. Working know how of HTML 5/ CSS 3
5. Knowledge of SVN or any other version control tools
6. Must have solid REST/API implementation and integration concepts.

Preferred addons :-
1. Good to have Frontend Skills in - Javascript/JQuery/Bootstrap/Angular
2. Experience in common third-party social APIs (google, Facebook, eBay etc)
3. Experience with Payment Gateway integration with APIs like (paypal, payza, authorise.net, Firstdata, Ipayout, Stripe etc)
4. Any experience in Ionic / PhoneGap is a plus

Benefits
1. 6 months of probation period.
2. Working Days: Monday-Friday (As per International Standards).
3. Working Timings: 9 hours per day including break of 1 hour
4. Opportunities to learn and grow.

Locus is a global decision- making platform in the supply chain that uses deep learning and proprietary algorithms to provide route optimization, real-time tracking, insights and analytics, beat optimization, efficient warehouse management, vehicle allocation and utilization, intuitive 3D packing and measurement of packages. Locus automates human decisions required to transport a package or a person, between any two points on earth, delivering gains along efficiency, consistency, and transparency in operations.

Locus, which has achieved a peak of 1 million orders processed in a day (200,000 orders an hour) and is trained & tested on over 100 million+ order deliveries, works in 75 cities across the globe. Locus works with several large-scale market leaders like Urban Ladder, Tata Group of Companies, Droplet, Licious, Rollick, Lenskart, other global FMCG, pharma, e-commerce, 3PL and logistics conglomerates.

Locus is backed by some of the biggest names in the market and recently raised $22 MN in Series B funding and also $4 Mn in a pre-Series B round. Earlier, In 2016, Locus raised $2.75 Mn (INR 18.3 Cr) in a Series A funding.

Locus was started by Nishith Rastogi and Geet Garg, two ex-Amazon engineers on a mission to democratize logistics intelligence for businesses across industries. Nishith was profiled by Forbes Asia in their ’30 Under 30’ 2018 list. Geet, on the other hand, holds a dual degree (BTech and MTech) in Computer Science and Engineering from the Indian Institute of Technology. Our team constitutes of engineers from Indian Institute of Technology and Birla Institute of Technology & Science- Pilani, and Data Scientists with PhDs from Carnegie Mellon University and Tata Institute of Fundamental Research. Our multifaced product and business team is led by senior members from Barclays, Google & Goldman Sachs with immense operational execution experience.

Job Description

• Design & implement backend APIs at Locus.sh
• Mentor junior developers technically.
• Actively work to reduce tech debt in the Locus backend
• Work towards more stability & scalability of the backend
• Tech stack - Java, AWS, Aurora etc.

Eligibility

• 4-8 years of product company experience
• OOP implementation experience. Programming language does not matter, We use Java internally but have hired folks from non Java background.
• Hands on experience in SQL, Dynamo DB, Postgres etc preferred.
• Prior experience building REST APIs
• Advanced understanding of AWS stack
• Prior knowledge of solving problems at scale.

Perks:

• Healthy catered meals at office
• You decide your own Work From Home (WFH) and Out Of Office (OOO)
• Pet-friendly - bring your pets to the office any day. Locus family already has a Rottweiler and a Beagle

Responsibilities:

• Thorough understanding of Reconciliation and hands on development experience on Intellimatch 9.2.7 or higher version
• Comprehensive understanding of SDLC in developing new Reconciliations in IntelliMatch. Involvement across all stages of Software Development life cycle (SDLC) including business requirement analysis, data mapping, validate data against requirement, build, unit testing, peer reviews, systems integration and user acceptance testing.
• Analyze & develop Test Strategies, design Test Plans, & generate and execute Test Cases.
• Should be able to perform enhancements, whereby need to analyze existing set-up and understand the requirement by performing proper impact analysis, provide estimate and deliver quality code.
• Independent player should be able to liaise with different team to re-solve/get dependencies on time. Should be able to for-see issue/risk and intimate the same to team lead / project manager.
• Should be able to guide support team.
• Deep knowledge on IntelliMatch Database linkage and functionalities is necessary for timely resolution of user queries.
• Propose improvements related to the development and support activity.
• Develop stored procedures to build reports for the end users using SQL 2016