Job Role: Oracle PL/SQL Developer Location: Bangalore Experience: 0-1 Years Education: B.E/B.Tech/M.E/M.Tech/BCA Responsibilities : A day in the life of an Infoscion • As part of the Infosys delivery team, your primary role would be to ensure effective Design, Development, Validation and Support activities, to assure that our clients are satisfied with the high levels of service in the technology domain. • You will gather the requirements and specifications to understand the client requirements in a detailed manner and translate the same into system requirements. • You will play a key role in the overall estimation of work requirements to provide the right information on project estimations to Technology Leads and Project Managers. • You would be a key contributor to building efficient programs/ systems and if you think you fit right in to help our clients navigate their next in their digital transformation journey, this is the place for you! If you think you fit right in to help our clients navigate their next in their digital transformation journey, this is the place for you Educational Requirements Bachelor of Engineering Service Line Application Development and Maintenance. Additional Responsibilities: • Knowledge of design principles and fundamentals of architecture • Understanding of performance engineering • Knowledge of quality processes and estimation techniques • Basic understanding of project domain • Ability to translate functional / nonfunctional requirements to systems requirements • Ability to design and code complex programs • Ability to write test cases and scenarios based on the specifications • Good understanding of SDLC and agile methodologies • Awareness of latest technologies and trends • Logical thinking and problem solving skills along Technical and Professional Requirements: • Primary skills:Oracle Technical->Oracle PL/SQL Preferred Skills: Oracle Technical->Oracle PL/SQL Apply through the link:https://career.infosys.com/jobdesc?jobReferenceCode=INFSYS-EXTERNAL-155273-2&sourceId=4003

SQL (Structured Query Language) is a programming language used to manage and manipulate relational databases. It provides a standardized way to communicate with databases, enabling users to create, modify, and retrieve data efficiently. SQL is widely used in various applications, from small-scale projects to large enterprise systems. SQL can be classified into several types based on their functionality and purpose. Here are some common types of SQL along with examples and their typical uses: Data Definition Language (DDL): DDL statements are used to define and manage the structure of the database. They allow you to create, modify, and delete database objects such as tables, views, indexes, and constraints. Examples of DDL statements include CREATE, ALTER, and DROP. Example: sqlCopy code CREATE TABLE employees ( id INT PRIMARY KEY, name VARCHAR(50), age INT ); Data Manipulation Language (DML): DML statements are used to manipulate data within the database. They allow you to insert, update, and delete records in the tables. Examples of DML statements include SELECT, INSERT, UPDATE, and DELETE. Example: sqlCopy code INSERT INTO employees (id, name, age) VALUES (1, 'John Doe', 30); Data Query Language (DQL): DQL statements are used to retrieve data from the database. The most common DQL statement is SELECT, which allows you to query and fetch data based on specified criteria. Example: sqlCopy code SELECT name, age FROM employees WHERE age > 25; Data Control Language (DCL): DCL statements are used to control access and permissions within the database. They allow you to grant or revoke privileges to users and manage security aspects of the database. Examples of DCL statements include GRANT and REVOKE. Example: sqlCopy code GRANT SELECT, INSERT ON employees TO user1; Transaction Control Language (TCL): TCL statements are used to manage transactions within the database. They allow you to control the atomicity, consistency, isolation, and durability (ACID) properties of transactions. Examples of TCL statements include COMMIT, ROLLBACK, and SAVEPOINT. Example: sqlCopy code BEGIN TRANSACTION; -- Perform database operationsCOMMIT; These are just a few types of SQL statements. SQL provides a comprehensive set of functionalities for working with relational databases, allowing developers and data analysts to perform a wide range of tasks, including database creation, data manipulation, data retrieval, and database administration. It's important to note that while SQL is widely used and supported by many database management systems (such as MySQL, Oracle, Microsoft SQL Server, and PostgreSQL), there might be some variations and specific features unique to each system. What is SQL? Answer: SQL (Structured Query Language) is a programming language used to manage and manipulate relational databases. It provides a standardized way to communicate with databases, allowing users to create, modify, and retrieve data efficiently. 2.What are the different types of SQL joins? Answer: SQL joins are used to combine data from multiple tables based on related columns. The main types of joins are: INNER JOIN: Returns rows that have matching values in both tables. LEFT JOIN: Returns all rows from the left table and matching rows from the right table. RIGHT JOIN: Returns all rows from the right table and matching rows from the left table. FULL JOIN: Returns all rows from both tables, combining the results of left and right joins. 3.What is the difference between UNION and UNION ALL? Answer: UNION and UNION ALL are used to combine the results of multiple SELECT statements. UNION: Combines the results of multiple SELECT statements and removes duplicate rows. UNION ALL: Combines the results of multiple SELECT statements without removing duplicate rows. 4.Explain the difference between a primary key and a foreign key. Answer: Primary key: A primary key is a unique identifier for each row in a table. It ensures that each row can be uniquely identified and provides a way to enforce data integrity. Foreign key: A foreign key is a column or a set of columns in a table that refers to the primary key of another table. It establishes a relationship between two tables and enforces referential integrity. 5.What is normalization in the context of databases? Answer: Normalization is the process of organizing data in a database to reduce redundancy and improve data integrity. It involves breaking down large tables into smaller, more manageable tables and defining relationships between them. The goal of normalization is to eliminate data anomalies and ensure efficient data storage and retrieval. What is the difference between a clustered index and a non-clustered index? Answer: Clustered index: A clustered index determines the physical order of data in a table. Each table can have only one clustered index, and it significantly affects the way data is stored and retrieved. Non-clustered index: A non-clustered index is a separate structure that contains a copy of the indexed columns and a pointer to the actual data. A table can have multiple non-clustered indexes, and they improve query performance by allowing faster data retrieval based on the indexed columns. 6.What are stored procedures? Answer: Stored procedures are named sets of SQL statements that are stored in a database. They allow you to group multiple SQL statements into a single unit and execute them as a single operation. Stored procedures can be parameterized, allowing for flexibility and reusability. 7.Explain the ACID properties of transactions. Answer: ACID stands for Atomicity, Consistency, Isolation, and Durability, which are the properties that ensure reliable and consistent database transactions. Atomicity: Transactions are treated as atomic units, meaning that they are either completed in their entirety or not at all. Consistency: Transactions bring the database from one consistent state to another. The data must satisfy all defined rules and constraints. Isolation: Each transaction is isolated from other transactions, ensuring that concurrent transactions do not interfere with each other. Durability: Once a transaction is committed, its changes are permanent and survive any subsequent failures. These are just a few examples of SQL interview questions. The scope of SQL is vast, so it's important to study and practice various aspects of SQL to be well-prepared for interviews.

