Data Warehouse Architect || c2c Remote jobs in usa || Contract

DWH Lead Architect

12+ months

Visa: USC, GC, GC-EAD,, TN H4-EAD with DL and LinkedIn 

Location: Remote (Client is Eastern Time Zone)

Required Skills:

Snowflake: Understanding of Snowflake architecture.
Experience in creating and optimizing Snowflake data warehouses.
Advanced proficiency in writing SQL queries for Snowflake.
Experience in performance tuning and troubleshooting on Snowflake.
Oracle: Strong experience with Oracle databases, including SQL and PL/SQL.
Experience with migrating data from Oracle to Snowflake.
Familiarity with Oracle’s performance optimization and backup strategies.
Python: Ability to create Python scripts to work with AWS services for data workflows.

Data Modeling: Strong understanding of data modeling concepts (ER, star/snowflake schemas).
Experience in building scalable, maintainable data models in Snowflake.
AWS Services: Hands-on experience with AWS cloud infrastructure (e.g., S3, EC2, DMS).
Knowledge of data pipeline orchestration using AWS services.
Data Analysis: Ability to analyze and derive insights from large datasets using SQL and Python.
Strong problem-solving skills, with experience in identifying trends and patterns in data.

ETL Tools (Good to Have):

Informatica / IICSExperience in building ETL workflows with Informatica and integrating them with Snowflake.
Matillion:Hands-on experience with Matillion ETL for Snowflake.
Ability to design and manage data pipelines using Matillion, ensuring efficiency and scalability.
MuleSoft:Experience with API-based integrations using MuleSoft.
Ability to create data integration workflows between Snowflake, Oracle, and AWS using MuleSoft.
 

Click here for More remote and onsite Contract / Fulltime USA JOBS