***Web Cam Interview *** Very long term project; initial PO for 1 year, expect to go for 4+ years ***Hybrid***need 3 references
Job Description
- 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.
Mandatory Expertise and/or Relevant Experience
- Two (2) plus years advanced SQL experience writing complex queries, joins, and stored procedures to identify anomalies and transform data types.
- 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.
- 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.
- government experience preferred
Never miss an opportunity! Create an alert based on the job you applied for.
