Description

You will design and manage data integration processes for complex data warehouse environments.

Responsibilities

• Develop ETL/ELT pipelines for data warehouse integration from diverse data sources.
• Manage both full and incremental ETL processes using Informatica Power Center.
• Orchestrate ELT workflows within Snowflake managed services using Airflow.
• Provide production support for existing data pipelines and database systems.
• Maintain and monitor data flows using New Relic.

Required Skills

• 7+ years of ETL/ELT development experience.
• Expertise in SQL and manipulating large datasets within databases.
• Deep knowledge of OLTP and Dimensional schema design.
• Hands-on experience with Snowflake and Informatica Power Center.
• Proficiency with Airflow for ELT orchestration.
• Experience working within AWS Cloud environments.
• Working knowledge of GIT and Rally.
• Ability to work in the PST time zone.

Preferred Skills

• Experience extracting and manipulating data using Python or Scala.
• Expertise building data pipelines using AWS services including S3, EC2, EMR, Glue, and Athena.
• Experience with AWS Terraform and MicroStrategy reporting tools.

Key Skills

Education

Any Graduate