PL/SQL Developer

Virtusa Corporation

Dallas, TX, United States

2 days ago

Apply on www.dice.com

Prepare application

Role details

Contract type

Permanent contract

Employment type

Full-time (> 32 hours)

Working hours

Regular working hours

Job source

www.dice.com

Tech stack

CA Workload Automation Ae Unix Cloud Computing Information Engineering Data Integration Extract Transform Load (ETL) Data Warehousing Relational Databases Dimensional Modeling Github Python (Programming Language) Oracle Business Intelligence Enterprise Edition

+8 more

Oracle (Applications) Oracle SQL Developer Performance Tuning SQL Stored Procedures PL-SQL Freeform SQL Software Version Control Control M

Job description

Write complex SQL queries using Oracle
Develop and maintain Stored Procedures, Functions, packages, and triggers using Oracle PL/SQL
Utilize ETL tools like Informatica (Power Center) for data integration
Create scripts and automate processes using Unix and Python in a Data Engineering environment
Implement performance tuning techniques for Relational Databases like Oracle
Apply Datawarehousing patterns and Dimensional Modelling techniques using Oracle
Build scalable patterns for data integration in cloud-based and on-prem environments
Utilize Batch scheduling tools like Control-M, Autosys
Work with business intelligence and analytics tools such as OBIEE/OAS
Use GitHUB for Source Code Management (SCM) in a Data Engineering Practice

Requirements

We are seeking a Data Engineer who has the ability to be an independent contributor with strong communication skills. The ideal candidate will have expert-level knowledge of writing complex SQL queries using Oracle and will be proficient in Oracle PL/SQL. They should also have experience with ETL tools like Informatica, scripting and automation using Unix and Python, as well as working knowledge of data warehousing patterns and dimensional modeling techniques using Oracle., * Expert-level knowledge of writing complex SQL queries using Oracle

Expert-level knowledge of Oracle PL/SQL (Stored Procedures, Functions, packages, triggers)
Strong working experience in ETL tools like Informatica (Power Center)
Working experience in scripting and automation using Unix, Python in a Data Engineering environment
Extensive experience with Relational Databases like Oracle including performance tuning techniques
Strong working knowledge of Datawarehousing patterns and Dimensional Modelling techniques using Oracle
Experience building scalable patterns for data integration in cloud-based as well as on-prem environments
Working knowledge of Batch scheduling tools like Control-M, Autosys
Experience with business intelligence and analytics tools such as OBIEE/OAS
Working experience using GitHUB for Source Code Management (SCM) in a Data Engineering Practice