Senior Data Warehousing Programmer
Posted 1 week ago by 1751613438
Negotiable
Outside
Remote
USA
Summary: The Senior Data Warehousing Programmer role requires a minimum of ten years of experience in software development, focusing on the development and maintenance of applications that provide ETL services. The position demands expertise in Ab Initio ETL coding, SQL, UNIX commands, and various data warehousing techniques. Additionally, the candidate should possess strong communication skills and experience in mentoring less experienced personnel. This role is remote and classified as outside IR35.
Key Responsibilities:
- Development and maintenance of applications providing ETL services.
- Ab Initio ETL coding in GDE and related tools.
- Utilization of ANSI SQL and Teradata SQL extensions.
- Execution of UNIX commands and Linux shell scripting.
- Development of graphs, plans, PSETs, and debugging tests in Ab Initio.
- Interaction with Microstrategy and other OLAP tools.
- Understanding of Data Warehouse modeling techniques.
- Web API development and cloud technology knowledge.
- Design and performance tuning of BI metrics and dashboards.
- Training and mentoring less experienced personnel.
- Authoring software-related documentation.
Key Skills:
- Minimum of ten years experience in software development.
- Degree in Software Engineering, Computer Science, or related discipline preferred.
- Proficiency in Ab Initio ETL coding and related tools.
- Strong knowledge of ANSI SQL and Teradata SQL extensions.
- Experience with UNIX commands and Linux shell scripting.
- Understanding of data extract, transformations, and loading processes.
- Knowledge of Microstrategy and OLAP tools.
- Familiarity with Data Warehouse modeling techniques.
- Experience in Web API development and cloud technology.
- Excellent communication skills.
Salary (Rate): undetermined
City: undetermined
Country: USA
Working Arrangements: remote
IR35 Status: outside IR35
Seniority Level: undetermined
Industry: IT
Note: A minimum of ten (10) years experience in software development
Job Description:
All work and duties are focused on development and maintenance of applications providing ETL services in support of the Postal Data Asset Services group.
- 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.