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
We are looking for "Salesforce Developer" for Reputed Client @ Coimbatore Permanent Role.
• Experience: 3-5 Yrs
• Salesforce Developer will work independently and in a team environment to build CRM solutions which integrate with various other systems.
• This Person will build Visual-force, APEX, and Lightning Components. And should have experience working with Salesforce Data.
• Building new (and maintaining existing) APEX, Visual force, and Lightning solutions.
• Participate in various sprint meetings, assist in the creation and upkeep of user stories.
• Communicate with stakeholders and users about changes or requirements.
• Should have 3 to 5 years of experience with Salesforce Sales and Service Clouds.
• Proficiency in Salesforce APEX, Visual force, and Lightning development.
• Knowledge of the Salesforce data structure, and the ability to use various tools for data migrations.
• Salesforce Developer certifications is an added advantage.
• Excellent interpersonal skills, as well as excellent communication skills, verbal and written to both technical and non-technical audiences
• Ability to work independently and as part of a team
• Professional, positive, customer oriented and flexible approach to interactions with customers in groups

Roles & Responsibilities :
- Develop and implement various tests for software applications.
- Evaluate designs and ensure compliance to business requirements.
- Prepare and update technical documents and develop Dot NET processes for various systems.
- Develop and perform tests on various software applications.
- Analyze architecture design and provide consultation to Dot net teams.
- Provide technical support and design enhancement for various applications.
- Analyze systems and develop solutions for the same.
- Experience in writing web applications using ASP.net MVC 4.0/4.5, C#, Entity Framework, SQL Server 2008/12
- Ability to write SQL queries and store procedures is required.
- Must be able to use JQuery to work on the user interface.
- Entity Framework as the data layer must be able to be used.
- Bootstrap, AngularJS, and Web API knowledge are advantages as well as experience with Javascript, AJAX, and JQuery.
- Solid understanding of relational database fundamentals in SQL Server 2008, developing stored procedures, and simple/complex SQL queries.
- Develop architecture documents for various applications.
- Coordinate with customers and analyze all user requirements.
- Analyze technical documents and determine problems in Dot NET application and provide consultation for resolution.
Skills Required:
- ASP.NET, VB.Net, C#, MySQL, SQL, JavaScript, Web services, and MVC
- Team Handling
- Good in documentation and preparation of reports
We have opening for Security Analyst/ Sr. Security Analyst for Wipro for Pune.
Must have worked on SAST, DAST tools. Should be able to analyze the root cause of the vulnerable code and suggest the remediation. Should be aware of secure coding practice, S-SDLC (Secure SDLC).
Notice period: 30 days
Exp:5+ years
Minimum 2 yrs experience required in SAST, DAST tools.
Thanking You,
Quess Corp
Expected Start Date: 10/9/2021
About UserIQ:
UserIQ offers a Customer Success Platform that empowers software companies to deliver a better experience to their customers whether that consists of high-touch engagement or tech touch interactions within the application. As a result, customers can effectively scale onboarding, increase feature usage, accelerate time-to-value, reduce churn and ultimately drive more revenue throughout the customer journey.
The best companies are built one customer at a time and those customers grow by making each user interaction meaningful. UserIQ takes this approach very seriously and works with Customer Success leaders who are also passionate about maximizing success at every user moment.
Requirements:
- 3-5 years experience in automation testing as SDET or similar role.
- Strong in UI, API automation using Cypress(preferred).
- Strong knowledge in any programming languages - JavaScript(preferred), Python, Java.
- Strong in automation framework development(must)
- Experience with Continuous Integration (CI) tools such as Github Actions, Jenkins.
- Experience with distributed source control systems such as Git.
- Strong in Database concepts, noSQL and writing SQL queries
- Strong in API testing using Postman
- Familiarity in performance testing using Jmeter or similar tools a plus.
- Strong analytical and debugging skills with attention to details.
- Experience in early stage tech startups is an added plus.
What's it like to work here?
As a SDET at UserIQ, you'll test and automate user scenarios of the UserIQ products & will get opportunities to work on:
- Automation: Cypress,Javascript
- CI/CD: Github, Github actions, Terraform
- Tools: Postman, TestRail, Postico, VScode, Android Studio, Xcode
Who should apply for this post?
- You are passionate about testing and finding edge cases.
- You are hands on coder with strong problem-solving abilities, logical
- thinking, and a logical inclination. You are enthusiastic about programming and
- delivering well-designed, scalable code.
- You have good understanding on programming concepts such as OOPs, Design Patterns,
- algorithms, data structures, networking, and so on, and are not rigid with respect
- to choice of technology and are open to adopting the right technology for the task at hand.
- flexible to work in US shift
• Develop and maintain strategic long term trusting relationships with high volume customers
to accomplish organic growth.
• Communicate company products and services via Calling and E-mail and also build
relationships in order to uncover prospect needs.
• Document and update CRM with daily activities as required.
• Achieve weekly and monthly goals.
• Be a self starter and pro-active; identify and act on opportunities for improvement.
• Ensure reporting and communications is frequent and bi-diectional.
• Remain knowledgeable about all organization’s products and services to facilitate sales
efforts.
• Completing input numbers on daily basis and taking up revenue responsibility.
• To research and analyze the customer’s requirements and present bestsolutions.
• Keep abreast with Extramarks latest offerings and best practices.
• Research key customer wants and needs.
We are looking for immediate to 15days of notice period
- Demonstrable experience as a Robotic Process Automation Developer using Robotic
technologies, particularly with UiPath. - Act as a Subject Matter Expert with Robotic Process Automation Development and
technologies, especially around UiPath. - Should have Advanced Developer certification from UiPath.
- Strong Customer-facing experience.
- Command on UiPath RE Framework.
- Strong Software Development Skills in Automation Software.
- Experience in working with .NET Framework and customization.
2) We are also looking at someone who has had experience scaling startups at seed/series-A stage to Series C/D and understand how a startup org scales up and the challenges/hustle associated with the same.
3) Tech hiring experience is a definite +++ and we would want this person to stand out in terms of the diversity of roles they've hired for in the past and the companies they have worked for.

Ideal Candidate Profile
- Strong grasp of computer science fundamentals and excellent problem-solving skills.
- Good understanding of software engineering practices, Data Structures & Algorithms.
- Solid programming skills in Java/Kotlin.
- Good communication skills.
- Strong sense of ownership and accountability.
- Experience in Reactive programming, Asynchronous programming and Unit Testing will be an added advantage.
- 6-10 years of experience in product driven organization.




