9 Aggregate Functions Jobs

You should have a minimum of 5+ years of experience in PL/SQL. Your role will involve creating and maintaining large databases with complex requirements. You should have a deep understanding of procedures, functions, and collections, as well as hands-on experience in analytical and aggregate functions. It is important that you have the ability to create and manage triggers effectively. Experience in database transaction management is also required. In this role, you will be expected to provide support to Java developers when needed. Knowledge and understanding of Agile methodologies will be beneficial. Good written and oral communication skills are essential for effective collaboration within the team. This is a full-time position that requires you to work in person at the specified location. For further details, you can contact: Contact No: 86105 69663 Mail Id: sakthi.sankar@extendotech.com,

The company Doyensys, a Management & Technology Consulting company with expertise in Enterprise applications, Infrastructure Platform Support, and solutions, is seeking an experienced Oracle Forms and Reports Consultant. In this role, you will be responsible for developing and maintaining Oracle Forms and Reports applications, with a mix of production support and development work. The ideal candidate should have 4 to 6 years of experience, excellent troubleshooting skills, and the ability to work independently while collaborating with business users in the US. As an Oracle Forms and Reports Consultant, you must have strong experience in Oracle Forms (10g/11g/12c) and Oracle Reports, deep knowledge of triggers, events, canvases, master-child forms, record groups, built-ins, and properties in Forms and Reports, as well as proficiency in SQL and PL/SQL concepts. You should also be skilled in writing efficient Procedures, Functions, and Packages, using Cursors, Collections, and Exception Handling, and have a strong understanding of Datatypes, Constraints, and Indexes. Additionally, experience with Oracle APEX, exposure to JavaScript and ReactJS, and familiarity with Power Apps for enterprise-grade application development are considered good-to-have skills. The key responsibilities of this role include designing and developing Oracle Forms and Reports applications, customizing and enhancing existing forms and reports, working with Oracle Database 11g, 12c, 19c for back-end integrations, and maintaining and supporting existing Oracle Forms applications. You will also be responsible for troubleshooting issues, performing root cause analysis for system errors or bugs, monitoring application performance, and ensuring scalability, reliability, and performance. Furthermore, you will work closely with business users to gather requirements and ensure a seamless user experience, create and maintain technical documentation for Oracle Forms applications, and document and communicate best practices, development standards, and workflows. The ideal candidate for this role should have an MCA, B.E, M.Sc (CS) or any other equivalent degree with relevant work experience, along with an Oracle SQL / PLSQL Certification. Behavioral attributes such as being passionate and enthusiastic about work, confident in expressing opinions during discussions with team members, flexible in the workplace, and willing to take on additional responsibility are highly valued. If you are a solution-oriented individual with the ability to work independently, collaborate effectively with peers, and ensure quality delivery, this role as an Oracle Forms and Reports Consultant at Doyensys may be the right fit for you.,

