• Us Citizen

• Green Card

• EAD (OPT/CPT/GC/H4)

• H1B Work Permit

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 4th Aug 2021

REQUIREMENTS: ETL Development with AWS, database schema with SQL, Glue, HL7 experience wins the day!

Under general direction, primarily responsible for activities related to the development, implementation, and support of the data warehouse.

Essential Duties:

•             Participates in the design of the technical and information architecture for the data warehouse, including all information structures (staging area, data warehouse, data marts, and operational data stores).

•             Designs, develops, tests, monitors, manages, and validates data warehouse activity, including data extraction, transformation, movement, loading, cleansing, and updating processes.

•             Coordinates with business, operations, and engineering stakeholders to ensure overall requirements, health, and performance of the data warehouse environment.

•             Assists in monitoring system performance, reliability, availability, and recoverability of the DW environment.

•             Assists in the evaluation, selection, testing, and optimization of BI/DW related hardware and software products.

Additional Duties:

•             Develops and applies sound fundamental design, analysis, and data administration concepts, practices, and procedures.

•             Designs and develops BI reporting deliverables.

•             Performs other duties as required.

Qualifications

•             Bachelor’s degree in computer science or related field; or an equivalent combination of education and relevant business experience.

•             Five or more years of experience with data warehousing and business intelligence and/or large and complex database management systems.

•             Handson experience using ETL tools.

•             Strong database schema experience; SQL and DDL with MySQL or Postgres

•             Working knowledge of data processing using AWS services and best practices.

•             Experience developing data warehouses using AWS cloud based ETL, storage and analytic services. Athena, Glue, RDS, RedShift, etc.

•             Working knowledge of data warehouse approaches, architecture, and development.

•             Highly effective analytical, decisionmaking, and written/verbal communication skills.

•             Ability to investigate complex technical problems, develop effective recommendations, and resolve problems in a highly professional and tactful manner.

•             Highly organized and able to set priorities effectively.

Preferred candidate experience

•             Knowledge of policies and best practices governing the handling of PHI

•             Experience with X12 5010 healthcare claims transactions

HL7 transaction formats for Admit Discharge Transfer