ETL Developer

Company: Mondo
Location: Jersey City
Posted on: May 8, 2024

Job Description:

Apply Now: ETL Developer (extract transfer load), this opportunity is 100% remote. The start date for this contract role is ASAP.

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

Keywords: Mondo, Passaic , ETL Developer, IT / Software / Systems , Jersey City, New Jersey