Emergent Method is seeking a qualified ETL Developer to support development and testing activities related to a conversion project for a state government agency. The ideal candidate is experienced, self-motivated, and adept in handling a wide range of data conversion tasks.
Requirements
- Develop program modules using SSIS ETL tool
- Create and execute SQL queries via SQL database
- Analyze/troubleshoot data integrity issues and data discrepancies
- Validate/test conversion program modules to ensure accuracy
- Manage and execute large number of SSIS modules via SSA (SQL Server Agent)
- Communicate daily status updates to key stakeholders and project team
- Provide technology design and develop and support risk and regulatory platform capabilities, functions, and processes
- Collaborate with source systems’ technical representatives to troubleshoot data issues and to process source systems’ data extracts
- Understand business requirements with respect to data needs
- Analyze source data and perform data gap analysis, source-to-target mappings, and data integration design
- Implement and maintain database schemes to support the transformation of the source systems’ data and loading into the target systems’ databases
- Troubleshoot program modules performance issues and performance tune program modules and database tables