Data Engineer: Cloud ETL & Data Pipeline Specialist

RICEFW Technologies Inc; Okemos (MI); On-site; USD 85,000 - 110,000; Full time

Job summary

RiceFW Technologies Inc. is seeking a Data Engineer to join the Data Engineering Team. The ideal candidate has at least 3 years in data engineering, focusing on ETL/EDW and data pipelines with change data capture between on-premises and cloud destinations.

You will develop ETL workflows using Informatica CDI-PC, create data-marts with PL/SQL, and automate pipelines. On-call rotation is included as part of the role.

Qualifications

• Minimum 3 years of data engineering experience with ETL/EDW background.
• Experience with Informatica CDI-PC/PowerCenter.
• Experience with cloud data pipelines and Snowflake.
• Proficient in SQL (PL/SQL, T-SQL) and Oracle/SQL Server.
• Excellent communication and teamwork skills.

Responsibilities

• Develop ETL workflows using Informatica CDI-PC (PowerCenter) for on-prem EDW.
• Create ETL processes to load data-marts via PL/SQL solutions.
• Automate data pipelines with stored procedures and scripting components.
• Move data from on-prem sources to cloud platforms (e.g., Snowflake) and applications (e.g., Salesforce).
• Adhere to team change control and configuration management standards.
• Participate in 24-hour on-call rotation in support of the platform.

Skills

ETL

SQL

PL/SQL

T-SQL

Automation

Tools

Informatica CDI-PC (PowerCenter)

Informatica IICS/IDMC

Snowflake

Oracle

SQL Server

Job description

RiceFW Technologies Inc. is seeking a Data Engineer to join the Data Engineering Team. The ideal candidate has at least 3 years in data engineering, focusing on ETL/EDW and data pipelines with change data capture between on-premises and cloud destinations.

You will develop ETL workflows using Informatica CDI-PC, create data-marts with PL/SQL, and automate pipelines. On-call rotation is included as part of the role.