5 Sql Concepts Jobs

Backdrop AVIZVA is a Healthcare Technology Organization that harnesses technology to simplify, accelerate, & optimize the way healthcare enterprises deliver care. Established in 2011, we have served as strategic enablers for healthcare enterprises, helping them enhance their overall care delivery. With over 14 years of expertise, we have engineered more than 150 tailored products for leading Medical Health Plans, Dental and Vision Plan Providers, PBMs, Medicare Plan Providers, TPAs, and more. Overview Of The Role As an Engineer - Test Automation, your key responsibilities will include utilizing automation tools to manage test cases, execute comprehensive tests, and assess test results. Your efforts will be pivotal in enhancing software quality by identifying issues early and ensuring the system meets the highest standards of performance, reliability, and functionality. Job Responsibilities Strong experience in Java programming language to enhance and maintain automation frameworks. Analyse requirements from the specifications and document test cases according to agreed-upon standards. Engage in creating comprehensive test plans and test cases to validate software functionality. Ensure thorough test coverage by validating software functionality, performance, security, and usability through automated testing tools and frameworks, while collaborating closely with teams to resolve ambiguities. Participate in agile ceremonies such as sprint planning and daily stand-ups. Share status updates on progress, discuss challenges, and propose solutions to Senior/Lead Engineers. Provide support within the team on automation test-assigned projects. Skills & Qualifications Bachelor&aposs or Masters degree in Computer Science, Software Engineering, or a related field. 3 to 5 years of overall experience in QA testing with minimum 2+ years experience in Automation Testing. Experience in developing automated test scripts using Selenium WebDriver/Selenide for web application testing. Skilled in testing frameworks including Cucumber /Behavior-Driven Development (BDD). Strong experience in Java programming language to enhance and maintain automation frameworks. Well-versed in developing automated test scripts for API testing using tools such as Postman. Should have experience in executing automated tests using TestNG. Good understanding of STLC and excellent problem-solving skills. Familiarity with SQL concepts,CI/CD pipeline, Git lifecycle and process. Communicate effectively with team members to convey test results and address any issues. Show more Show less

Backdrop AVIZVA is a Healthcare Technology Organization that harnesses technology to simplify, accelerate, & optimize the way healthcare enterprises deliver care. Established in 2011, we have served as strategic enablers for healthcare enterprises, helping them enhance their overall care delivery. With over 14 years of expertise, we have engineered more than 150 tailored products for leading Medical Health Plans, Dental and Vision Plan Providers, PBMs, Medicare Plan Providers, TPAs, and more. Overview Of The Role As an Engineer - Test Automation, your key responsibilities will include utilizing automation tools to manage test cases, execute comprehensive tests, and assess test results. Your efforts will be pivotal in enhancing software quality by identifying issues early and ensuring the system meets the highest standards of performance, reliability, and functionality. Job Responsibilities Strong experience in Java programming language to enhance and maintain automation frameworks. Analyse requirements from the specifications and document test cases according to agreed-upon standards. Engage in creating comprehensive test plans and test cases to validate software functionality. Ensure thorough test coverage by validating software functionality, performance, security, and usability through automated testing tools and frameworks, while collaborating closely with teams to resolve ambiguities. Participate in agile ceremonies such as sprint planning and daily stand-ups. Share status updates on progress, discuss challenges, and propose solutions to Senior/Lead Engineers. Provide support within the team on automation test-assigned projects. Skills & Qualifications Bachelor&aposs or Masters degree in Computer Science, Software Engineering, or a related field. 3 to 5 years of overall experience in QA testing with minimum 2+ years experience in Automation Testing. Experience in developing automated test scripts using Selenium WebDriver/Selenide for web application testing. Skilled in testing frameworks including Cucumber /Behavior-Driven Development (BDD). Strong experience in Java programming language to enhance and maintain automation frameworks. Well-versed in developing automated test scripts for API testing using tools such as Postman. Should have experience in executing automated tests using TestNG. Good understanding of STLC and excellent problem-solving skills. Familiarity with SQL concepts,CI/CD pipeline, Git lifecycle and process. Communicate effectively with team members to convey test results and address any issues. Show more Show less

