hybrid role- 2 days onsite each week, must be local and under 60 mins commute
Performing direct database updates to get data in a migration-ready state, using both novel and reusable SQL scripts
Program and develop SQL scripts, tables, views, stored procedures, functions, etc. for use in importing data from source systems and transforming (ETL) data in a useable format/structure for the target system.
Develop data migration, system integrations which are robust and production ready.
Develop procedures and scripts for data migration
Research required data
Work with other technical personnel for requirements and understanding
Create ETL processes from disparate systems
Proficient with ETL methodologies, including data analysis and data validation
Proficient with ETL methodologies, including data analysis and data validation
Participate in workshops with vendor and IT teams to gather and analyze business requirements
Analyze business data to estimate/benchmark time needed for data transformation and load.
Clearly describe and/or document issues concerning the quality of data with to their business requirements and processes
Develop, test, execute and document repeatable processes to migrate data into a new system
Proficiency in XML