Senior SQL Web Developer

Job description

Overview Responsible for the development of all processes necessary to complete SDLC phases of the Web Applications and Automation projects. This includes understanding of business processes, source identification, process design, data collection, data transformation, normalization, error detection and correction, data storage, data linage management, data achieving, and ETL Process oversight for web applications. Responsibilities: - Lead design, develop and implement ETL process to support Web Applications and Automation projects. - Responsible for designing and developing SSIS packages used in the Extract, Transform, and Load (ETL) processes. - Responsible for supporting production of all Web Applications ETL process and monitoring production jobs. - Develops and maintains in-depth understanding of SQL Server, SSIS, Oracle, and Analysis Services. - Responsible for working closely with EIM and EDW teams to retire all processes related to old data warehouse and lab data databases. - Work closely with EIM and EDW to source HIE and EDW data for web applications. - Responsible for developing and maintaining data linage for all ETL Processes. - Responsible designing, developing, and im...