Description

Job Description:


DETAILED LIST OF JOB DUTIES AND RESPONSIBILITIES:

  • Understand and translate business requirements into Data Warehouse solutions.
  • Create data models and designs to meet specific business needs that require sourcing data from multiple source systems.
  • Has the ability to mentor other technical staff in cloud technologies at all levels of understanding and can adjust the message accordingly.
  • Assists in identifying, planning, and migration of on-premises data solutions suitable for migration to the cloud.
  • Code Oracle, Snowflake or IICS ETL scripts that will transform data from an operational database and populate to various targets.
  • Document design using industry standards.
  • Capable of monitoring and optimizing data processing and storage performance with cloud environments. This includes identifying bottlenecks, tuning and optimizing queries, and recommending architectural changes to improve efficiency.
  • Provide query writing support and tuning expertise to analysts and end users.
  • Develop shell/Python scripts for production job automation.
  • Work in a 24x7 environment which requires on-call rotation.


Preferred Knowledge, Skills & Abilities:

  • 5+ years of experience in database development including analyzing, designing, documenting, coding, testing, and implementing primarily SQL code.
  • Thorough knowledge of Data Warehouse applications on AWS.
  • Experience working with Airflow.
  • Exceptional Oracle/Snowflake SQL skills
  • Hands on experience with Cloud architectures.
  • Strong problem solving and analytical skills.
  • Proficiency in Informatica IICS
  • Understand the concepts of version control and use of GitHub.
  • Experience working with a large, multi-terabyte data warehouse.
  • BS in Computer Science or related degree, or equivalent experience
  • Medicaid or other healthcare or claims processing experience
  • Experienced in Oracle SQL skills and PL/SQL skills.
  • Experience with Perl, system administration, database administration, storage architectures, backup & recovery, and networking.


Education and Certifications:

  • BS in Computer Science, Information Technology or an equivalent combination of education and work experience required.
  • Amazon Web Services (AWS) Cloud Certification and AWS Certified Solutions Preferred
  • Snowflake Certification Preferred
  • Informatica IICS Certification Preferred

Key Skills
Education

Any Graduate

Back To Jobs