ETL Developer
EMERGENT METHODNew London, Connecticut, United States
Posted March 24, 2025
Full Time
About the Company
Emergent Method helps organizations innovate, grow, and improve performance through management consulting services.
Job Description
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