Job Role: Senior MS SQL Developer Location: Hyderabad Desired Experience: 2-4 years of experience as an MS SQL Developer or in a similar role Education: Bachelors degree in Computer Science, Information Technology, or a related field. Role Overview We are seeking a highly skilled and experienced Senior MS SQL Developer to join our dynamic team. The ideal candidate will have 2-4 years of relevant experience, with a strong background in database development and management. Prior experience in a SaaS environment is an added advantage. The candidate should possess in-depth knowledge of MS SQL Server and MySQL, including expertise in procedures, functions, triggers, DB backup & restore, temporary tables, and indexes. Key Responsibilities Design, develop, and maintain complex database systems using MS SQL Server and MySQL Write and optimize SQL queries, stored procedures, functions, and triggers to support application development and reporting needs Perform database backup, restore, and recovery operations to ensure data integrity and availability Manage database security by developing and implementing access control mechanisms and ensuring data privacy Optimize and tune database performance, including indexing, query optimization, and troubleshooting slow-running queries Develop and implement database change management and version control processes Collaborate with development teams to design and implement database solutions that support application functionality and performance requirements Conduct database testing and validation to ensure data accuracy and consistency Monitor database systems for performance, reliability, and security issues, and take corrective actions as necessary Provide guidance and mentorship to junior database developers and other team members Key Skills Proficiency in MS SQL Server and MySQL Strong knowledge of SQL programming, including stored procedures, functions, and triggers Experience with database backup, restore, and recovery processes. Expertise in designing and managing indexes and temporary tables Proficient in database performance tuning and optimization techniques Solid understanding of database security and access control mechanisms Familiarity with database change management and version control practices Excellent problem-solving skills and attention to detail Strong communication and collaboration skills Ability to work independently and as part of a team in a fast-paced environment Qualifications Bachelors degree in Computer Science, Information Technology, or a related field. 2-4 years of experience as an MS SQL Developer or in a similar role Experience working in a SaaS product-based environment is an added advantage Certification in MS SQL Server or related technologies is a plus Benefits Competitive salary and performance-based bonuses Comprehensive health insurance plans and accidental coverage Opportunities for professional development and career growth A collaborative and inclusive work environment

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 subqueries, and have basic knowledge of Table Partitioning including table and index partitioning. In addition, you must have proficiency in PL/SQL and be able to create and maintain objects like procedures, functions, packages, types, and triggers. Your expertise should also include recursion, loops (FOR, WHILE DO), nested blocks, conditional logic (IF, CASE statements), and managing exceptions effectively. Moreover, you should be familiar with working with Collection & Records in PL/SQL blocks and executing BULK operations efficiently. Requirements: - Minimum of 2 years of relevant experience in posgress SQL, SQL/PLSQL - Strong communication skills, approachable nature, and proactive attitude - Hands-on coding and development experience Education Qualification: - B.Tech/M.Tech/MS/BE/B.SC IT Preferred certifications: - PL/SQL Developer Certified Associate Preferred Location: - Mumbai: Thane, Mulund, Bhandup, Vikroli, Ghatkopar, Kurla, and Powai Notice Period: - Immediate Joiner required This is a full-time position with a flexible schedule. You will be expected to work day shifts from Monday to Friday with morning shifts and weekend availability. Performance bonuses will be provided based on your contributions. Ability to commute/relocate to Mumbai, Maharashtra is required. Ideally, you should have a total of 1 year of work experience.,

We are urgently looking for a ETL Testers, details are mentioned below :- ABOUT IRIS SOFTWARE IRIS Software Inc is a CMMI ML 5 professional software services organization offering high-quality, cost-effective solutions to businesses. It has helped meeting the IT requirements of companies ranging from those among the Fortune 100 to medium-sized firms by utilizing best-of-breed technologies, rapidly deployable solutions and flexible engagement models. Visit us at www.irissoftware.com Experience :- 5 to 10 yrs Skills :- ETL Tester, Database testing, DWH testing. Location :- Delhi/NCR /Pune /Chennai Work location :- (Noida-sec-142, Gurugram, Pune- Kalyani Nagar) Shift timings :- 12 :30 PM to 9 :30 PM Notice :- Immediate or July Joiners OR Serving candidates. QUALIFICATIONS/ EXP 5 to 10 years experience as a test engineer specially in ETL Testing. Corporate Banking knowledge/Experience would be added advantage. Proven experience in test plan design Understanding of the software development lifecycle and the deliverable created during the development lifecycle Strong analytical skills, creative and critical thinking ability and problem-solving skills Familiarity with relevant quality assurance industry standard best practices and methodologies Dedication to customer satisfaction Excellent communication skills Problem solving skills Excellent time management skills Self-Motivating SKILLS Experience in creating test solutions. Use of test management tools similar to JIRA. Understanding of executing test automation and interpreting results. Proficient in Window technologies along with Office (Excel, PowerPoint)and Adobe. Proficient in all forms of functional testing across all browsers and devices. Knowledge of ETL Tools. Must have: 1. Must be strong in SQL/queries 2. Good hands-on on Unix 3. Good concepts on Data Warehousing Notice Period :- Immediate to 15 Days Joiners Interested candidates please share your resume at rachna.jha@irissoftware.com with a subject line Name || Experience || Skill || Notice Period || Location PLEASE DONT APPLY IF YOU HAVE IINTERVIEWED IN THE LAST 3 MONTHS.

