Experience
2 - 5 yrs
Job Location
Noida, India
Vacancy
1
Designation
Plsql Developer
Job Type
ONSITE
Job Description
Job Summary (List Format):
- Participate in the full software development life cycle: requirements gathering, analysis, design, development, testing, and implementation of applications using UNIX, Oracle PL/SQL, HTML, JavaScript, and CSS.
- Design, develop, test, and implement complex database programs utilizing Oracle PL/SQL and UNIX.
- Work with Oracle SQL queries and PL/SQL objects such as functions, procedures, packages, triggers, views (including materialized views), db_links, sequences, cursors, transactions, dynamic SQL queries, and exception handling.
- Manage production support activities, including debugging and fixing Oracle objects.
- Perform data mapping, conversion, transformation, and integration activities in alignment with third-party vendor requirements, including integration of legacy applications/tools with vendor tools.
- Optimize and enhance performance of existing Oracle code, queries, stored procedures, packages, and functions using tools such as explain plan.
- Develop UNIX shell scripts to load Oracle tables from data files using SQL LOADER and automate scripts via UNIX CRON JOBS.
- Create unit test plans, collaborate with QA teams, and review test plans to ensure software quality.
- (Good to have) Experience in HR/Payroll domain.
- (Good to have) Experience using Oracle s htp.p packages.
- (Good to have) Experience with Matillion.
- (Good to have) Experience with Snowflake. Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.
- Participate in the full software development life cycle: requirements gathering, analysis, design, development, testing, and implementation of applications using UNIX, Oracle PL/SQL, HTML, JavaScript, and CSS.
- Design, develop, test, and implement complex database programs utilizing Oracle PL/SQL and UNIX.
- Work with Oracle SQL queries and PL/SQL objects such as functions, procedures, packages, triggers, views (including materialized views), db_links, sequences, cursors, transactions, dynamic SQL queries, and exception handling.
- Manage production support activities, including debugging and fixing Oracle objects.
- Perform data mapping, conversion, transformation, and integration activities in alignment with third-party vendor requirements, including integration of legacy applications/tools with vendor tools.
- Optimize and enhance performance of existing Oracle code, queries, stored procedures, packages, and functions using tools such as explain plan.
- Develop UNIX shell scripts to load Oracle tables from data files using SQL LOADER and automate scripts via UNIX CRON JOBS.
- Create unit test plans, collaborate with QA teams, and review test plans to ensure software quality.
- (Good to have) Experience in HR/Payroll domain.
- (Good to have) Experience using Oracle s htp.p packages.
- (Good to have) Experience with Matillion.
- (Good to have) Experience with Snowflake. Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.
No Referrers Available
There are currently no referrers available for this job. You can still apply, will let you know once there is any referrer available.