Job role : Junior Research Fellow Post available : 75 Location : Pune Tenure Period: 2 years Qualification:Diploma/ BE/ B.Tech (2020 – 2022) Written test date: 01-06-2023 Last Date to apply : 30th May 2023 Pay Scale: INR Rs. 12,000/- PM for Graduate Apprentices, Rs. 11,000/- PM for Diploma Apprentices. Eligibility Criteria for DRDO – ARDE Recruitment 2023 Graduate Apprentices: Candidates must have First Class Engineering Degree (full time course) in the respective discipline with at least 6.3 CGPA from a recognised Indian University/Institute Diploma Apprentices: Candidates must have First Class Diploma in Engineering obtained from State Board of Technical Education/recognised Indian University (full time course) in the respective discipline with 60% marks Selection Process For DRDO – ARDE Recruitment 2023: Selection will be based on the marks obtained in the respective discipline qualifying examination. The final merit list would be prepared according to categories General/ SC / ST / OBC/PwD on the basis of marks obtained by the candidates in written examination. How To Apply for DRDO – ARDE Recruitment 2023? Candidates must apply through online mode Starting Date for Online Submission of Application Form: 20-05-2023 Last Date for Submission of Application Form: 30-05-2023 Written test date: 01-06-2023 Apply through the link :

Job role : Software Engineer Location : Bangalore Experience: 1.5 – 3 years Qualification : BE/ B.Tech/ B.Sc – Computer Science/ Information Technology. Recruitment 2023: Bachelor of Science in Information Technology or Bachelor of Science in Computer Science or equivalent 1.5 to 3 years experience working as Salesforce Developer with the following Salesforce Certification is a big plus : Administrator Platform Developer I – II Javascript Developer Have a great spoken/written communication skills Proficient in writing technical documentation Proficient in in agile software development methodology Experience in version control software Experience using Jira is a plus Experienced using Confluence is a plus Experience with Git is a plus Experience with Continuous Integration tool is a plus. Job Responsibilities:- Working alongside team lead and business analyst, create/update process to fulfill business needs Development Knowledge. Working alongside QA resource to ensure process correctness and reliability Documenting and implementing business process in Salesforce Implementing and maintaining security and integration of existing business process in Salesforce Implementing unit test for business process Troubleshooting and fixing bugs Write technical documents for knowledge sharing to other team members. Apply through the link:https://flexerasoftware.wd1.myworkdayjobs.com/en-US/FlexeraSoftware/job/Software-Engineer_13205

