```Duties```
· Designs and develops ETL solutions using data warehouse design best practices for Next Generation Analytics platform
· Analyze data requirements, complex source data, data models, and determine the best methods in extracting, transforming and loading the data into the data staging, warehouse and other system integration projects.
· Analyze business requirements and outline solutions.
· Document all ETL and data warehouse processes and flows..
· Develop and deploy ETL job workflow with reliable error/exception handling and rollback.
· Manage foundational data administration tasks such as scheduling jobs, troubleshooting job errors, identifying issues with job windows, assisting with Database backups and performance tuning.
· Create or update technical documentation for transition to support teams.
· Provides senior technical leadership to design, architecture, integration and support of the entire data sourcing platform with a focus on high availability, performance, scalability and maintainability
· Effectively communicate status, workloads, offers to assist other areas.
· Perform and coordinate unit and system integration testing.
· Participate in design review sessions and ensure all solutions are aligned to pre-defined architectural specifications.
```Must Have```
- 5+ years in ETL design, development, optimization & testing using PL/SQL on Oracle
- 3 to 4 years of experience in Cloud Data platforms like Databricks or Snowflake
Job Type: Contract
Pay: $50.00 - $60.00 per hour
Experience level:
- 6 years
Schedule:
- 8 hour shift
Ability to Relocate:
- Harrisburg, PA: Relocate before starting work (Required)
Work Location: In person