Logo of Huzzle

Home

Matches

Explore

Manage

Oracle Database Architect - Deposits and Consumer Datamart team - (Oracle, Linux, Hadoop, Python)

image

PNC

11d ago

  • Job
    Full-time
    Senior Level
  • Data
    IT & Cybersecurity
  • Pittsburgh

AI generated summary

  • You need 5+ years in data architecture, database structures, and data warehousing, with strong skills in Oracle, Linux, Hadoop, Python, and competencies in consulting and problem-solving.
  • You will lead data engineers, design Oracle databases, optimize queries, automate processes in Linux, develop ETL architecture, analyze data, and ensure alignment with quality standards.

Requirements

  • Successful candidates must demonstrate appropriate knowledge, skills, and abilities for a role. Listed below are skills, competencies, work experience, education, and required certifications/licensures needed to be successful in this position.
  • Preferred Skills Competitive Advantages, Customer Solutions, Design, Enterprise Architecture Framework, Machine Learning, Risk Assessments, Technical Knowledge
  • Competencies Consulting, Data Architecture, Database Structures, Data Warehousing, IT Architecture, Logical Data Modeling, Organizational Leadership, Problem Solving, Requirements Analysis
  • Work Experience Roles at this level typically require a university / college degree, with 5+ years of industry-relevant experience. Specific certifications are often required. In lieu of a degree, a comparable combination

Responsibilities

  • Will Lead team of Data Engineers to coordinate tasks and project deliverables.
  • Act as an Oracle database architect, design tables, indexes, stored procedures.
  • Oracle query optimizer, able to write efficient PL/SQL. Create and fine tune indexes to improve performance. Manage large data and optimize tables as needed.
  • Ability to import large text files efficiently, familiarity with Infromatica, sqlldr, sqlplus is a plus.
  • Ability to build automation in Linux to handle repeatable processes. Ability to write Linux shell programs to manage automation.
  • Expertise in programming in either Java or Python to use in report generation, automation, and improve performance.
  • Experience in other Data Technologies and Architecture is desired (Big Data/Hadoop, Data Fabric/Mesh, Object Stores, etc). Leverage this to define future vision and architecture.
  • Designs, develops and optimizes data warehouses, with flexible and scalable data and ETL architecture, to support business users and Business Intelligence (BI) applications.
  • Analyzes business intelligence data and makes recommendations for data warehouse growth and integration an application/business function.
  • Works with IT and business customers to capture requirements for designing the data warehouse architecture.
  • Provides support and technical guidance to ensure the solutions are aligned with the architecture and framework.
  • Leads and consults on the implementation and integration of data warehouses; ensures the solution meets organizational quality and integrity standards.

FAQs

What is the primary role of the Oracle Database Architect in this position?

The primary role is to design, develop, and optimize data warehouses and ETL architecture, coordinate tasks with a team of Data Engineers, and ensure that solutions align with the organization's architecture and framework.

What are the preferred locations for this job?

The preferred locations include Pittsburgh-PA, Cleveland-OH, Strongsville-OH, Birmingham-OH, and Dallas-TX.

Is sponsorship for employment visas available for this position?

No, PNC will not provide sponsorship for employment visas.

What is the minimum work experience required for this role?

Candidates typically need 5+ years of industry-relevant experience for this position.

Are there any specific technical skills required for this role?

Yes, candidates should have experience with Oracle database architecture, PL/SQL programming, query optimization, Linux automation, and familiarity with programming in Java or Python.

Is a degree required for this position?

A bachelor's degree is preferred, though a comparable combination of education, job-specific certifications, and experience may be considered in lieu of a degree.

What kind of automation is the Oracle Database Architect expected to build?

The architect is expected to build automation in Linux to handle repeatable processes.

Are there any benefits provided to employees at PNC?

Yes, PNC offers a comprehensive range of benefits, including medical and dental coverage, life insurance, 401(k) plans, and paid leave options.

What types of data technologies are preferred for candidates applying for this position?

Experience with Big Data, Hadoop, Data Fabric/Mesh, and Object Stores is desired.

How does PNC view its employees in terms of organizational culture?

PNC values its employees as its greatest differentiator and competitive advantage, promoting an inclusive workplace culture where all employees feel respected and have the opportunity to contribute to the company's success.

image

PNC

Finance
Industry
10,001+
Employees

Mission & Purpose

For more than 160 years, we’ve been committed to making a difference for our customers, communities and employees. Our Main Street banking model means we are uniquely rooted in the places where we operate, living in and supporting the communities in which we do business – understanding our customers are our neighbors. Through our growth into one of the nation’s leading banks, we are helping customers from coast-to-coast protect and grow their wealth. By combining what customers love about community banks with the security, technology, and capabilities of a top bank, we are helping everyone move forward financially. See how we can make a difference for you.