← Back to jobs

Patton Labs Inc Logo
IICS Developer

Patton Labs Inc

 

Boston, MA, USA

Posted On: 3 days ago
Experience: 5+ years
Availability: Onsite
Openings: 1
Category: IICS Developer
Tenure: No Preference/Any
Related Jobs

No related jobs found

Description

You will design and implement ETL processes to load external feeds into warehouse and data mart tables.

This role is on-site.

Responsibilities

  • Create and enhance ETL jobs for data loading into warehouse and data mart tables.
  • Tune ETL processes and user queries to improve performance.
  • Automate production ETL processes and document workflows for team transitions.
  • Support User Acceptance and Integration testing by researching anomalies and refreshing environments.
  • Collaborate within an agile team to evolve data platform services.

Required Skills

  • 5+ years of experience designing and implementing ETL processes in distributed databases.
  • At least 1 year of hands-on experience with Informatica Cloud (IICS).
  • Proficiency in SQL query writing and optimization on distributed databases.
  • Experience with AWS technologies.
  • Strong understanding of relational, star schema, and dimensional data models.
  • Experience with data modeling, schema design, data loading, and data replication.
  • Working knowledge of Kafka and ETL workflows.
  • Experience working with distributed databases on clusters or platforms.
  • Ability to work within Agile methodologies.

Preferred Skills

  • Any Graduate degree.

Key Skills
Education

Any Graduate

Related Jobs

No related jobs found

← Back to jobs