SQL- DWH Developer

Job Description:

We are seeking an experienced Java Back-end Developer to join our team. The ideal candidate

will be responsible for designing, developing, and maintaining robust and scalable back-end

solutions using Java and related technologies. The Back-end Developer will work closely with

cross-functional teams to deliver high-quality software solutions that meet our business needs.

Responsibilities:

 Design, develop, and maintain Java-based back-end applications, services, and APIs.

 Write efficient, reusable, and well-documented code following industry best practices

and coding standards.

 Collaborate with front-end developers, product managers, and other stakeholders to

understand requirements and translate them into technical solutions.

 Implement and maintain database schemas, write complex SQL queries, and optimize

database performance using Oracle SQL.

 Develop and consume RESTful web services to enable seamless integration with

external systems.

 Utilize Spring framework and its various modules (e.g., Spring Boot, Spring Batch) for

building enterprise-level applications.

 Manage project dependencies and build processes using Maven.

 Work with version control systems such as Git for code management and collaboration.

 Perform unit testing, integration testing, and debugging to ensure the quality and

reliability of back-end components.

 Stay updated on emerging technologies, trends, and best practices in back-end

development.

Additional Requirements:

 Strong knowledge of application servers such as Tomcat and WebLogic.

 Experience with continuous integration tools such as Jenkins.

 Familiarity with automated testing frameworks such as JUnit.

 Understanding of authentication and authorization mechanisms, including OAuth.

 Knowledge of SOAP web services and related technologies.

Requirements:

 Bachelor's degree in Computer Science, Engineering, or a related field.

 5 Plus years of experience in Java back-end development.

 Proficiency in Java programming language and related frameworks (e.g., Spring, Spring

Boot, Spring Batch).

 Strong understanding of object-oriented programming principles, data structures, and

algorithms.

 Experience with Oracle SQL and database design principles.

 Familiarity with RESTful web services and API development.

 Experience with build tools such as Maven.

 Knowledge of version control systems, particularly Git.

 Strong problem-solving skills and attention to detail.

 Excellent communication and collaboration skills.

 Ability to work effectively in a fast-paced, agile environment.

Preferred Qualifications:

 Experience with other databases such as MySQL, PostgreSQL, or MongoDB.

 Familiarity with continuous integration/continuous deployment (CI/CD) pipelines.

 Understanding of software development best practices and design patterns.

• 1-5 years of experience in Java Development.
• Very good with DSA - Java programming.
• Hands-on experience in working with REST APIs & Web Services.
• Good Database design skills - SQL
• Write well-designed, testable, efficient code.
• Contribute to all phases of the development lifecycle.

Work Location : Bangalore

Work mode : Work from office.

Key skills : Python, Numpy, Panda, SQL, ETL 

Roles and Responsibilities:

- The work will involve the development of workflows triggered by events from other systems

- Design, develop, test, and deliver software solutions in the FX Derivatives group

- Analyse requirements for the solutions they deliver, to ensure that they provide the right solution

- Develop easy to use documentation for the frameworks and tools developed for adaption by other teams

Familiarity with event-driven programming in Python

- Must have unit testing and debugging skills

- Good problem solving and analytical skills

- Python packages such as NumPy, Scikit learn

- Testing and debugging applications.

- Developing back-end components.

WHO YOU ARE

To be successful in this role, you’ll need to have the following skills:

·         Love for coding: A fanatic about writing beautiful and scalable code.

·         A sense of analytics: Strong analytical and troubleshooting skills. Should be resourceful, innovative and inventive.

·         Dynamic: Should be comfortable in dealing with lots of moving pieces. Have exquisite attention to detail, and are comfortable learning new technologies and systems. 

·         Team player: Knack for influencing without being authoritative. Pitch in wherever the team needs help, from writing blog posts to supporting customers.

·         Accountability: High sense of ownership for your code and relentlessness to deliver projects with high business impact. 

KEY QUALIFICATIONS

·         BE/BTech in Computer Science or related field. 

·         5+ years of professional production and development experience with leading-edge server and database technologies (e.g., Python, Java, Node.js, Scala, Spring Boot, MySQL, and NoSQL databases).

KEY SKILLS

·         Strong computer system analysis and design skills in current methodologies and patterns Experience with professional production cloud (AWS preferred).

·         Experience with RESTful Services and APIs.

• Rewrite existing APIs in NodeJS. 
• Remodel the APIs into Micro services-based architecture. 
• Implement a caching layer wherever possible. 
• Optimize the API for high performance and scalability. 
• Write unit tests for API Testing.
• Automate the code testing and deployment process.

Skills Required: 

• At least 2 years of experience developing Backends using NodeJS — should be well versed with its asynchronous nature & event loop, and know its quirks and workarounds. 
• Excellent hands-on experience using MySQL or any other SQL Database. 
• Good knowledge of MongoDB or any other NoSQL Database. 
• Good knowledge in postgre
• Good knowledge of Redis, its data types, and their use cases. 
• Experience with graph-based databases like GraphQL and Neo4j. 
• Experience developing and deploying REST APIs. 
• Good knowledge of Unit Testing and available Test Frameworks. 
• Good understanding of advanced JS libraries and frameworks. 
• Experience with Web sockets, Service Workers, and Web Push Notifications. 
• Familiar with NodeJS profiling tools. 
• Proficient understanding of code versioning tools such as Git. 
• Good knowledge of creating and maintaining DevOps infrastructure on cloud platforms. 
• Should be a fast learner and a go-getter — without any fear of trying out new things Preferences. 
• Experience building a large scale social or location-based app

• Build data pipelines for structured/unstructured, real-time/batch, events/synchronous/asynchronous using MQ, Kafka, Steam processing using Java / Python
• Design the Data stores for Big Data systems with expertise in Cassandra, HBase
• Implementation of Indexing and Search using Elasticsearch
• Setup and Deployment of Cassandra, Elasticsearch clusters

• Strong hands-on experience with Cassandra, data modeling, data replication, clustering, indexing for handling for large data sets
• Experience with SQL, NoSQL, relational database design, and methods for efficiently retrieving data for Time Series Analytics
• Strong understanding of CQL, Data Modeling in-order to achieve highly performant data access
• Strong experience in data modeling in Cassandra to design efficient storage model to meet variety of business needs
• Should have Elasticsearch skill with significant experience working with large Elasticsearch clusters, cluster performance optimisation, capacity planning, enhancing monitoring capabilities for early issue detection, driving operational readiness and ongoing maintenance
• Strong hands-on experience of programming with Java / Python
• Ability to troubleshoot and investigate stability, performance issues