Sr ETL Ab Initio Consultant at Idexcel
Raleigh, NC
About the Job
Job Title: Sr ETL Ab Initio Consultant
Location: Raleigh, NC - In the office for first 2 months, then remote 3 days a week and 2 days in the office
Duration: Long Term
Description:
Under general supervision, responsible for product support and maintenance of the data warehouse. Performs data warehouse design and construction. Codes and documents scripts and stored procedures. Designs and implements data strategy methods. Develops appropriate programs and systems documentation. Assists with metadata repository management. Prepares and implements data verification and testing methods for the data warehouse. Creates index and view scripts. Performs all functional duties independently. Works on high-visibility programs, or mission critical aspects of assigned program(s). Oversees the efforts of direct reporting resources and/or is responsible for the efforts of all staff assigned to a specific job.
Required Skills/Experience: Specific ability with the following languages, tools and utilities is required:
Ab Initio ETL Coding in GDE
Ab Initio Metadata Hub Lineage
Ab Initio TRMC
ANSI SQL and Teradata SQL extensions
Teradata SQL Assistant (a.k.a. QueryMan) for EDS Support
Teradata Utilities for EDS Support:
BTEQ
FastLoad
MultiLoad
FastExport
TPump
Azure/Databricks Support:
Cloud operations
Cloud Governance
Data Engineering
Platform Engineering
Data Integration
Data Observability
AI/ML
In addition, the following UNIX skills are required:
UNIX commands and concepts in order to navigate source code directories, find error logs, perform impact analysis assessments, edit code, version files
Linux Shell scripting in order to read and create driver scripts
In addition, the following Ab Initio skills are required:
A working knowledge of how Ab Initio conducts data extract, transformations, and loading - especially to and from Teradata
Development of graphs, plans, PSETs and how to develop tests and debug
PDL scripting
Additional Required Skills/Experience:
A minimum of ten (10) years experience in software development or related field, with at least 5 years in a data warehouse environment and/or related field ;
A degree from an accredited College/University in Software Engineering, Computer Science, or related discipline is preferred;
Location: Raleigh, NC - In the office for first 2 months, then remote 3 days a week and 2 days in the office
Duration: Long Term
Description:
Under general supervision, responsible for product support and maintenance of the data warehouse. Performs data warehouse design and construction. Codes and documents scripts and stored procedures. Designs and implements data strategy methods. Develops appropriate programs and systems documentation. Assists with metadata repository management. Prepares and implements data verification and testing methods for the data warehouse. Creates index and view scripts. Performs all functional duties independently. Works on high-visibility programs, or mission critical aspects of assigned program(s). Oversees the efforts of direct reporting resources and/or is responsible for the efforts of all staff assigned to a specific job.
Required Skills/Experience: Specific ability with the following languages, tools and utilities is required:
Ab Initio ETL Coding in GDE
Ab Initio Metadata Hub Lineage
Ab Initio TRMC
ANSI SQL and Teradata SQL extensions
Teradata SQL Assistant (a.k.a. QueryMan) for EDS Support
Teradata Utilities for EDS Support:
BTEQ
FastLoad
MultiLoad
FastExport
TPump
Azure/Databricks Support:
Cloud operations
Cloud Governance
Data Engineering
Platform Engineering
Data Integration
Data Observability
AI/ML
In addition, the following UNIX skills are required:
UNIX commands and concepts in order to navigate source code directories, find error logs, perform impact analysis assessments, edit code, version files
Linux Shell scripting in order to read and create driver scripts
In addition, the following Ab Initio skills are required:
A working knowledge of how Ab Initio conducts data extract, transformations, and loading - especially to and from Teradata
Development of graphs, plans, PSETs and how to develop tests and debug
PDL scripting
Additional Required Skills/Experience:
A minimum of ten (10) years experience in software development or related field, with at least 5 years in a data warehouse environment and/or related field ;
A degree from an accredited College/University in Software Engineering, Computer Science, or related discipline is preferred;