Concepts of RDBMS, Normalization techniques
Entity Relationship diagram/ ER-Model
Transaction, commit, rollback, ACID properties
Transaction log
Difference in behavior of the column if it is nullable
SQL Statements
Join Operations
DDL, DML, Data Modelling
Optimal Query writing - with Aggregate fn, Group By, having clause, Order by etc. Should be
hands on for scenario-based query Writing
Query optimizing technique, Indexing in depth
Understanding query plan
Batching
Locking schemes
Isolation levels
Concept of stored procedure, Cursor, trigger, View
Beginner level - PL/SQL - Procedure Function writing skill.
Spring JPA and Spring Data basics
Hibernate mappings
UNIX
Basic Concepts on Unix
Commonly used Unix Commands with their options
Combining Unix commands using Pipe Filter etc.
Vi Editor & its different modes
Basic level Scripting and basic knowledge on how to execute jar files from host
Files and directory permissions
Application based scenarios.

Similar jobs


A bit about us
WeatherBug, a division of GroundTruth, empowers people to plan their day thanks to hyperlocal weather forecasts. With 10+ million monthly users, our app and website are favorites on the App Store and Google Play Store. We use a vast network of weather observations and innovative technology to give you real-time forecasts, alerts, and insights. Our team is passionate about enhancing user experiences and always looks for new ways to use weather data to make a difference. Join us at WeatherBug and help people stay informed and prepared for whatever the weather brings. Let's make it happen together!
Learn more: www.weatherbug.com
At GroundTruth, we believe that innovative technology starts with the best talent and we have been ranked one of Ad Age’s Best Places to Work for three years in a row (2021, 2022 & 2023). Learn more about the perks of joining our team here.
Role : Senior Software Engineer (iOS/React Native)
Location : Remote, India
*This role requires Core Work Hours from 8:30 pm to 12:30 am IST (will change as per daylight saving in US). The remaining hours are completed at individual discretion.*
Role Characteristics:
Recognized subject matter expert who knows how to apply theory and put it into practice with in-depth understanding of the professional field with limited oversight from managers. Independently performs the full range of responsibilities within the function; requires deep job knowledge of areas typically obtained through higher education combined with experience. Manages large projects or processes and problems faced are difficult and often complex; analyzes problems/issues of diverse scope and determines solutions. May manage programs that include formulating strategies and administering policies, processes, and resources; functions with a high degree of autonomy. Influences others regarding policies, practices and procedures.
You Will:
- Design, architect, and document the entire system, down to the details, to meet team needs.
- Code robust iOS solutions to solve current problems, identifying and fixing issues within your areas of expertise.
- Act as a CodeOwner and stakeholder in code reviews within your area of expertise.
- Automate unit, integration, and end-to-end testing solutions, working closely with the QA team to ensure seamless integration.
- Deploy and run your code in pre-production to ensure quality before release.
- Develop and maintain debugging tools to enhance team efficiency.
- Collaborate with vendors to ensure third-party SDKs are properly integrated and functional.
- Perform and monitor mobile releases for iOS, ensuring smooth rollouts and updates.
- Retire outdated solutions and resources when no longer needed, ensuring the system remains efficient and streamlined.
- Provide operational support for your deployed code and all code within your domain of expertise.
- Identify and address team-wide issues, preventing problems from occurring.
- Coordinate across all business teams to resolve technical issues, mitigate risks, and provide actionable solutions.
- Perform other job-related duties as assigned
You Have:
- 4-year degree in Computer Science or a related field OR 9+ years of experience in software development.
- 7+ years of experience in software engineering.
- 5+ years of experience with iOS development tools (Swift, SwiftUI, Objective-C, Xcode, Core Data, Combine, Foundation, UIKit).
- 2+ years of experience with SwiftUI or declarative UI frameworks.
- 3+ years of experience on an Agile team.
- Proficiency in Concurrency, Multithreading, and Swift Combine or other asynchronous programming patterns.
- Knowledge of object-oriented design principles, patterns, best practices, performance optimizations, and memory management on iOS.
- Ability to effectively communicate across teams to provide and implement solutions.
- Proven ability to troubleshoot complex issues and execute solutions.
- A strong sense of self-drive and technical expertise to work independently and within a team.
- Mentorship skills to guide junior and mid-level engineers.
- Excellent communication and documentation skills to articulate ideas clearly.
- Strong problem-solving and critical-thinking abilities to handle edge cases and unexpected issues.
- Experience collaborating with cross-functional teams (designers, product managers, QA).
Great if You Have:
- Experience using React Native (Function Components, Hooks, Redux, JavaScript/TypeScript).
- Familiarity with ingesting and exposing large datasets in the weather industry.
- Experience in the advertising industry.
- Proficiency with tools like GitHub, Jenkins, Spinnaker, Artifactory.
What we offer
At WeatherBug, we want our employees to be comfortable with their benefits so they can focus on doing the work they love.
- Parental leave- Maternity and Paternity
- Flexible Time Offs (Earned Leaves, Sick Leaves, Birthday leave, Bereavement leave & Company Holidays)
- In Office Daily Catered Lunch
- Fully stocked snacks/beverages
- Health cover for any hospitalization. Covers both nuclear family and parents
- Tele-med for free doctor consultation, discounts on health checkups and medicines
- Wellness/Gym Reimbursement
- Pet Expense Reimbursement
- Childcare Expenses and reimbursements
- Employee assistance program
- Employee referral program
- Education reimbursement program
- Skill development program
- Cell phone reimbursement (Mobile Subsidy program)
- Internet reimbursement
- Birthday treat reimbursement
- Employee Provident Fund Scheme offering different tax saving options such as VPF and employee and employer contribution up to 12% Basic
- Creche reimbursement
- Co-working space reimbursement
- NPS employer match
- Meal card for tax benefit
- Special benefits on salary account
We are an equal opportunity employer and value diversity, inclusion and equity at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status.


