Oracle PL/SQL Data Architect

Everforth Apex
Newark, DE, United States
9 days ago
Apply on www.dice.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
10 years minimum
Working hours
Regular working hours
Job source

Tech stack

Microsoft Excel Data Analysis Applications Architecture CA Workload Automation Ae Big Data Business Process Modeling Databases Data Architecture Data Integrity Extract Transform Load (ETL) Data Warehousing IBM InfoSphere DataStage
+12 more
Job Scheduling Microsoft SQL Server MicroStrategy MySQL Oracle SQL Developer Performance Tuning Shell Script Data Streaming Tableau (Software) Information Technology Physical Data Models Alteryx

Job description

  • Design and create conceptual, logical, and physical data models for analytic data requirements.
  • Develop and maintain Oracle PL/SQL code and ETL processes.
  • Improve and streamline processes for data flow and data quality to enhance accuracy, viability, and value.
  • Perform database fine-tuning and optimization.
  • Conduct in-depth data analysis on large datasets to identify patterns and present findings.
  • Enhance existing processes and define new, more efficient ones.
  • Collaborate as a team member in a fast-paced, agile development environment.
  • Work under minimal supervision with general guidance from management.

Requirements

We are seeking an Application Architect with extensive experience in Oracle PL/SQL and ETL processes. This role involves designing conceptual, logical, and physical data models to support data warehousing needs. The ideal candidate will be adept at working with both upstream source of record systems and downstream data models, ensuring data integrity and optimizing data flow., Education: Bachelor’s degree or equivalent in a quantitative field such as computer science, mathematics, engineering, or finance.

Experience: A minimum of 10 years of experience in the creation of Oracle PL/SQL and ETL work.

Technical Skills:

  • Expert-level PL/SQL skills.
  • Experience with database fine-tuning.
  • Strong data analysis skills with the ability to study large amounts of data independently.
  • Proficiency in MS SQL Server and MySQL.
  • Strong analytical, problem-solving, and communication skills.

Preferred Qualifications

  • Knowledge of ETL tools such as DataStage, Informatica, or Alteryx.
  • Familiarity with BI tools like Tableau or MicroStrategy.
  • Experience with job scheduling tools, for example, Autosys or Shell scripts.
  • Proficiency in Microsoft Excel.

About the company

Everforth Apex is a world-class IT services company that serves thousands of clients across the globe. When you join Everforth Apex, you become part of a team that values innovation, collaboration, and continuous learning. We offer quality career resources, training, certifications, development opportunities, and a comprehensive benefits package. Our commitment to excellence is reflected in many awards, including ClearlyRateds Best of Staffing in Talent Satisfaction in the United States and Great Place to Work in the United Kingdom and Mexico.

Everforth Apex uses a virtual recruiter as part of the application process. Click for more details. By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from Everforth Apex and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel and HELP for help. You can access our privacy policy at, UnitedHealthcare creates and publishes the Transparency in Coverage Machine-Readable Files on behalf of Everforth Apex Systems.

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

Good distractions

Loading talks and stories from around this role…