Job Seekers, Please send resumes to swapna@hireitpeople.com

Job Description:

RESPONSIBILITIES

Design and develop or modify ETL processes that load data for the data warehouse using ETL tools (SSIS) and SQL packages.Maintain existing ETL, SQL procedures, packages, and scriptsProvide ETL performance tuningDesign data warehouse schema and star schema data modelsAssist with the creation of reusable components as they relate to the ETL frameworkBuild AWS solutions for the Data Management

REQUIREMENTS

Bachelor’s Degree or comparable work experience. Computer Science or similar preferredFive years (minimum) of work experience as a Developer, and part of a Development team, personally and successfully implementing ETL code, projects and software. Seven years preferred.3+ years of experience working across healthcare data in technical capacities. Specifically, you have strong knowledge of claims data, prior authorization data, and provider-side data. 5+ years of experience in advanced Microsoft SQL Server.2+ years of experience with ETL tools in a Data Warehouse environment.Proficiency with ETL tools such as SSIS.2+ years of strong experience with AWS data services Lambda, Glue, EMR, Kinesis, Step Functions, Data Pipeline, Aurora, DynamoDB, Red ShiftDeveloping Tableau workbooks from multiple data sourcesMinimum 1 year of experience in building Visualization / Analytics using Tableau (both extracted and live connected data sources)Understanding of Star schema database modeling. (OLTP & OLAP experience)Experience evaluating existing data warehouse implementation, architectures and processesExperience in Data Warehouse integration methodology; In-depth knowledge of developing and supporting data warehouses.

ATTRIBUTES

Is eager to seek out and apply new technologies and skills for ETL improvement in daily work through conferences, online training, reading, participation in organizations and user groups, etc.Can translate business needs into technical and system design specificationsAbility to work directly with business analysts or business sponsors clarifying business details.Is comfortable working in a young, growing EDW environment, where processes and systems are still being defined.
Educational Requirements for the Proffered PositionThe minimum qualification required for the performance of the above specialty occupation duties is a Bachelor’s Degree or an equivalent of the same in Computer Science, Engineering, Information Systems, or closely related field with relevant work experience.