Python/Django Developer will be responsible for implementing the relevant Server-Side Architecture for a Web Application based on the client's requirement for new and existing products. The primary focus will be on the development of software packages ensuring high quality and ease of usability to requests from various teams.
Duties & Responsibilities:
- Writing reusable, testable and efficient code
- Design and Implementation of low-latency, user-friendly web and mobile-based applications
- Devise and develop user-friendly software solutions for automation of industry processes
- Contribute to design reviews and discussions across software teams.
- Following strict security protocols without any deviation is of prime importance.
- Implementing DevOps in all projects and establishing best practices in the team.
Preferred Skills & Knowledge:
- Strong programming skills in Python/Django
- Experience with Angular, JavaScript frameworks/libraries
- Hands-on experience with MySQL, PostgreSQL or other RDBMS
- Experience with Web application security and secure coding practices
- Strong Analytical thinking and problem-solving ability
- Familiarity with software collaboration tools - GIT
- Ability to work with a distributed and diverse team of researchers and developers.
- Excellent English language communication skills, both written and verbal.
- High level of innovation and motivation

Responsibilities
Develop high quality, secure, stable code for use in products and solutions for
customers, making it easier for other developers to maintain, enhance, reuse,
and localize
Work with Product Owner and/or Product Manager/Team to understand and help
refine functional requirements for new products
Develop and outline architecture and relationships between subsystems and
participates in review of those designs
Investigate and, if necessary, prototype technologies and algorithms relating to
the task
Break down a large problem into smaller components and provide a clear
solution for each piece
Ensure new code, feature or software product meets performance goals/metrics
Research external best practices and emerging technologies for possible
incorporation into company products and methodologies
Write and maintain the code following Test-Driven-Design principles
Minimum Qualifications
Bachelor’s degree in any Engineering discipline from reputed engineering
college
5 to 7 years of strong programming skills in Web and Cloud Technologies
Should have a very strong foundation in JavaScript, and must have a clear
understanding of basic web fundamentals such as prototype based inheritance,
scopes, Event Loop, Memory Management in JS, etc
Should be good at developing modular front-end applications and is expected to
have the knowledge to create good abstractions that can be reused . Should also
have in-depth understanding of latest ES6 standards such as spread operators,
arrow functions, etc
Should have strong programming skills in Web and Cloud Technologies
Should be strong in OOAD Concepts
Should have a strong hands-on in React, Typescript
Should have Hands-on experience in any of the backend language.
Should understand latest paradigms in Front End Development such as Pub-Sub
Pattern, Redux, RxJS, Service Workers, Client Caching, Lazy Loading, Dynamic
Injection, Bundle Optimisation, etc
Should have very good hands-on knowledge of CSS3 & HTML5
Should have good knowledge of Postman API Platform
Should have experience with Amazon web services – ECS, Lambda, S3, SQS, etc
Should have Hands-on experience of developing RESTful web services and
integrating the same with heterogeneous clients
Should have Hands-on experience with Relational or NoSQL Database’s
Should have a very clear understanding of TDD is expected and should have
good exposure to writing UT's and designing UI components with testability in
mind
Should have Strong Communication and Analytical skills
Flexibility under changing conditions and the ability to multi-task between
projects
Preferred Qualifications
Hands-on experience with C++
Nice to have experience with Python
Nice to have experience with CI/CD tools like Docker, Jenkins, etc
Nice to have a hands-on & Understanding of CSS Pre-processors such as SASS,
LESS, etc
- Responsible for solving User tickets related to O-365.
- Responsible for network issues related to O-365.
- Responsible for optimizing the usage of O-365 features.
Roles and Responsibilities:
- Identifying potential clients and partners, and reaching out to them to understand their requirements and counsel the students to choose Skill Dunia courses.
- You will be responsible for managing relationships with existing clients and partners, as well as developing new relationships to help drive business growth.
- You will be responsible for managing the entire sales process, from lead generation to closing deals. This may include creating sales opportunities, negotiating, managing the onboarding process for new clients and taking referrals to create new business ideas
- Build sales lead through referrals and cold calling to generate sales (monthly target/revenue-oriented)
- Collaborate with the Sales and Marketing team to plan and oversee new marketing initiatives
We are a fast-growing startup based in Gurgaon, and have just raised our Pre Series A! We are happy to offer the right compensation, the right ESOPs, and the right freedom and autonomy to the right candidate!
We are looking for a Senior Backend Developer to take our product to the next level.
* Development with NodeJS and front-end languages/frameworks (jQuery, ReactJS/AngularJS, CSS3, HTML5)
* 4+ years of SQL experience (MySQL preferred)
* Experience developing RESTful Web Services, Web APIs, and micro-services.
* Integrating with a third-party system via RESTful APIs.
* 4+ years of solid experience with SQL and NoSQL-based solutions.
* Experience with AWS deployments.
* Troubleshoot and resolve issues in production and non-production environments.
* Ability to write clean, modular, reusable code (using design patterns) and experience with a unit-test-driven approach to development.
* Familiarity with Elasticsearch is an advantage
* Experience with Redis is an advantage


