Data Warehousing

Job Title: IT - Software Developer III Location work will be performed: VAT103 - VA Remote

Programmer, Data Warehousing; Senior - (Remote)

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 USPS Data Asset Services Program Managers.

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.

Additional Provisions:
Must be able to obtain a Position of Public Trust Clearance
Pass both a client mandated clearance process to include drug screening, criminal history check and credit check.
Once candidate s resume is approved and interview passed, the agency is responsible for providing drug screening. Failure to submit the drug screening results will delay the security clearance process.
If a candidate is given an interim clearance, continuation of employment is then based on the candidate receiving a sensitive clearance.
Candidate must have lived in the United States for the past 5 years.
Cannot have more than 6 months travel outside the United States within the last five years. Military Service excluded. (Exception does not include military family members.)
All overtime must be pre-approved in writing by the client manager or his/her designated representative.
Agency will not be reimbursed for overtime charges without previous written authorization. Authorized overtime will be reimbursed at straight time.