Jobs
Interviews

4 Aggregate Functions Jobs

Setup a job Alert
JobPe aggregates results for easy application access, but you actually apply on the job portal directly.

5.0 - 10.0 years

11 - 18 Lacs

Noida, Pune, Delhi / NCR

Hybrid

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.

Posted 3 days ago

Apply

5.0 - 10.0 years

11 - 18 Lacs

Pune, Delhi / NCR

Hybrid

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

Posted 3 days ago

Apply

4.0 - 8.0 years

0 Lacs

chennai, tamil nadu

On-site

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.,

Posted 4 days ago

Apply

2.0 - 6.0 years

0 Lacs

maharashtra

On-site

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),

Posted 6 days ago

Apply
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

Featured Companies