• Design and build scalable REST API’s and integrate third party API’s
• While you focus on one stack, you will also work on multiple stacks - Backend, Frontend, Databases, Infra, etc.
• Unifying data structures across multiple internal built systems to ensure continuity and enhancements of functionality
• Implement scalable, robust and highly available solutions
• Identify and/or question problems/issues and have the ability to scope out a solution with clean modular code
• Participate in Sprint Planning activities - sizing, estimations and assessments
• Conduct peer to peer code reviews and write unit test cases along with your code
• Work with the QA team to ensure that your code is always delivered on time and matching the criteria of all stories
• Show demoes of the features and functionality you have developed.
Technical and General Skills we expect you to have;
• Quick learner, good at math and problem solving skills
• Strong in communication - verbal and written
• Fair working knowledge of design patterns
• Good in Data Structures and writing algorithms
• Experience working on MVC frameworks
• 1+ year of experience in writing code in either Java, Python, Ruby or JavaScript
• Other tech skills that we’d like you to have knowledge about: Relation DB’s, Git, Using an IDE, writing unit test cases
• Bachelors or Master Degree - Computer Science is a plus, but not required
• Willing to work and keep up in a fast-paced startup
• Be open-minded and learn from your peers
• Have fun in a collaborative work environment

Looking for a Application Engineer - Fullstack.
Job type – Full time employment
Job location – Pune
Work schedule – Monday to Friday, 10am to 7pm
Minimum qualification – Graduate.
Years of experience – 3 to 8 years
No of position - 3
Reporting to – Technical Architect
Travel opportunities - On need basis within/outside India. Candidate should have valid passport
Roles and responsibilities:
- Work across the stack from a code commit to running it in production, with the end goal of delivering the best possible experience for the user
- Design, develop and test features from inception to rollout
- Write high quality code that is scalable, testable, maintainable and reliable
- Independently own and drive new features from scratch
- Work in an Agile environment and facilitate agile practices
- Champion best practices and cross-functional skill development
- Mentor and guide junior team members
- Cultivate talent and bring out the best in your team members
- Continuously improve by working on and providing feedback
Mandatory Skills.
- Experience working with NodeJS on the backend and ReactJS on the frontend
- Strong knowledge of creating scalable REST APIs
- Some experience with alternative protocols like GraphQL, GRPC, etc is preferred
- Experience with Typed programming languages like TypeScript or Flow is preferred
- Experience with frameworks like ExpressJS, NestJS, Redux, Redux Saga, Storybook etc is preferred
- Practices TDD
- Experience writing test automation
- Working experience with databases like MongoDB, Redis and Relational databases
- Strong understanding of Object Oriented Programming and/or Functional Programming concepts
- Experience with setting up and maintaining CI/CD pipelines
- Strong understanding of containerization technologies like Docker
- Experience practicing Agile software development methods is preferred.


