237 Complex Queries Jobs

Role & responsibilities - Strong knowledge of SQL (DDL, DML, DCL) and complex query writing (joins, subqueries etc) - Experience testing on RDBMS such as Oracle, MySQL, SQL Server, or PostgreSQL - Knowledge of ETL tools (e.g., Informatica, Talend, SSIS) and data validation techniques - Familiarity with database design concepts (schemas, keys, normalization) - Exposure to automation of database testing using tools like Python, Selenium + DB libraries or SQL automation frameworks (optional but preferred) - Understanding of performance testing at the database level (indexing, query optimization). - Excellent analytical and troubleshooting skills. - Experience in test case design, defect trackin...

Business System Analyst (I & II) at NUKG Business Solutions - Hyderabad NUKG ( www.nukg.com ) is a Business, Process & Technology consulting company with niche expertise in the area of US Benefits Administration and Data Management. NUKG's headquarters are based in NJ, USA and the Global Delivery Center is based in Hyderabad, India. JOB SUMMARY The Business Systems Analyst I is accountable for completing systems development, quality assurance, and day to day operational tasks in support of ongoing benefits administration delivery, both internally and externally to clients within their portfolio of clients/ aligned pod. The Business Systems Analyst 1 ensures that all work delivered to the cli...

Good SQL skills, writing sql queries and analyzing and modifying sql scripts Familiarity with databases, log processing and other tools for software troubleshooting Experience with scripting such as bash, python and basic commands like sed, cut, awk

Min 3 years of hands-on exp in SQL Development , Mysql, ETL Designing Database, writing stored procedures, complex and dynamic queries in SQL Creating Indexes, Views, complex Triggers, effective Functions Contact : HR Sonali - 8879984232 Required Candidate profile Troubleshooting data load, ETL and application support related issues Troubleshooting failed batch jobs Immediate Joiner Preferred Male Candidates Only

Novaya has been engaged in providing turnkey software solutions and services to clients in the US since 2013. We specialize in web and mobile healthcare solutions for Acute and ambulatory clinics. Our client is a US based Health Tech solution provider and they're on a mission to transform behavioral health through cutting-edge technology. The cloud-based SaaS platform helps care providers improve outcomes, streamline operations, and deliver better care. We're looking for a Senior SQL Server Developer to join our Hyderabad team. This role is ideal for someone who thrives in a collaborative environment, enjoys solving real-world problems, and has hands-on experience in working with Azure SQL S...

Role Overview: You will be responsible for performing joins such as INNER, LEFT, RIGHT, FULL, and CARTESIAN joins of two or more tables. Additionally, you will be expected to work with Aggregate Functions including COUNT, MIN, MAX, AVG, FIRST, LAST, and LISTAGG. Your role will involve working with Functions like LEAD, LAG, RANK, DENSE_RANK, FIRST_VALUE, LAST_VALUE, and ROW_NUMBER. You should have a good understanding of creating and maintaining Views and Materialized Views, as well as executing Hierarchical queries for data retrieval from tables with hierarchical data structures. Furthermore, you will be required to handle Complex Queries involving Nested queries, inline views, correlated su...

P1,C3,STS At least 4 to 8 years of Extensive hands on experience in PL/SQL programming, developing complex packages, Stored procedures, functions and implementing the best practices in PL/SQL programming Ability to create and maintain complex queries & fine tune the existing complex queries to improve the performance Ability to develop tech design from the functional specifications Analysis and troubleshooting of the production issues Strong analytical and technical ability with good communication and inter personal skillsStrong understanding of SQL (Structured Query Language) for writing complex queriesKnowledge of ER diagrams, table design, and relationships (primary/foreign keys)Ability t...

Must be expert in both SQL and Power BI. create SQL Queries/Stored Procedures SQL/data connection/data modeling Build interactive and visually appealing dashboards and reports using Power BI. Power BI dataflows and data preparation Required Candidate profile understand data connections, Direct Import, Direct Query, Live connection debugging Strong SQL skills and experience with query modes and live mode connections.

Responsibilities: * Design, develop & maintain complex SQL solutions using multi-server environment. * Optimize performance through monitoring tools & stored procedures. Health insurance Annual bonus Provident fund

Role & responsibilities Real-Time Monitoring Analyst: • Performs real time monitoring, KPI reporting, incident trigger and alerting. • Real Time Monitoring of Contact Center Services on an interval basis monitoring areas such as but not limited to Call/Chat volumes, Average Handle Time (AHT), SLAs, Queue times, Agent availability etc • Monitoring socials to identify potential issues which could lead to customers contact requests. • KPI Reporting Intra-day, daily, weekly, monthly. • Trigger real time responses and pre-agreed procedures against pre-agreed “triggers” (priority 4, 3, 2, and 1) including the alerting of relevant Microsoft and Delivery Partner stakeholders, CSS command center Inci...

Position- Oracle/PLSQL Developer Experience 5-10 yrs Location- Pune, Chennai and Bangalore Skills required: Hard core Oracle/PLSQL Development experience required. Experience in Oracle architecture, Oracle queries/Advance queries is mandatory Oracle PL/SQL , performance tuning , data modeling, understanding of views, triggers and indexes, exposure on btree indexes Strong SQL skills (ideally Oracle/PLSQL), experience with complex query development for numerically intensive applications, and self-driven. Additionally, experience with Unix scripting and/or python would be ideal. Basic conceptual familiarity with RDBMS techniques such as perf tuning Note- Looking only immediate joiners

