Description

Design and implement scalable data warehouse solutions by translating business requirements into data models. You will own the full lifecycle of ETL development, from coding scripts to optimizing performance and managing cloud migrations.

Responsibilities

• Code Oracle, Snowflake, or Informatica IICS ETL scripts to transform data from operational databases to target systems.
• Design and document data models sourced from multiple systems using industry standards.
• Monitor and optimize data processing and storage performance, including query tuning and architectural recommendations.
• Develop shell and Python scripts for production job automation.
• Assist in planning and migrating on-premises data solutions to the cloud.

Required Skills

• 5+ years of experience in database development, including analyzing, designing, coding, and testing SQL.
• Expertise in Oracle SQL and PL/SQL.
• Proficiency in Informatica IICS.
• Experience with AWS data warehouse applications and cloud architectures.
• Hands-on experience with large, multi-terabyte data warehouses.
• Knowledge of Airflow and GitHub version control.
• Competency in Python, Perl, and shell scripting.
• Familiarity with system administration, database administration, and storage architectures.
• BS in Computer Science, Information Technology, or equivalent experience.

Preferred Skills

• AWS, Snowflake, or Informatica IICS certifications.
• Medicaid, healthcare, or claims processing experience.

Key Skills

Education

Any Graduate