Data Conversion/ETL Consultant - Hybrid

Title:

Data Conversion/ETL Consultant -

Hybrid Location:

Baton Rouge,LA Length :

Long term

Restriction:

w2 or c2c

Description:

• Web cam Interview
• Very long term project; initial PO for 1 year, expect to go for 4+ years
• Hybrid
• need 3 references Job Description The scope of the proposed services will include the following: Analyze and map data from the old system to the new one.

Develop and implement data conversion plans. Design and execute data validation and testing processes. Ensure data quality and integrity throughout the data conversion process. Collaborate with LDWF stakeholders and OTS technical teams to define and prioritize data conversion 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. Two (2) plus years ETL experience using enterprise tools (Informatica, SSIS) or scripting languages (Python, PowerShell) to move data from Point A to Point B. Four (4) plus years experience working on data migration or data integration projects with specific experience in Data Profiling, Schema Mapping, Data Normalization, and Error Handling. Experience with creating documentation such as data mapping documents and data dictionaries. 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