Job Description

Posted On: 19 Jul 2024


Location: Noida, UP, India


Company: Iris Software


Why Join Us?

Are you inspired to grow your career at one of India's Top 25 Best Workplaces in IT industry? Do you want to do the best work of your life at one of the fastest growing IT services companies ? Do you aspire to thrive in an award-winning work culture that values your talent and career aspirations ? It's happening right here at Iris Software.




About Iris Software

At Iris Software, our vision is to be our client's most trusted technology partner, and the first choice for the industry's top professionals to realize their full potential. With over 4,300 associates across India, U.S.A, and Canada, we help our enterprise clients thrive with technology-enabled transformation across financial services, healthcare, transportation & logistics, and professional services.


Our work covers complex, mission-critical applications with the latest technologies, such as high-value complex Application & Product Engineering, Data & Analytics, Cloud, DevOps, Data & MLOps, Quality Engineering, and Business Automation.




Working at Iris

•Be valued, be inspired, be your best. •

At Iris Software, we invest in and create a culture where colleagues feel valued, can explore their potential, and have opportunities to grow.

Our employee value proposition (EVP) is about "Being Your Best" - as a professional and person. It is about being challenged by work that inspires us, being empowered to excel and grow in your career, and being part of a culture where talent is valued. We're a place where everyone can discover and be their best version.



-------------------



Hands on in Oracle version 19c and 21c.

Strong coding knowledge in PLSQL (Bulk Collect, Recursion, Loops (FOR, WHILE DO), Nested blocks, Exception Handling).

Strong Coding knowledge in SQL Queries


Knowledge on Analytical functions, View and Materialized Views, Sys tables and Privileges

Good understanding of Performance tuning concepts like Access Paths, Join methods, Partitioning, etc.


Awareness about Oracle data various dictionary and their significance.

Complex Queries : Nested queries, inline views, co-related subqueries

Awareness about Hierarchical queries.


Mandatory Competencies
--------------------------


Database - Oracle
Database - PL/SQL
Database - SQL
Beh - Communication and collaboration Perks and Benefits for Irisians


At Iris Software, we offer world-class benefits designed to support the financial, health and well-being needs of our associates to help achieve harmony between their professional and personal growth. From comprehensive health insurance and competitive salaries to flexible work arrangements and ongoing learning opportunities, we're committed to providing a supportive and rewarding work environment.

Join us and experience the difference of working at a company that values its employees' success and happiness.