PlanIT Group, LLC
Senior Data Warehousing Programmer
PlanIT Group, LLC, Raleigh, North Carolina, United States, 27601
Overview
Senior Data Warehousing Programmer
role at
PlanIT Group, LLC
focuses on the development and maintenance of applications providing ETL services in support of the Data Asset Services group. Tasks are to be completed under the direction, oversight, and prioritization of the Data Technology Services Manager and/or designated Data Asset Services Program Managers. Responsibilities
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 UNIX Skills
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 Skills
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 Additional Skills
A working knowledge of how Microstrategy and other OLAP tools interact with Teradata A working knowledge of the major data warehouse modeling techniques (Third-Normal-Form and Dimensional modeling) and how data modeling decisions affect the performance of ETL, structured report querying, and unstructured data analysis A working knowledge of Web API development A working knowledge of storing, reading and analyzing streaming data (e.g., 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 Experience and Education
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 Seniority level
Mid-Senior level Employment type
Contract Job function
Information Technology Industries
Defense and Space Manufacturing, Software Development, and Armed Forces
#J-18808-Ljbffr
Senior Data Warehousing Programmer
role at
PlanIT Group, LLC
focuses on the development and maintenance of applications providing ETL services in support of the Data Asset Services group. Tasks are to be completed under the direction, oversight, and prioritization of the Data Technology Services Manager and/or designated Data Asset Services Program Managers. Responsibilities
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 UNIX Skills
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 Skills
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 Additional Skills
A working knowledge of how Microstrategy and other OLAP tools interact with Teradata A working knowledge of the major data warehouse modeling techniques (Third-Normal-Form and Dimensional modeling) and how data modeling decisions affect the performance of ETL, structured report querying, and unstructured data analysis A working knowledge of Web API development A working knowledge of storing, reading and analyzing streaming data (e.g., 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 Experience and Education
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 Seniority level
Mid-Senior level Employment type
Contract Job function
Information Technology Industries
Defense and Space Manufacturing, Software Development, and Armed Forces
#J-18808-Ljbffr