Job role : Internship Location : Noida Duration : 3months Stipend : 5000/- month Deadline to apply : 22June 2023 Roles & Responsibilities : 1. Collect quantitative and qualitative data from marketing campaigns 2. Perform market analysis and research as per requirement 3. Support the marketing team in daily administrative tasks 4. Assist in marketing and advertising promotional activities (e.g., social media, direct mail, and web) 5. Prepare analytical weekly presentations 6. Help in distributing marketing materials 7. Help to organize marketing events 8. Handle questions, inquiries, and complaints on social platforms 9. Applicants should be currently in Post Graduation Program in Management, English or Mass communication. Duration The HCL Technologies internship will be for a period of 3 months. Perks Stipend: Rs.5,000 / month Certificate & Letter of Recommendation Deadline to Apply The last date of applying for this internship is 22nd June, 2023. Apply through the link:https://internshala.com/internship/detail/marketing-internship-in-noida-at-hcl-technologies168439395

Jobe role : School of IT Infrastructure Management - 2023 Location : Pan India Qualification: CS/IT/Electronics (2021-23) Deadline : 31 May 2023 Job Description Eligibility criteria : 10th Standard: 50% 12th Standard: 50% Diploma – 60% Year of Passing: 2021, 2022, 2023 Qualification : Diploma in Computer Science / Information Technology / Electronics / Telecommunication / Computer Engineering / Electronics and Communication / Computer Technology / Computer Science and Technology / Electrical and Electronics Engineering: 60% and above. Other Criteria : Maximum of 3 years of education gap, if any, is allowed between 10th and commencement of Diploma. No Gaps are allowed in Diploma. Diploma should be completed within 3 years from the start of Diploma. Only fulltime Diploma courses are permitted. No Part time or Correspondences or Distance learning education in Diploma program. Mandatory to have studied Core Mathematics as one subject in Diploma. Business Maths & Applied Maths will NOT be considered as Core Mathematics in Diploma. Open school or distance education is allowed in 10th & 12th or both. Maximum of one backlog till the assessment process is allowed. Candidates are expected to clear the backlogs along with the 6th semester. Should be an Indian Citizen or should hold a PIO or OCI card in the event of holding a passport of any other country. Bhutan and Nepal Nationals need to submit their citizenship certificate. Candidates who have participated in any selection process held by Wipro in the last three months are not eligible. Candidate should be 18 years or above at the time of onboarding. Apply through the link:https://app.joinsuperset.com/join/#/signup/student/jobprofiles/f2a20a8a-fae0-4281-9c52-19317da99bb1

Job role : Software Developer QA Trainee Experience: Freshers (0 – 1 Year) Job Location: Hyderabad Qualification: B.Tech/ M.Tech (CSE or IT) 2020 or 2021 passed out. Job Responsibilities: Understanding requirements/design documents. Prepare and execute Test Cases and Test Scripts to detect problems and ensure the quality and success of the software Conduct a variety of quality- control tests and analysis to ensure that software meets or exceeds specified standards and end-user requirements Design and execute Automation Test Scripts Execute SQL commands to manage and verify data. Bug Reporting and Defect Management. Coordinate Test Environment Configurations and Maintenance. Ability to work creatively and analytically in a problem-solving environment Qualification for Quest Recruitment Drive: Education Qualification: B.Tech/ M.Tech (CSE or IT) Passed Out: 2020 or 2021 Percentage: 70 and Above in academics Experience: 0 – 1 years experience Skills: Understanding requirements/design documents. Prepare and execute Test Cases and Test Scripts to detect problems and ensure the quality and success of the software Conduct a variety of quality- control tests and analysis to ensure that software meets or exceeds specified standards and end-user requirements Design and execute Automation Test Scripts Execute SQL commands to manage and verify data. Bug Reporting and Defect Management. Coordinate Test Environment Configurations and Maintenance. Ability to work creatively and analytically in a problem-solving environment Apply through the link:https://careers-quest.icims.com/jobs/11048/job?utm_source=indeed_integration&iis=Job+Board&iisn=Inde

Job role : Software developer Location : Hyderabad Skills : C++,SQL,.NET Qualification : B.tech/M.Tech CS or Mech Responsibilities : 1. Understand customer requirements 2. Estimate the efforts 3. Work with Scrum Team 4. Design & Development Educational Qualifications B.tech/M.Tech CS or Mech Overview Required to have good technical skills in C++, C#. Required to have good communication skills, analytical and logical thinking Skills Required C++ .NET SQL Apply through the link : https://hexagon.com/company/divisions/asset-lifecycle-intelligence

