Datawarehouse Engineer

Informatica,Etl,Sql

JD Datawarehouse Engineering Lead

Job responsibilities

Conducts / participates in the design to architect, administer and support mission in highly challenged healthcare IT environment

Work closely with technology and business stakeholders to understand goals, determine security requirements, design and implement solutions to meet business objectives, IT strategic initiatives, corporate and regulatory requirements

Ensure solutions support existing technologies encompassing the enterprise infrastructure systems reliability, availability and serviceability

Perform tests and validate all data flows and prepare all ETL processes according to business requirements and incorporate all business requirements into all design specifications

Documents all technical and system specifications documents for all ETL processes and perform unit tests on all processes and prepare required programs and scripts.

Participate and/or take lead on all architecture, development and deployment in different Data warehouse implementations

Currently the application is on prem but will be migrating to AWS

Participate to assess organizational needs and work with others in a team-oriented culture

Tech Stack

SQL Server, SSIS and DataStage,

SQL and stored proc development experience

Knowledge on both Azure and AWS cloud

Notes for WFM or TA - Preference for associates released from Caremore. Looking for strong candidate who has data knowledge (ETL, SQL, Bigdata, Informatica). This is for Lead associates