ETL Developer

Job Description

Title: ETL Developer

Location: 100% REMOTE (EST or CST ONLY!)

Duration: 6-12 Months + Contract

Rate: $50-60 Per Hour W2

The estimate above represents the candidate's typical compensation range at the time of hire. Several factors may be utilized to determine your hourly rate including but not limited to years of experience and specific skillsets compared to employees in this role. Candidates typically start at the lower half of the estimated range.

This role is eligible to enroll in both Mondo's health insurance plan and retirement plan. Mondo defers to the applicable State or local law for paid sick leave eligibility. Start Date: ASAP

Interview Process: 2 Video Interviews

Job Description:

Design, develop, and document complex processes that consolidate and integrate data

Follow and contribute to best practices for data integration workflows

Understanding and Analysis of requirements at a sufficient level of detail to allow ETL solutions to be developed

Development of ETL job flows according to company standards for naming, performance, relatability and performance.

Develop, maintain, and extend reusable data integration components, per design from senior

ETL developers/architects.

Perform development, testing, and implementation of Oracle PL/SQL.

Support testing and remediation of defects in newly-developed/modified ETL workflows

Provide ongoing support in PRODUCTION, including monitoring and troubleshooting

Performance tune and troubleshoot ETL processes under development and in production as necessary.

Collaborate with the Data Architecture team to understand and implement load processes for reporting and analytic data structures (data warehouses and data marts)

Work with the DBA team to tune and refactor ETL workflows to perform well with databases.

Work with the Data Architects to augment ERD's as changes are developed

Collaborate and be approachable to the team.

Provide timely project and task updates to all concerned parties

Monitor production data integration jobs and correct failures in a timely manner

Must be skilled in loading, and querying dimensional and relational data models in transactional and data warehouse environments.

Must be proficient in reading ER diagrams

Strong knowledge of Oracle 12c or newer, or other enterprise database such as SQL Server

Able to provide work estimates and track own work tasks thru to on-time completion

Must be able to communicate effectively at a technical level verbally and in writing with other team members to understand requirements, develop solutions, then deploy, test and support them. Relevant Work Experience:

Minimum 5 years of work experience in data integration and/or data warehousing

Must have significant experience using enterprise ETL tools, SAP Data Services is strongly preferred, if not, must be willing to learn this tool.

Must have a strong command of SQL, ANSI SQL, and PL/SQL for ETL relating to data warehousing and integration.

Must have a proven track record of developing well-structured, maintainable ETL solutions

Experience querying and loading dimensional and relational data models in a data warehouse environment is required

Strong analytical skills, able to effectively solve problems in a timely manner

Fully remote