Overview
Skills
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