PlanIT Group, LLC · 4 months ago
Senior Data Warehousing Programmer
Raleigh, NC
Contract
Onsite
Senior Level, Lead/Staff
10+ years expPlanIT Group, LLC is focused on providing ETL services in support of the Data Asset Services group. They are seeking a Senior Data Warehousing Programmer to develop and maintain applications while ensuring the performance of ETL processes and interacting with various data technologies.
ConsultingInformation TechnologyManagement Consulting
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 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
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
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
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
Qualification
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 EDS Support
Teradata Utilities for EDS Support: BTEQ, FastLoad, MultiLoad, FastExport, TPump
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
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
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
A minimum of ten (10) years experience in software development
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
Preferred
A degree from an accredited College/University in Software Engineering, Computer Science, or related discipline is preferred
Company
PlanIT Group, LLC
PlanIT Group is an IT and engineering professional services company which provides top-tier talent to various commercial and government customers.
51-200 employees
Funding
Current Stage
Growth StageTotal Funding
$3.55M2020-09-24Series Unknown· $3.55M
Company data provided by crunchbase