2 days old

Data Warehouse Programmer/Analyst Senior Technical Specialist

Raleigh, NC 27603
Apply Now
Apply on the Company Site
Business Group Highlights

Civilian, State and Local

Perspectas Civilian, State and Local segment partners with the U.S. Federal Civilian State and Local governments to provide infrastructure services, business solutions, and digital transformation services that help them achieve policy objectives and integrate citizen-centric services.


  • Scope and assess change requests and reported defects in order to provide recommended solutions and associated level of effort and time estimates
  • Develop ETL design adhering to the EDW ETL Development
  • Standards for a large, complex Teradata warehouse environment
  • Develop Ab Initio ETL adhering to the Postal Ab Initio ETL Development standards for a large, complex ETL environment
  • Perform application development, enhancement, and maintenance support for ETL application code for services ranging from simple to extremely complex
  • Provide Ab Initio development technical support to other Ab Initio developers.
  • Perform necessary quality review steps for all applications including peer review of code, design of test plans, implementation, and base performance validation
  • Compliance to and technical guidance on issues relating to configuration management/change control standards and process for ETL code
  • Design, development, and continual improvement of test scripts
  • Development and implementation of test plans for all program changes
  • Completion of all mandatory application documentation per relevant USPS standards and guidelines
  • Compliance to all USPS guidelines and standards for systems security
  • Ability to evaluate, plan, manage, track, and provide status on system
  • maintenance, enhancement, and support activities at a task level
  • Provide advanced support for all production failures as assigned and support
  • And comply with all USPS problem management standards and processes
  • Be available for on-call response in order to provide the EDW, EDS, and CDAS applications
  • With a 24X7 emergency response capability.
  • Normal work schedule 8-hour/day Monday through Friday. Need to be flexible to work off hours and be available to travel as needed to support business efforts.


Specific ability with the following languages, tools and utilities 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 EDW Support
  • Teradata Utilities for EDW 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

About Perspecta

What matters to our nation, is what matters to us. At Perspecta, everything we do, from conducting innovative research to cultivating strong relationships, supports one imperative: ensuring that your work succeeds. Our company was formed to bring a broad array of capabilities to all parts of the public sectorfrom investigative services and IT strategy to systems work and next-generation engineering.

Our promise is simple: never stop solving our nations most complex challenges. And with a workforce of approximately 14,000, more than 48 percent of which is cleared, we have been trusted to just that, as a partner of choice across the entire sector.

Perspecta is an AA/EEO Employer - Minorities/Women/Veterans/Disabled and other protected categories.

Email this job to a friendRefer
Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed

As a government contractor, Perspecta abides by the following provision
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor's legal duty to furnish information. 41 CFR 60-1.35(c)


  • Information Technology
Posted: 2020-05-24 Expires: 2020-06-23

With offerings in mission services, digital transformation and enterprise operations, our team of 14,000 engineers, analysts, investigators and architects work tirelessly to create innovative solutions. We have the expertise and experience not only to devise solutions, but to execute on them successfully.

Sponsored by:
ADP Logo

Before you go...

Our free job seeker tools include alerts for new jobs, saving your favorites, optimized job matching, and more! Just enter your email below.

Share this job:

Data Warehouse Programmer/Analyst Senior Technical Specialist

Raleigh, NC 27603

Join us to start saving your Favorite Jobs!

Sign In Create Account
Powered ByCareerCast