REQUIREMENT - DATA WAREHOUSE DEVELOPER - REMOTE

[Teja Raj]

Hello Partner,

Hope you doing well

 

Role: Data Warehouse Developer

Location: Remote

Experience: 9+ Years

 

The Data Warehouse Developer position plays a key role in the development of Carelon DWH platform.  This platform powers our specialty care management solutions which support both our health plan partners and the members they cover. The developer will be part of a high-performance Data warehousing team and will be focused on comprehensively creating and improving existing data warehouse processes and improving data quality and data integrity throughout the organization.

 

Primary duties include, but are not limited to:

•        Data Warehouse Developer with a strong understanding of Data Warehousing / ETL strategy and best practices as well as the ability to develop packages using SSIS, Azure Data Factory, Azure DevOps, Git, SQL.

•        Design and develop SQL Server stored procedures, functions, views and triggers to be used during the ETL process.

•        Builds data transformations with SSIS, ADF including importing data from files, moving data from one database platform to another.

•        Designing and developing ETL solutions to acquire and prepare data from numerous upstream systems.

•        Debug and tune ETL processes to ensure accurate and efficient movement of data.

•        Design, implement and maintain database objects (tables, views, indexes,) and database security.

•        Test and prepare ETL processes for deployment to production and non-production environments.

•        Building Dimensional Modeling for Data Warehouse.

•        Off-hour on-call production support Experience,

 

Tech Stack & Domain:

•        Minimum of 6 years of experience with expert knowledge in SSIS and Azure Data Factory

•        Expert level T-SQL experience. 

•        Must be very good in SQL, Performance Tuning, Stored Procedures and functions.

•        The candidate must have the ability to independently and logically walk through and understand existing SSIS / ETL packages.

•        A solid understanding of data management best-practices and in-depth experience with Microsoft SSIS/ADF

•        Experience working with Addon tools for quick integration like Zappysys (preferred)

•        Healthcare experience preferred

--

NOTE: PLEASE DON`T SUBMIT CPT, OPT, H1-T & GREEN CARD HOLDERS

Thanks & Regards
Teja
HCL Global Systems, Inc

Email Id:  Te...@hclglobal.com

Hangouts: Teja.h...@gmail.com  | LinkedIn: Teja Teju | LinkedIn

Certified Minority Business Enterprise (MBE)