Description

Design and implement scalable data warehouse solutions, owning the full ETL lifecycle from coding scripts to optimizing performance and managing cloud migrations.

This role is on-site.

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.

Preferred Skills

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

Key Skills

Education

Any Graduate