What are the responsibilities and job description for the ETL Architect -Healthcare position at Infowave Systems, Inc?
Title: ETL Architect -W2 Only (Healthcare)
Location: Rancho Cucamonga, CA (Hybrid)
Responsibilities:
Required Skills:
Location: Rancho Cucamonga, CA (Hybrid)
Responsibilities:
- Data Architect is responsible for the design and development of Data Systems solutions;
- Design and develop ETL solutions/procedures to acquire, harmonize, and consolidate various data assets/sources;
- Create process for automation and enhancement of data quality.
Required Skills:
- Minimum ten (10) years of relevant experience In Data management and governance in Data engineering.
- Three (3) years’ experience in data systems technical architectures, ETL, data structures, and reporting tools and environments.
- Overall 10 years industry expereince focusing on Datawarehouse projects using ETL (SSIS)
- Must have exp in healthcare domain and Expertise in healthcare systems and healthcare databases.
- 7 years’ experience performing data systems development, modification, and support.
- 7 years with SQL Server, SSIS, ETL, SQL,
- Experience in EHR or EMR or FHIR
- Knowledge of HL7
- Must have hands on experience in Logical, rational, dimensional, and physical data modeling.
- Code development, testing for QA, and data profiling.
- Perform SQL queries tuning activities.
- Normalized, dimensional, star schema and snow flake schematic models.
- Developing and optimizing T-SQL (DDL, DML, DCL) queries, stored procedures, functions, and views for various applications
- Software engineering practices and best practices for the full SDLC, including coding standards, code reviews, source control management, build processes, testing, and operations.
- Strong technical documentation skills.