Oracle PL SQL Developer

Falcon IT is currently seeking an Oracle PL SQL Developer to work with our client in Orlando, Florida

Essential Duties and Responsibilities:

The Oracle PL SQL Developer will design, develop, unit test, document, and perform ongoing support for the ETL and MS SQL products and code. Additionally, the developer needs to understand ETL to and from common database and file formats.

• Design, build, test and maintain data structures such as data marts, data warehouses, data lakes and data pipelines to acquire, profile, cleanse, consolidate, integrate and persist structured, semi-structured and unstructured data.
• Work with internal and external data providers and subject matter experts to understand data sources and formats.
• Understand and influence the data provider roadmap of planned changes.
• Develop PL/SQL packages to extract, validate and populate data tracking, auditing.
• Generate server-side PL/SQL scripts for data manipulation, validation and materialized views.
• Create technical specification, including the process and Oracle/PL/SQL development.
• Design and develop ETL processes for the data warehouse lifecycle (staging of data, ODS data integration, EDW and data marts).
• Design and develop the Data Warehouse's batch management control processes and error handling procedures.
• Prepare key documentation to support the technical design in technical specifications.
• Author and execute unit test scripts/cases.
• Contribute to solution design workshops, championing and promoting ETL best practices.

Work Experience:

• 5+ years of Oracle/SQL development experience
• Experience in PL/SQL development and performance tuning
• Extensive experience writing complex SQL statements to manipulate data as part of data profiling process
• 5+ years of experience in ETL development with SQL
• Familiarity with Salesforce highly desirable

Job Skills:

• Knowledge of current and emerging data, development and cloud-based technologies and best practices.

Education:

• Bachelor's Degree in Computer Science/Information Systems required

Certificates, Licenses & Registrations:

• None

Communication Skills:

• Solid ability to interface, inspire and motivate at various levels of the organization.
• Ability to convey technical information to non-technical individuals.
• Demonstrated experience communicating effectively across internal and external organizations.