PL/SQL Developer
Virtusa Corporation
Dallas, TX, United States
about 2 months ago
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Apply on www.dice.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Job source
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
Apply for this position
This job is hosted externally. Click below to view the full posting and apply.
Apply on www.dice.com
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