Job role : Internship Location : Bangalore Duration : Minimum 4months Skills : Have knowledge of SQL/NoSQL and Express.Js Who Should apply? Apply only If you 1. Think you are at least 8 on 10 in Node.js 2. Have knowledge of SQL/NoSQL and Express.Js 3. Are available for a minimum of 4 months for this internship 4. Are super enthusiastic about building something that adds immense value to the lives of at least 10Mn people 5. Have immense hunger to learn, grow and prove yourself. Shortlisting Criteria If you love challenges and want to prove your knowledge then take up coding test by clicking on link Below: https://coderbyte.com/sl-candidate?promo=openinapp-zrpv1:nodejs-assessment-0as1xnhc28 We respect your time and are in no way doubting your skills, but that’s how you would like to hire someone in your team, right? Apply through the link:https://listed.freshteam.com/jobs/mf7NPxhCHcsq/intern-node-js-developer-on-site?ft_source=6000312750

Job Role: Software Automation Engineer Location: Work from home Experience: 0-2 years Qualification: BE/BTech/ME/MTech/BCA/BSc/MCA/MSc Job Description: Candidate willing to actively contribute in the day-to-day planning, design, execution, and reporting of manual test cases and automated test scripts Follows software engineering principles in the development of automation, manual test cases, software tools, and SQL Quick learner, understand and apply test-driven design concepts to test and debug automated solutions or manual test executions and software utilities developed by self and others Experience and desire to work in a Global delivery environment Proficient in Speaking, Reading and Writing English Should be able to participate in meetings, communicate thoughts clearly/concisely and push back whenever required. Qualification: Expertise in programming languages such as Java, JavaScript, etc. Expertise in test automation tools such as Selenium or similar. Excellent in software testing fundamentals, concepts, and processes. Excellent skills in object-oriented programming. Knowledge of automation frameworks for UI Automation. Must have strong coordination, communication, reporting, and analytical skills. Ability to work in a team with a diverse/ multiple stakeholder environment. Desire to work in a Global delivery environment. Must be passionate about software quality. Apply through the link: https://hire.auzmor.com/atc/careers/4bb152268f4a41fb9e27630a17b45e34

Job role : Software Development Engineer Location : Bangalore Experience : 6months to 2years Qualification : B.E/B.TECH/M.TECH Skills : C,C++,Python,Perl Requirements: Experience ranging from 6 months - 2 years in software development & testing skills. Strong Software Engineering skills including design, programming (using C, C++), scripting (Python preferred, Perl) Excellent debugging skills Strong debugging, critical thinking, analytical and problem-solving skills Thrive in a collaborative environment and can clearly communicate while confidently developing software in highly cross functional projects. Obsessively passionate and inquisitive, and seek to solve everyday problems in innovative ways. Good to have either of the following skills Embedded Systems/ Embedded RTOS skills. Virtual Prototype Model development using C++/SystemC is preferred 3gpp/IEEE based Layer 1 and Layer 2 protocol stack software, integration experience Qualification : Bachelors/Master Degree in Computer Science, Electronics & communication, Electrical Engineering, or equivalent experience Apply through the link:https://jobs.apple.com/en-us/details/200479641/software-development-engineer

Job role : Software Engineering Location : Hyderabad Experience : 1.5-2.5 years in business analysis Qualification : B.TECH Position Summary Analyst – Level 3 A ETL tester with a good understanding of the testing lifecycle with a background of data projects. Work you’ll do • Responsible for planning, developing, and coordinating testing activities including Test Plan creation, Test Case creation, debugging, execution, test analysis. • Responsible for the execution of test scenarios in support of the test team. • Familiarize themselves with the business functionality and technology used for assigned applications (under test). • Utilize ESG QA testing tools, methodologies, and processes. • Work closely with on-site team towards successful test phases. • Encourage collaborative efforts and camaraderie with other Release Stream team areas. • Ensure the quality and low bug rates of code released into production. • Responsible for successful execution and alerting team leads and managers of obstacles, issues and risks. • Able discuss status of all open issues facing the test team and describes actions taken to mitigate such issues • Responsible for coordinating/engaging build movements to the QA environment as directed by Team Lead. Qualifications Required: • Computer Science University degree or equivalent work experience • At least 1.5-2.5 years’ experience in business analysis, requirements management and projects relating to data • Demonstrates a working understanding of planning, developing, and coordinating • testing activities including Test Plan creation, Test Case creation, debugging, execution, test analysis. • Demonstrate an understanding on the estimation techniques and QA plan • Demonstrates analytical skills in assessing user, functional and technical requirements • Demonstrates a working understanding of functional testing techniques and strategies. • Demonstrates a strong understanding of web testing techniques and web testing strategies. • Demonstrates a working understanding of Cloud(Azure) based services • Demonstrates a working understanding of test analysis and design. • Demonstrates a working understanding of analyzing test results and the creation of appropriate test metrics. Apply through the link : https://usijobs.deloitte.com/careersUSI/JobDetail/USI-EH24-MF-ITS-Canada-ETL-QA-Analyst/147771