Position- Oracle/PLSQL Developer Experience 5-10 yrs Location- Pune, Chennai and Bangalore Skills required: Hard core Oracle/PLSQL Development experience required. Experience in Oracle architecture, Oracle queries/Advance queries is mandatory Oracle PL/SQL , performance tuning , data modeling, understanding of views, triggers and indexes, exposure on btree indexes Strong SQL skills (ideally Oracle/PLSQL), experience with complex query development for numerically intensive applications, and self-driven. Additionally, experience with Unix scripting and/or python would be ideal. Basic conceptual familiarity with RDBMS techniques such as perf tuning Note- Looking only immediate joiners

Position- Oracle/PLSQL Developer Experience 5-10 yrs Location- Pune, Chennai and Bangalore Skills required: Hard core Oracle/PLSQL Development experience required. Experience in Oracle architecture, Oracle queries/Advance queries is mandatory Oracle PL/SQL , performance tuning , data modeling, understanding of views, triggers and indexes, exposure on btree indexes Strong SQL skills (ideally Oracle/PLSQL), experience with complex query development for numerically intensive applications, and self-driven. Additionally, experience with Unix scripting and/or python would be ideal. Basic conceptual familiarity with RDBMS techniques such as perf tuning Note- Looking only immediate joiners

Responsibilities: * Design, develop & maintain complex SQL solutions using multi-server environment. * Optimize performance through monitoring tools & stored procedures. Annual bonus Health insurance Provident fund

Should have strong experience in Joins, Sub-Queries, Stored Procedures, CTE, Windows & Date Functions, Views, SQL loader etc. Should have experience in SSIS development-Packages, Transformations, Event handlers, Deployments etc sachin@assertivebs.com

Responsibilities: * Design, develop & maintain complex SQL solutions using multi-server environment. * Optimize performance through monitoring tools & stored procedures. Annual bonus Health insurance Provident fund

Requirements and skills: • Create databases • Writing optimized queries, views and triggers for integration. • Maintain high standards of data quality and integrity • Experience in maintaining database on Cloud service providers

Role & responsibilities Looking for a strong SQL / Backend Developer with 5-7 years of experience to support our product feature development. The role involves writing and optimizing SQL logic, building backend scripts, and collaborating with engineering teams to deliver scalable product features. Must Have Requirements - 5-7 years strong SQL development experience - Excellent in writing and tuning complex SQL - Hands-on experience with Java (scripts, utilities, backend logic) - Hands-on experience with Python (scripts, data tasks, automation) - Good understanding of data modeling, joins, analytics functions, and schema design - Ability to translate business logic into efficient SQL and back...

Responsibilities: * Design, develop & maintain complex SQL solutions using multi-server environment. * Optimize performance through monitoring tools & stored procedures. Annual bonus Health insurance Provident fund

Job Description: Activities to be performed : Creation of high end and complex BI dashboards in Power BI along with backend data extraction and management from multiple source systems ETL Data Flow creation/ Data transformation / Data manipulation in SQL Server or Power Query Developing complex queries using sub queries and multiple joins. End to End handling of BI projects including Requirement Gathering, Solutioning, POC Development, Data Model Creation, BI Development Deployment and Testing Data comprehension and processing of reports, data input in the reports based on agreed delivery schedule Aggregation of data from different sources and representation based on client requirements Crea...

Responsibilities: * Design, develop & maintain complex SQL solutions using multi-server environment. * Optimize performance through monitoring tools & stored procedures. Annual bonus Health insurance Provident fund

Position Type Full time Type Of Hire Experienced (relevant combo of work and education) Education Desired Bachelor's DegreeGENERAL DUTIES & RESPONSIBILITIES Develops, maintains and upgrades manual or automated test scripts, utilities, simulators, data sets and other programmatic test tools required to execute test plans Performs usability testing for total system performance, reliability, scalability and security Effectively communicates testing activities and findings in oral and written forms Controls and manages own daily test activities Provides internal quality assurance Supports test lead to identify risks and develops mitigation strategies Organizes and maintains the test script libra...

Key Responsibilities Develop, optimize, and maintain complex PL/SQL queries , stored procedures, functions, packages, and triggers. Work extensively with indexes , query performance tuning , and database optimization to ensure efficient data processing. Write and manage dynamic SQL , cursors , and other advanced database operations. Collaborate with cross-functional teams to build and improve backend modules using Java . Troubleshoot performance issues and provide solutions for system stability and scalability. Participate in code reviews, design discussions, and architectural decisions. Develop reusable components, ensure coding best practices, and contribute to system improvements. Work cl...

Responsibilities: * Design, develop & maintain complex SQL solutions using multi-server environment. * Optimize performance through monitoring tools & stored procedures. Annual bonus Health insurance Provident fund

Job Title : SQL Reporting Support. Location: Chennai, India Work Mode: Work from Office Mandatory(24/7 Rotational Shift) Company: Smartavya Analytica Private limited is a niche Data and AI company. Based in Pune, we are pioneers in data-driven innovation, transforming enterprise data into strategic insights. Established in 2017, our team has experience in handling large datasets up to 20 PBs in a single implementation, delivering many successful data and AI projects across major industries, including retail, finance, telecom, manufacturing, insurance, and capital markets. We are leaders in Big Data, Cloud and Analytics projects with super specialization in very large Data Platforms. https://...