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
• Bachelor's degree in Interior Design or a related field.
• 1 to 4 years of proven experience in interior design, with a focus on commercial or residential projects.
• Proficient in AutoCAD, Adobe Creative Suite, and other relevant design software.
• Strong knowledge of materials, finishes, and furniture procurement.
• Excellent communication and interpersonal skills.
• Ability to lead and collaborate within a team environment.
• Project management skills, including the ability to manage timelines and budgets effectively.
• If you meet the above qualifications and are passionate about creating innovative and functional interior spaces, we invite you to apply for the Senior Interior Designer position. Please submit your resume, portfolio, and a cover letter detailing your relevant experience and design philosophy.
We are looking for Experienced Flutter Developers with Strong knowledge of the Flutter framework, Background Services, Third-party libraries, Rest API.
The Flutter Mobile Developer will create multi-platform apps for iOS and Android using Google's new Flutter development framework.
Key Responsibilities:
- At least 2 yrs. of Flutter development experience are mandatory.
- Experience developing with Dart, whether with Flutter or for the web, is required.
- Deep experience contributing to and managing high-scale production mobile apps is desired.
- Be proficient in using version control and continuous integration, with tools such as Git and Bitbucket.
- Experience with third-party libraries and API implementation.
What we require:
- Able to self-manage and learn on his own.
- Can build Android and/or iOS apps using Flutter
- Proven working experience in Mobile app development
- Working knowledge of the general mobile landscape, architectures, trends, and emerging technologies
- Solid understanding of the full mobile development life cycle
- Experience working in an agile development process.
- Good communication skills.
- Excellent knowledge of core Java and Flutter framework.
- Familiar with Android Studio.
- Good command over code standards and code and query optimization.
- Able to use third-party libraries if required.
- Ready to take on new challenges and problems too.
Purpose of Job:
We are looking for someone who can manage the daily activities of the
team responsible for the design, implementation, maintenance and
support of data warehouse systems and related data marts. Oversees
data design and the creation of database architecture.
Job Responsibilities:
7+ years of industry experience and 2+ years of experience
managing a team
Exceptional knowledge in designing modern Databases such as
MySQL, Postgres, Redshift, Snowflake, Hive or Presto. Has good experience working in agile based projects. Has experience in understanding & converting BRD’s into
technical designs. Work with management to provide effort, estimation and
timelines. Work closely with IT, Business teams and other internal
stakeholders to resolve business queries within the defined SLA. Exceptional knowledge in SQL and in designing tables, databases, partitions and query optimization. Has good experience in designing ETL solutions in tools such as
Talend/AWS Glue/EMR. Have at least 3 years of experience working on AWS Cloud
Hands-on in monitoring ETL jobs and performing health check to
ensure data quality
Have good exposure with AWS Services such as RDS, Aurora, S3, Lambda, Glue, EMR, Step Functions etc. Design quality assurance tests for ensuring data integrity and
quality
Good to have Python and big data knowledge
Qualifications:
At least a bachelor’s degree in Science, Engineering, Applied
Mathematics. Masters in Computer Science or related field in preferred. Other Requirements: Leadership skills, excellent communication skills, ability to own tasks
Sales Executive - Innotrail Technologies Pvt Ltd
We're seeking a dynamic Sales Executive to market and sell subscriptions for our cutting-edge EdTech platform, MentoMind, specializing in SAT preparation. The role involves visiting potential clients, including individual tutors and coaching center owners, to introduce and demonstrate our platform. Successful candidates will facilitate a smooth onboarding process for new customers and engage in outreach activities such as cold emailing, LinkedIn networking, and cold calling.
Roles & Responsibilities:
- Market and sell MentoMind subscriptions.
- Conduct product demos.
- Ensure smooth customer onboarding.
- Outreach via cold emailing, LinkedIn, and cold calling.
Perks & Benefits:
- Commission on every sale.
- Flexible job timings.
Join us to transform SAT preparation and grow your career with Innotrail Technologies!
Key Skills - Java , Hibernate , Spring , Maven, MVC Framework ,Spring Boot , J2EE
- 1-9 years of overall working experience in the software environment.
- Minimum 3 years of experience in Agile Software Development.
- NET technologies - .NET 5, .NET Core, C#, Web API, Angular, Typescript, Azure and MS SQL.
- Coding and designing skills.
- Knowledge of database, SQL Queries, procedures & functions is must.
- Good knowledge of cloud concepts and CI/CD.
- Ability to assimilate technical and functional solutions.
- Ability to do code review and deliver quality.
- Knowledge of unit testing with mock.
- Cloud experience.
- Experience using TFS/GIT source control.
- Containerization (Docker) plus orchestration (Kubernetes or OpenShift) are good to have.
- Good written and spoken English.
- Excellent service & industry leading solutions development.
About [24]7.ai
[24]7.ai uses artificial intelligence, human insight, and deep vertical expertise to produce personalized, consistent, and satisfying customer experiences. The company's advanced conversational AI platform, combined with more than 20 years of contact center operational expertise, empowers the world's largest and most recognizable brands to deliver natural, frictionless conversations across all digital and voice channels. For more information, visit http://www.247.ai/">http://www.247.ai.
The Marketing Web Developer is part of [24]7.ai’s Marketing team. You will need to work collaboratively with local team members and others located in Bangalore and Toronto. This resource will be fully responsible for developing and maintaining the 247.ai website so they should be skilled in Drupal 9, HTML5, CSS, JS, Bootstrap, SASS, and possess hands-on experience with Drupal front-end theming, Integration, page development.
Areas of Responsibility
- Technical consultation and development of new pages / templates / modules in Acquia Drupal.
- Add/modify content, scripts, code, UI, modules, media etc. as per [24]7.ai Marketing and Acquia Web guidelines.
- Maintaining database, file system, dev, staging and production environments on Acquia Cloud as per [24]7.ai Marketing & Acquia guidelines.
- Check and apply Drupal security updates/patches as and when available on Drupal.org.
- Support [24]7.ai Web projects and go live/cutover activities.
- Liaise with [24]7.ai Marketing and our Acquia TAM to consult/fix issues that impact the website, and to ensure performance and availability.
- Skilled with SQL database management – from SQL to table manipulation.
- Manages all technical aspects of the CMS and Acquia development environments.
- Performance tuning, broken link fixes and implement SEO technical audits as provided by our SEO vendor.
- Uptime monitoring.
- Project ticketing (for internal tracking).
- 24x7 Emergency support.
Key Competencies
- Full-stack Drupal developer with expertise on Drupal 8 and 9 is required
- 3+ years of experience planning and implementing web projects
- Bachelor and Master Engineering degrees
- Languages: PHP, C, C#, Java, HTML5, CSS, SaaS, JavaScript
- Databases: MYSQL, Oracle
- Operating System: Linux/Abuntu, Windows
- Libraries: JQuery, Angular JS, Bootstrap
- Server side technologies: J2EE, ASP.net, JSP, Apache Solr, Apache
- Source control: SVN, Git, Github
- Must have excellent attention to detail and create clean, organized code as well as document modifications.
- Excellent problem solving and debugging skills.
- Knowledge of web performance optimization techniques.
- Knowledge of web vulnerability prevention methods.
- Experience working with cross-functional teams and receiving feedback from all levels. Work hours are shifted to overlap 2-3 hours with US Pacific Time zone as needed.
- Excellent written and verbal communication skills required.
- Ability to work within a rapidly changing environment, multi-task and prioritize.
- Must be innovative, self-driven, motivated, organized and detail-oriented
- Exhibit a high level of individual initiative.
Job Description
We are looking to hire a full stack Magento 2 developer with 3 to 6 years of experience with following skills
- Should have good project experience in Magento 2 as a full stack developer.
- Should have working knowledge in Magento PWA
- Should know how to setup and install Magento in AWS preferably.
- Should know how to build and deploy Magento source code.
DevOps Consultant!! MERN Stack Project Manager – Systems (Enterprise or Solutions) Architect needed!
Hello superstar,
I appreciate you taking time to read this. I have posted a job for developers to work on a start-up, the link is ......
I would need someone with DevOps experience, to ensure that the project is undertaken with the highest standards possible. I have had many experiences where ‘completed’ software after years of development was filled with bugs and it would be more cost-effective to start from scratch than to attempt to find and correct all the bugs.
I have attempted to learn as much as possible, but I now have an opportunity and it would better serve the venture to have someone handle the management of the project to ensure that;
- We choose the most appropriate technology
- We choose competent developers in those technologies
- The architecture and data modeling are clearly defined in a ‘blueprint’ plan
- A DevOps environment and processes are set up and the developers understand what is required
- Proper tests are carried out to ensure everything works as intended
- There are processes for testers to follow and competent testers are selected to follow them
- Accessibility, localization, and internationalization are planned ahead of time
- Security, scalability, and other future probabilities that I may not even be aware of are considered and planned ahead of time
- Documentation and code reviews, refactoring and other quality assurance processes are undertaken
- Working software is produced and systems that enable new developers or teams of people to easily take over and/or contribute new modules or updates in a controlled and organized fashion
- Cost estimates or budgets/projections or use of SaaS, hosting and other 3rd party services and applications
I am more concerned with a professional and world-class organizational system than with any particular type of software been produced as the strong foundation will enable anything to be creating with efficacy and precision.
Again, thank you for reading this, please reply with the word “superstar” anywhere in the second line of your response. I look forward to hearing from you.
Warm wishes DevOps Evangelist,