We are urgently looking for a ETL Testers, details are mentioned below :- ABOUT IRIS SOFTWARE IRIS Software Inc is a CMMI ML 5 professional software services organization offering high-quality, cost-effective solutions to businesses. It has helped meeting the IT requirements of companies ranging from those among the Fortune 100 to medium-sized firms by utilizing best-of-breed technologies, rapidly deployable solutions and flexible engagement models. Visit us at www.irissoftware.com Experience :- 5 to 10 yrs Skills :- ETL Tester, Database testing, DWH testing. Location :- Delhi/NCR /Pune /Chennai Work location :- (Noida-sec-142, Gurugram, Pune- Kalyani Nagar) Shift timings :- 12 :30 PM to 9 :30 PM Notice :- Immediate or July Joiners OR Serving candidates. QUALIFICATIONS/ EXP 5 to 10 years experience as a test engineer specially in ETL Testing. Corporate Banking knowledge/Experience would be added advantage. Proven experience in test plan design Understanding of the software development lifecycle and the deliverable created during the development lifecycle Strong analytical skills, creative and critical thinking ability and problem-solving skills Familiarity with relevant quality assurance industry standard best practices and methodologies Dedication to customer satisfaction Excellent communication skills Problem solving skills Excellent time management skills Self-Motivating SKILLS Experience in creating test solutions. Use of test management tools similar to JIRA. Understanding of executing test automation and interpreting results. Proficient in Window technologies along with Office (Excel, PowerPoint)and Adobe. Proficient in all forms of functional testing across all browsers and devices. Knowledge of ETL Tools. Must have: 1. Must be strong in SQL/queries 2. Good hands-on on Unix 3. Good concepts on Data Warehousing Notice Period :- Immediate to 15 Days Joiners

You will be working as an Oracle Forms and Reports Consultant at Doyensys, a Management & Technology Consulting company with expertise in Enterprise applications and Infrastructure Platform Support. Doyensys operates in India, the US, Mexico, and Canada, and helps clients thrive on change by delivering next-generation IT services and solutions. As an Oracle Forms and Reports Consultant with 4 to 6 years of experience, you will be responsible for developing and maintaining Oracle Forms and Reports applications. Your role will involve a combination of production support and development work, with a focus on troubleshooting and collaborating with business users in the US. Your technical expertise should include strong experience in Oracle Forms (10g/11g/12c) and Oracle Reports, proficiency in SQL and PL/SQL concepts, and skills in writing efficient Procedures, Functions, and Packages. Additionally, you should be adept at analyzing existing code, identifying bugs, and implementing performance enhancements. Experience with Oracle APEX, JavaScript, ReactJS, and Power Apps will be beneficial. Key responsibilities will include designing and developing Oracle Forms and Reports applications, customizing and enhancing existing forms and reports, working with Oracle Database for back-end integrations, maintaining and supporting applications, troubleshooting issues, and collaborating with business users to gather requirements. Professional attributes required for this role include the ability to work independently, strong teamwork skills, solution-oriented mindset, and willingness to take ownership for quality delivery. Educational qualifications should include an MCA, B.E, M.Sc (CS) or equivalent degree with relevant work experience, along with an Oracle SQL / PLSQL Certification. You should demonstrate passion and enthusiasm for your work, confidence in expressing opinions, flexibility in the workplace, and readiness to accept feedback and take on additional responsibilities.,