Primary Skills - Expert in BI tools like Microstrategy and Tableau with minimum 8 years of experience Secondary Skills - Able to lead a team of BI experts and provide technical solution to BI tool reporting requirements Should have Over 6+years of IT experience in Analysis, Design, Development, Implementation, Reporting, Testing and Visualization of Business Intelligence Tools. Extensive Knowledge in creating data visualizations using BI Tools Desktops and regularly publishing and presenting dashboards. Familiar with SQL Concepts - SQL tables, Views, indexes, joins, writing stored procedures and query optimization, performance tuning etc Able to generate reports using BI Tools to analyse data from multiple data sources like Oracle, SQL Server, Excel, Hive and Tera data. Good knowledge on various BI Tools functionalities like Tableau Extracts, Parameters, Trends, Hierarchies, Sets, Groups, Data Blending and joins etc Able to develop various customized charts. Work extensively with Actions, Calculations, Parameters, Background images, Maps, Trend lines, LOD functions and Table Calculations. Able to generate Context filters, Extract and Data Source filters while handling huge volume of data. Hands on building Groups, hierarchies, Sets and create detail level summary reports and Dashboard using KPI s. Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server. Handling User onboarding activities under BI tools and various servers. Able to manage User groups and access relative activities in BI Tools and tableau server. Ability to handle the data security.

At EY, you'll have the chance to build a career as unique as you are, with the global scale, support, inclusive culture, and technology to become the best version of you. And we're counting on your unique voice and perspective to help EY become even better, too. Join us and build an exceptional experience for yourself, and a better working world for all. EY-Consulting Advanced PL/SQL - Technical Consultant The opportunity We're looking for a PLSQL Technical Consultant to join the leadership group of our Consulting Team. This is a fantastic opportunity to be part of a leading firm while being instrumental in the growth of a new service offering. Your Key Responsibilities - Support client needs in Oracle application development/support using Advanced PL/SQL - Proactive with a solution-oriented mindset, ready to learn new technologies for client requirements - Working knowledge of a source code control system - Interact with senior leaders, understand their business goals, and contribute to the delivery of the workstreams Skills And Attributes For Success - SQL Concepts: Group By / Joins / Surrogate Keys / Constraints / Datatypes / Indexes - Experience in designing and developing Oracle objects such as Experience with SQL queries (Scalar subqueries, inline views, outer joins, hints, and analytic functions) - Experience of creating PL/SQL Packages, Procedures, Functions, Triggers, Views, Collections, and Exception handling for retrieving, manipulating, checking, and migrating complex datasets in Oracle - Experience in SQL tuning and optimization using explain plan and SQL trace files - Partitioning, Hints, and Indexing strategy for optimal performance - Experience in Direct Load & Conventional Load using SQL Loader - Should have a good understanding of Oracle Database Architecture - Prior consulting experience preferred To qualify for the role, you must have - Computer Science degree or equivalent - 3 to 8 years of development experience - Strong analytical and debugging skills - Good understanding of advanced PL/SQL and performance tuning - Should have a positive and learning attitude, Good Communication, Strong Analytical skills What Working At EY Offers At EY, we're dedicated to helping our clients, from startups to Fortune 500 companies, and the work we do with them is as varied as they are. You get to work with inspiring and meaningful projects. Our focus is education and coaching alongside practical experience to ensure your personal development. We value our employees, and you will be able to control your development with an individual progression plan. You will quickly grow into a responsible role with challenging and stimulating assignments. Moreover, you will be part of an interdisciplinary environment that emphasizes high quality and knowledge exchange. Plus, we offer: - Support, coaching, and feedback from some of the most engaging colleagues around - Opportunities to develop new skills and progress your career - The freedom and flexibility to handle your role in a way that's right for you EY | Building a better working world EY exists to build a better working world, helping to create long-term value for clients, people, and society and build trust in the capital markets. Enabled by data and technology, diverse EY teams in over 150 countries provide trust through assurance and help clients grow, transform, and operate. Working across assurance, consulting, law, strategy, tax, and transactions, EY teams ask better questions to find new answers for the complex issues facing our world today.,

SQL Language Proficiency: A strong understanding of Structured Query Language (SQL) is essential. Should be familiar with SQL concepts like querying, data manipulation, and data definition. Database Design and Modeling: Proficiency in designing and modeling databases is crucial. Should be able to create efficient and well-structured database schemas, tables, indexes, and relationships. Oracle & MS SQL Server: In-depth knowledge and experience working with Oracle DB & Microsoft SQL Server, including the latest versions. Familiarity with various features and components of SQL Server, such as stored procedures, triggers, functions, and views, is important. T-SQL: Thorough knowledge of Transact-SQL (T-SQL), the Oracle SQL Server implementation of SQL. Should be proficient in writing complex queries, optimizing query performance, and understanding T SQL programming constructs. Location : Hyderabad (Main), Options: - Chennai & Bangalore.