Datawarehouse Engineer

Datawarehouse Engineer (Critical High Priority)

Location : Cerritos (Remote OK)

InformaticaEtlSql

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 teamoriented culture

Tech Stack

SQL Server SSIS and DataStage

SQL and stored proc development experience

Knowledge on both Azure and AWS cloud