Programmer, Data Warehousing; Senior @ Remote

Overview

Remote
$55 - $60
Contract - W2
Contract - 12 Month(s)

Skills

Ab Initio ETL Coding in GDE
Ab Initio Metadata Hub Lineage
Ab Initio TRMC
Teradata
SQL
Unix
Linux

Job Details

IDEXCEL Client is Looking for Job Title: Programmer, Data Warehousing; Senior @ Remote

Job Title: Programmer, Data Warehousing; Senior Location: Remote Duration: 12+ Months

Note: New TSS template for candidate submission. Gaps must be explained and resume cannot exceed 4 pages. The PLD cannot provide individualized feedback if resumes are incorrect your candidate will be disqualified.


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 (Client ) Data Asset Services Program Managers.


Required Technical Skills

Ab Initio ETL Tools:

  • Ab Initio ETL Coding in GDE
  • Ab Initio Metadata Hub Lineage
  • Ab Initio TRMC

SQL / Teradata:

  • 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

UNIX / Shell Scripting:

  • UNIX commands and concepts to:
  • Navigate source code directories
  • Find error logs
  • Perform impact analysis assessments
  • Edit code and version files
  • Linux Shell scripting to read and create driver scripts Ab Initio Development:
    • Knowledge of Ab Initio data extract, transformation, and loading (especially with Teradata)
    • Development of graphs, plans, PSETs
    • Development of tests and debugging
    • PDL scripting

    Additional Required Skills:
    • Working knowledge of MicroStrategy and other OLAP tools interaction with Teradata
    • Understanding of Data Warehouse modeling techniques:
    • Third-Normal-Form
    • Dimensional modeling
    • Understanding of how modeling affects ETL, structured report queries, and unstructured data analysis
  • Working knowledge of Web API development
  • Working knowledge of streaming data technologies such as:
  • Kafka
  • MQSeries
  • JMS (or similar)
  • Working knowledge of Cloud technology (development and architecture)
  • Working knowledge of BI metrics and dashboards design and performance tuning
    Additional Required Experience:
    • Minimum of ten (10) years experience in software development
    • Preferred: Degree from an accredited College/University in Software Engineering, Computer Science, or related discipline
    • Able to perform all functional duties independently
    • Experience in training/mentoring less experienced personnel
    • Experience authoring or contributing to documentation:
    • Requirements specifications
    • Design documents
    • Technical manuals
    • User manuals
  • Excellent communication skills
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.