SQL Developer

Oister Global (www.oisterglobal.com) is India’s premier Alternative Assets Manager. We combine robust diligence, deep domain expertise, and an extensive network to create high quality private market opportunities for our investors.

We are seeking a Senior Backend Developer who will be pivotal in architecting and developing scalable, reliable backend systems from scratch. You will work closely with product managers, designers, and other engineers to build new products, design backend architectures, and ensure high performance and responsiveness of the systems. This role requires strong backend fundamentals, cloud experience, a deep understanding of databases, and a passion for system design and architecture.

Key Responsibilities:

● Product Development: Architect, design, develop, test, and deploy new backend products and features from scratch.

● System Design: Take ownership of system design and architecture decisions for new modules, ensuring scalability, reliability, and security. ● API Development: Build efficient and reusable APIs and backend services using Node.js.

● Database Management: Design data models, optimize queries, and manage MongoDB clusters efficiently.

● Cloud Management: Deploy, maintain, and optimize services on AWS, ensuring high availability and performance.

● Best Practices: Maintain coding standards, ensure code reviews, and champion best practices in security, testing, and maintainability.

● Collaboration: Work closely with frontend developers, product managers, QA, and other cross-functional teams to define, design, and ship new features.

● Performance Optimization: Monitor system performance and ensure system uptime and responsiveness.

● Mentorship: Provide guidance and mentorship to junior developers as required.

● Documentation: Maintain thorough documentation of systems, processes, and best practices. Must-Have

Qualifications:

● Education: Bachelor’s degree in computer science, Software Engineering, or a related technical field.

● Experience: 4–5+ years of hands-on backend development experience.

● Expertise in: Node.js (Express.js, Nest.js or similar frameworks) MongoDB (including indexing, replication, sharding concepts) AWS Services (EC2, S3, Lambda, RDS, API Gateway, CloudWatch, IAM, etc.) Proficient in: System design principles Microservices architecture Event-driven architecture Strong understanding of: RESTful APIs.Authentication and authorization best practices (OAuth, JWT) Experience with: CI/CD pipelines Docker and containerization principles Hands-on experience in: Building scalable, distributed, and fault-tolerant systems Good knowledge of : Logging, monitoring, and debugging distributed applications

·       3+ yrs of experience in product development (Preferring SaaS based)

·       Must have experience in Java web-based application development

·       Hands on development experience on Java/J2EE, Springboot, Spring, Struts, Hibernate, REST Services

·       Experience on HTML, JavaScript, JQuery

·       Hands on experience on database-writing queries/procedures

·       Experience on SVN,GIT,

·       Knowledge of Server configuration

·       Knowledge of cloud preferably AWS

• Must have applied knowledge of Python and trending data libraries.
• Experience on Python Backend Development framework like Flask, Django etc.
• Must have experience working on AWS (Lambda, EC2, S3, API Gateway etc).
• Must have experience working on SQL optimization and performance tuning.
• Nice to have technical knowledge in any ETL/ BI Tools (Datastage, Informatica, Alteryx, Microstrategy, RDM, MDM etc.

• 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

• Banking / Insurance / Retail domain would be a plus.
• Interaction with a client a plus

• Knowledge in a Cloud Platform (AWS / Azure)
• Knowledge on version control system (SVN / Git)
• Exposure to Quality and Process Management
• Knowledge in Agile Methodology

• 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

• Design & build a highly scalable, robust backend architecture for our cloud services
• You will be part of a software development team for developing and enhancing SaaS applications.
• Take responsibility of entire module/feature set and develop, test, debug and maintain the application software throughout the product lifecycle
• Working with the Product Management Team to validate and plan new features
• Working with cross-functional teams to deliver stellar end user experience
• Research new technologies and tools that help in building the next generation of our services
• Test, debug and maintain the application software throughout the product lifecycle

• Must have experience with web development in Java 8+, Spring/J2EE or similar frameworks and technologies. (Mandatory)
• Must have worked on REST API (Mandatory)
• Should be an enthusiast for writing clean, reusable code, willing to learn new things as a self-starter person
• 2+ years of strong relevant experience in developing Object-oriented technologies.
• Strong working experience with any of the following DBs - Postgres / MySQL / Oracle or MSSQL
  

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

• IMMEDIATE JOINEE.
• Work with other engineers to develop and test tools and applications used by team on daily basis
• Play a significant role in the ongoing evolution and refinement of current tools and applications
• Triage, troubleshoot, escalate and provide resolution to production issues.
• Reproduce, document and escalate product defects to the Engineering Team.
• Provide well-thought out and reliable direction, both in technical and non-technical terms, to help customers.
• Take ownership of customer issues, including initial troubleshooting, identification of root cause and issue resolution or escalation.
• Identify and escalate priority issues that need immediate attention.
• Collaborate with cross functional teams which requires strong presentation skills and attention to details
  
  
• BA/BS degree in Computer Science or related technical field or equivalent work experience. MS degree is preferred.
• 9+ years development experience in JAVA (using OO Design and Analysis, Design Patterns, etc.)
• High experience in Java 8 Required.
• 4+ years’ experience building highly scalable, distributed and reliable Restful Web Services using Spring, Jersey, etc.
• Should have knowledge on Cloud applications preferably on AWS.
• Knowledge on building Front end applications using JavaScript, AngularJS, HTML5, CSS3.
• Experience with relational DBs like MySQL and NoSQL Database like MongoDB, Solr/Lucene will be a plus.
• Experience with Tomcat, Jax-RS, REST, JPA, IntelliJ, Groovy, Hibernate is must.
• Experience with build technologies like Gradle, Jenkins will be a plus.
• Experience with Test Driven Development using TestNG/Junit testing frameworks.
• Experience working with version control like GIT.

We are urgently looking Azure Data Factory Engineers with 3 to 7 years of overall experience, having good experience on Azure Data Factory and SSIS.

Requirements:

• Qualification: Engineering Graduate.
• Years of Experience: 2+ yrs of relevant experience on Azure Data Factory & SSIS.
• Strong understanding of ETL/ELT concepts.
• Hands on experience on Azure Data Factory.
• Exposure of Cloud technologies, standards, and platforms.
• Sound knowledge of ADF pipeline, configuration, parameters, variables, Integration services runtime (part of Data Factory).
• Strong Experience on SSIS.
• Sound knowledge of implementing slowly changing dimensions and transactional, fact less, snapshot fact tables.
• Azure Data Warehouse.
• Knowledge on Azure components especially file storage and Azure Sql, Blob storage and Data Lake Gen2 storage (just used as a file system on the blob).
• Azure Data Migration tool.
• Well versed with RDBMS systems like Sql server, DDL, DML scripts.
• Sound knowledge of T-SQL and stored procedures.
• Strong Query writing skills, Scheduling tools.
• Ensure quality deliverable and ability to extend work hours if required.
• Azure Certification: Preferred.
• Ability to understand Customer requirements and convert the requirements into technical specifications.
• Ability to understand the overall solution and design components to fit the overall solution.
• Ability to take technical decisions and support the decisions with justifications.
• Ability to work in Agile manner.
• Ability to work independently without much guidance.
• Self-Motivated, team player, results oriented, strong Time Management skills.
• Excellent written and verbal communication skills.
• Willing to travel to outside India (Short term as well as long term)