Senior Data Integration Engineer - ETL & Teradata

RandomTrees LLC; Texas; On-site; USD 90,000 - 120,000; Full time

Job summary

RandomTrees LLC seeks an IT Consultant/Analyst to gather business needs via user discussions, produce a comprehensive BRD, study system flow and data usage, and perform impact analysis to define feasible operations.

The role requires creating low-level technical designs for ETL using Unix, Teradata, and PowerShell, building scripts with BTEQ/MLOAD/TPT/Fast Export, and developing workflows with proper mappings; travel to client sites in USA is required.

Qualifications

• Experience gathering requirements and documenting BRDs.
• Ability to analyze system flow and data usage.
• Experience with ETL design and Teradata basics.

Responsibilities

• Gather business needs via discussions with users and create BRD.
• Study system flow, data usage and perform impact analysis.
• Define feasibility of operation and develop a solution.
• Create low-level technical design documents for ETL stack.
• Build code using Unix scripts, PowerShell, and ETL tools; perform unit tests.
• Create workflows and sessions; define mapping parameters and variables.
• Manage extraction, transformation, and loading to the EDW; travel to client sites.

Skills

Business Analysis

Requirements Gathering

Documentation

Unit Testing

Travel Readiness

Education

Master's degree in CS/IT/Engineering

Bachelor's degree + 5 years experience

Tools

Unix

Teradata

PowerShell

BTEQ

MLOAD

TPT

Fast Export

Job description

RandomTrees LLC seeks an IT Consultant/Analyst to gather business needs via user discussions, produce a comprehensive BRD, study system flow and data usage, and perform impact analysis to define feasible operations.

The role requires creating low-level technical designs for ETL using Unix, Teradata, and PowerShell, building scripts with BTEQ/MLOAD/TPT/Fast Export, and developing workflows with proper mappings; travel to client sites in USA is required.