Data Warehouse Engineer - ETL, SQL & Data Pipelines

Praise Tech Sol; United States; Remote; USD 90,000 - 130,000; Full time

Job summary

Praise Tech Sol is seeking a data warehousing and ETL specialist to design and implement scalable data architectures across the enterprise. You will model data using star and snowflake schemas, develop robust ETL pipelines, and optimize SQL for analytics across diverse data sources.

You will work with Fivetran, Matillion ETL, and Informatica to connect sources, transform data, and schedule workflows. Strong scripting, documentation, and problem-solving skills are essential.

Qualifications

• Experience designing data warehouses using star and snowflake schemas.
• Expertise in ETL development including SCD I/II, incremental loads, and data snapshots.
• Proficient SQL for analytics, window functions, CTEs, and performance tuning.
• Experience developing PL/SQL objects: procedures, functions, triggers, packages.
• Knowledge of data integration tools (Fivetran, Matillion ETL, Informatica).
• Familiarity with OBIEE/OAC metadata, dashboards, and reports.
• Version control with Git; collaborative workflows.

Responsibilities

• Design data warehouses with ER models, facts and dimensions, star/snowflake schemas.
• Implement incremental loads, SCD I/II, truncates, snapshots, soft deletes, aggregations.
• Develop and tune SQL queries using analytic/window functions, joins, partitions; create views/materialized views.

Skills

Data Modeling

SQL

ETL

Python

Data Warehousing

Data Integration

Problem Solving

Documentation

Tools

Fivetran

Matillion ETL

Informatica

OBIEE/OAC

Git

Linux CLI

Python

Job description

Praise Tech Sol is seeking a data warehousing and ETL specialist to design and implement scalable data architectures across the enterprise. You will model data using star and snowflake schemas, develop robust ETL pipelines, and optimize SQL for analytics across diverse data sources.

You will work with Fivetran, Matillion ETL, and Informatica to connect sources, transform data, and schedule workflows. Strong scripting, documentation, and problem-solving skills are essential.