You will be responsible for performing JOIN operations such as INNER, LEFT, RIGHT, FULL, and CARTESIAN joins on two or more tables. Additionally, you will handle Aggregate Functions including COUNT, MIN, MAX, AVG, FIRST, LAST, and LISTAGG. Your role will involve utilizing Functions like LEAD, LAG, RANK, DENSE_RANK, FIRST_VALUE, LAST_VALUE, and ROW_NUMBER for data analysis. You should be adept at working with Views and Materialized Views, understanding the basics of creating and maintaining views. Proficiency in executing Hierarchical queries for data retrieval from tables with hierarchical data is essential. Your expertise in handling Complex Queries like Nested queries, inline views, and correlated subqueries will be crucial. Knowledge of Table Partitioning, including table & index partitioning, is required. You will be expected to work with PL/SQL, creating and maintaining objects such as procedures, functions, packages, types, and triggers. Familiarity with recursion, loops (FOR, WHILE DO), nested blocks, and conditional logic (IF, CASE statements) is necessary. You must possess experience in managing Exception handling for run-time Oracle defined/user-defined errors. Understanding the usage of collections and records in PL/SQL blocks is vital. Proficiency in BULK operations for performing operations on bulk data is a must. Requirements: - Minimum 2 years of relevant experience in PostgreSQL SQL, SQL/PLSQL - Strong communication skills, approachable nature, and proactive attitude - Hands-on coding and development experience Education Qualification: Preferred certifications: - PL/SQL Developer Certified Associate Qualification: - B.Tech/M.Tech/MS/BE/B.SC IT Preferred Location: (Mumbai) Thane, Mulund, Bhandup, Vikhroli, Ghatkopar, Kurla, and Powai Notice Period: Immediate Joiner required. Job Types: Full-time Benefits: - Flexible schedule Schedule: - Day shift, Monday to Friday, Morning shift - Weekend availability Performance bonus offered. Ability to commute/relocate: - Mumbai, Maharashtra: Reliably commute or planning to relocate before starting work (Required) Experience: - Total work: 1 year (Preferred),

Your key responsibilities Provides innovative and practical designs for the design and integration of new and existing systems, applying advanced technical capabilities Provides technical expertise to maximize improve value from new and existing IT products and solutions and may lead on tool evaluation efforts including the definition of evaluation criteria, tool identification and the actual evaluation Guide others in resolving sophisticated issues in technical architecture and solves sophisticated, escalated aspects of a project and contributes to project management activities, such as providing estimates for tasks Works across multidisciplinary teams and with the business to deliver simple and easy to use systems that meet user needs and gains client / business customers' buy-in consensus Provides coaching, mentoring and support to development teams during integration of components and services across the eco-system, frameworks and platforms Reviews and develops due diligence to confirm the developed solution complies aligns with architectural design Contributes to development standards to promote optimization and consistency (including code modularization and reuse) Learn new and emerging technologies and adopt them in the project Consistently work on improving productivity and cost management of operations Deliver high-quality software and work products in a time bound manner Work in dynamic and collaborative environment within and across teams Skills and attributes for success Has an advanced understanding of technical architecture and can apply this in the development of components of highly scalable, redundant and fault tolerant systems. Working knowledge / understanding of Java / J2EE /Spark/ Springboot / Hibernate / Storm, Kafka, Nodejs, Quartz, SSIS, SQL, RESTful/SOAP APIs, and other Open Source technologies. To qualify for the role, you must have Bachelor's Degree in Computer Science, Economics, Engineering, IT, Mathematics, or related field preferred More than 10 years applied experience Experience of ""owning"" the design of a major/large component of an application or software architecture Possesses deep knowledge on technical architecture spanning across all aspects of each system and how it can be applied in a business context Proven experience in delivering effective technical architecture strategies Microsoft Azure project experience Full stack experience: Java (must-have), Spark (must-have), Python (nice to have), Azure (must-have)