Overview
Remote
Depends on Experience
Contract - W2
Contract - 6 Month(s)
Skills
Ab Initio ETL Coding
Ab Initio GDE
Ab Initio Metadata Hub Lineage
Ab Initio TRMC
ANSI SQL
Teradata SQL
Teradata SQL Assistant (QueryMan)
Teradata BTEQ
Teradata FastLoad
Teradata MultiLoad
Teradata FastExport
Teradata TPump
UNIX commands
UNIX concepts
Linux Shell scripting
error log analysis
impact analysis
code editing
file versioning
Ab Initio data extraction
Ab Initio data transformation
Ab Initio data loading
Teradata integration
graph development
plan development
PSET development
test development
debugging
PDL scripting
MicroStrategy
OLAP tools
Third-Normal-Form modeling
Dimensional modeling
ETL performance optimization
structured reporting
unstructured data analysis
Web API development
streaming data analysis
Kafka
MQSeries
JMS
Cloud technology
cloud development
cloud architecture
BI metrics
dashboard design
performance tuning
software documentation
training and mentoring
communication skills
Job Details
No C2C/H1B/EAD - Since this is a government contract.
Please note that this is a 6-month contract position.
The following describes the abilities, job categories, and tasks the resources are expected to perform.
- 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
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
The following additional skills are required:
- A working knowledge of how Microstrategy and other OLAP tools interact with Teradata.
- A working knowledge of the major competing Data Warehouse modeling techniques (Third-Normal-Form and Dimensional modeling) and how data modeling decisions affect the performance of ETL, structured report queried, and unstructured data analysis.
- A working knowledge of Web API development.
- A working knowledge of storing, reading and analyzing streaming data – i.e., kafka, mqseries, or similar technologies, such as JMS.
- A working knowledge of Cloud technology - developing and architecting.
- A working knowledge of BI metrics and/or dashboards design and performance tuning.
Additional Required Skills/Experience:
• A minimum of ten (10) years experience in software development
• A degree from an accredited College/University in Software Engineering, Computer Science, or related discipline is preferred;
• Able to perform all functional duties independently;
• Experience training/mentoring less experienced personnel;
• Experience authoring or contributing to software-related documentation such as requirements specifications, design documents, technical manuals, and user manuals;
• Excellent communication skills.
- 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
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
The following additional skills are required:
- A working knowledge of how Microstrategy and other OLAP tools interact with Teradata.
- A working knowledge of the major competing Data Warehouse modeling techniques (Third-Normal-Form and Dimensional modeling) and how data modeling decisions affect the performance of ETL, structured report queried, and unstructured data analysis.
- A working knowledge of Web API development.
- A working knowledge of storing, reading and analyzing streaming data – i.e., kafka, mqseries, or similar technologies, such as JMS.
- A working knowledge of Cloud technology - developing and architecting.
- A working knowledge of BI metrics and/or dashboards design and performance tuning.
Additional Required Skills/Experience:
• A minimum of ten (10) years experience in software development
• A degree from an accredited College/University in Software Engineering, Computer Science, or related discipline is preferred;
• Able to perform all functional duties independently;
• Experience training/mentoring less experienced personnel;
• Experience authoring or contributing to software-related documentation such as requirements specifications, design documents, technical manuals, and user manuals;
• Excellent communication skills.
All work and duties are focused on development and maintenance of applications providing ETL services in support of the Postal Data Asset Services group. The tasks to be performed under the scope of this statement of work must be completed under the direction, oversight, and prioritization of the Data Technology Services Manager and/or designated Data Asset Services Program Managers.
Applicants must provide their phone number. Reference job number A4839.
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.