ETL Informatica Architect || Houston, TX

Overview

On Site
Depends on Experience
Accepts corp to corp applications
Contract - Independent
Contract - W2
75% Travel

Skills

Logistics
Data Validation
Data Warehouse
Drawing
Extract
Transform
Load
Coaching
Amazon Web Services
Capacity Management
Replication
Reporting
Data Integrity
Change Data Capture
Cloud Computing
Continuous Improvement
Data Integration
Amazon DynamoDB
Amazon Kinesis
Amazon Lambda
Amazon S3
Amazon SQS
Policies and Procedures
Python
Quality Assurance
Real-time
SQL Azure
Data Quality
Java
Snow Flake Schema
Usability Testing
Use Cases
Optimization
Oracle
PL/SQL
POC
PostgreSQL
Scala
Streaming

Job Details

Senior Business Consultant

06 Months
Location-Houston, TX (Hybrid - 3 days/week onsite required)
Description:
NOTES: Here is some below mandatory tech stack needed
Tech Stack :- (For your reference only)

- Data Warehouse: Snowflake
- ETL tools: dbt, Matillion
- CDC/Replication tools: Qlik Attunity
- AWS services for near real time and batch loading: AWS Lambda and AWS Glue (Python is the language of choice in these implementations)
- Other AWS services used regularly : SNS, SQS, S3, (Kinesis streams, DynamoDB used sometimes based on integrations)
- Versioning system: GitHub
Sometimes we have use cases to connect different data sources like Oracle, Azure SQL DB, Postgres etc. so having a knowledge of these help.
Client currently seeks a Senior Business Consultant to join our team in Houston, TX . (Hybrid - 3 days/week onsite required)
Job Summary:
The Commercial DRO project seeks to propel clients to its 2030 goal of being a World Class Logistics Provider across all lines of business. Drawing upon the continuous improvement mindset and lessons learned executing the Service Excellence program, this project seeks to drive new optimization value, specifically enabling the Commercial Line of Business, through enablement of automated route optimization, same-day execution products maturity, and new Route Manager to Driver coaching tool capabilities.
This project, which began as a POC and represents a multi-year program to garner value (2024/2025) in the following areas:
i. Modernizing the Commercial LOB driver/coach experience
ii. Enhancing ecosystem to support automated commercial route optimization and further refine Commercial capacity planning.

Basic Qualifications:

Experienced with 10+ years in implementing and operationalizing large scale data solutions in production environments using a variety of technologies and frameworks in the cloud or on premise.
Designs and builds performant data pipelines to support a range of business consumption patterns using a range of current data integration technologies (cloud, on-premises, or a combination) or custom approaches using Python, Java, Scala, etc.
Assists in adopting best practices in reporting and analysis including data integrity, test design, validation, and data quality and analysis.
Experienced with data replication using Qlik. (Should also have a Snowflake, Oracle, SQL, dbt skills)
Responsibilities:
The assigned resources will perform the following activities at the direction of the client.
Design, build, test, and implement data pipelines and integration with client Snowflake Cloud Data
Warehouse per best practices and client IT policies and procedures.
Support client end user testing
Support data validation, data quality and analysis activities as requested by client
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.