ETL Developer

ETL Developer

Posted Today by Triwave Solutions Inc

Apply
Negotiable
Undetermined
Remote
Remote
Apply
Amazon Web Services (AWS) Application Programming Interface (API) AWS Glue Azure Data Factory Cloud Computing Cloud Technology Data Integration Data Migration Datamodel Data Modeling Data Quality Data Validation Exception Handling External Auditing Extract Transform Load (ETL) Informatica Java (Programming Language) Microsoft Azure Python (Programming Language) Scripting Scrum (Software Development) Software Development SQL (Programming Language) Stakeholder Management Talend Unstructured Data Verification And Validation Windows PowerShell

Summary: The ETL Developer role involves designing, developing, and maintaining ETL processes and systems to meet specific requirements. The position requires collaboration with stakeholders and technical teams to ensure data quality and compliance with standards. The developer will also provide training and documentation to agency staff and participate in team meetings following Scrum methodologies. Relevant experience in SQL and data migration projects is essential for success in this role.

Key Responsibilities:

  • Design, develop, and maintain ETL processes and systems.
  • Create and implement ETL strategies to meet LDWF and OTS requirements.
  • Collect, clean, and integrate data from various sources, including structured and unstructured data.
  • Develop and maintain data models and data mappings.
  • Ensure data quality and integrity by implementing data validation and error handling processes.
  • Collaborate with LDWF stakeholders and OTS technical teams to define and prioritize requirements.
  • Provide technical knowledge transfer, training, and documentation to OTS and LDWF Agency staff for all requested work.
  • Participate by providing feedback and detailed design and implementation approaches in all necessary team meetings and design sessions in accordance with Scrum ceremonies.
  • Cooperate with LDWF's Technical Architect and other OTS technical teams to ensure compliance with OTS standards of State applications.
  • Perform all other tasks, special projects, analysis, studies, and plans as directed.

Key Skills:

  • Two (2) plus years advanced SQL experience writing complex queries, joins, and stored procedures.
  • Four (4) plus years experience working on data migration or data integration projects.
  • Experience in building automated, repeatable workflows; performance tuning; data cleansing; API integration; audit logging and exception handling.
  • Completion of two or more full-scale data migration projects (legacy to cloud or legacy to modern ERP/CRM) is desirable.
  • Experience with enterprise ETL tools such as Informatica, Talend, AWS Glue, Azure Data Factory, or SSIS.
  • Experience with scripting languages such as Python, PowerShell, Java.
  • Experience working on a development team.
  • Experience with client engagements on design, delivery, deployment, and ongoing maintenance.
  • Previous experience working in an Agile/Scrum environment.

Salary (Rate): undetermined

City: undetermined

Country: undetermined

Working Arrangements: remote

IR35 Status: undetermined

Seniority Level: undetermined

Industry: IT

Detailed Description From Employer:

JOB TITLE: ETL Developer

The scope of the proposed services will include the following:

Design, develop, and maintain ETL processes and systems.

Create and implement ETL strategies to meet LDWF and OTS requirements.

Collect, clean, and integrate data from various sources, including structured and

unstructured data.

Develop and maintain data models and data mappings.

Ensure data quality and integrity by implementing data validation and error handling

processes.

Collaborate with LDWF stakeholders and OTS technical teams to define and prioritize

requirements.

Provide technical knowledge transfer, training, and documentation to OTS and LDWF

Agency staff for all requested work.

Participate by providing feedback and detailed design and implementation approaches in all

necessary team meetings and design sessions in accordance with Scrum ceremonies.

Cooperation with LDWF s Technical Architect and other OTS technical teams to ensure

compliance with OTS standards of State applications.

Perform all other tasks, special projects, analysis, studies, and plans as directed.

Expertise and/or relevant experience in the following areas are mandatory:

Two (2) plus years advanced SQL experience writing complex queries, joins, and stored

procedures to identify anomalies and transform data types.

10

Four (4) plus years experience working on data migration or data integration projects with

specific experience in building automated, repeatable workflows; performance tuning; data

cleansing; API integration; audit logging and exception handling.

Expertise and/or relevant experience in the following areas are desirable but not mandatory:

Completion of two or more full-scale data migration projects (legacy to cloud or legacy to

modern ERP/CRM).

Experience with enterprise ETL tools such as Informatica, Talend, AWS Glue, Azure Data

Factory, or SSIS.

Experience with scripting languages such as Python, PowerShell, Java.

Experience working on a development team.

Experience with client engagements on design, delivery, deployment and on-going
maintenance.

Previous experience working in an Agile/Scrum environment.

Apply
Similar Jobs
Loading data...