Senior Data Warehousing Programmer

Join to apply for the Senior Data Warehousing Programmer role at PlanIT Group, LLCJoin to apply for the Senior Data Warehousing Programmer role at PlanIT Group, LLCGet AI-powered advice on this job and more exclusive features.PlanIT Group is seeking a Senior Data Warehousing Programmer to support our Federal customer in the Washington, DC area. The ideal candidate will focus on development and maintenance of applications providing ETL services in support of the customer Data Asset Services team. 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.Job Title: Senior Data Warehousing ProgrammerStart Date: 07/21/25Location: RemoteDuration: One year plus annual extensionsSenior Data Warehousing ProgrammerAll work and duties are focused on development and maintenance of applications providing ETL services in support of the customer Data Asset Services team. 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 Program Managers.The following describes the abilities, job categories, and tasks the resources are expected to perform.Ab Initio ETL Coding in GDEAb Initio Metadata Hub LineageAb Initio TRMCANSI SQL and Teradata SQL extensionsTeradata SQL Assistant (a.k.a. QueryMan) for EDS SupportTeradata Utilities for EDS Support:BTEQFastLoadMultiLoadFastExportTPumpIn Addition, The Following UNIX Skills Are RequiredUNIX commands and concepts in order to navigate source code directories, find error logs, perform impact analysis assessments, edit code, version filesLinux Shell scripting in order to read and create driver scriptsIn Addition, The Following Ab Initio Skills Are RequiredA working knowledge of how Ab Initio conducts data extract, transformations, and loading - especially to and from TeradataDevelopment of graphs, plans, PSETs and how to develop tests and debugPDL scriptingThe Following Additional Skills Are RequiredA 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/ExperienceA minimum of ten (10) years of experience in software developmentA 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.Additional ProvisionsMust be able to obtain a Public Trust ClearancePass both a client mandated clearance process to include drug screening, criminal history check and credit check.All candidates must be a US Citizen or US Permanent Resident.Candidate must have lived in the United States for the past 5 years.Cannot have more than 6 months travel outside the United States within the last five years. Military Service excluded. (Exception does not include military family members.)#CJJOBSSeniority levelSeniority levelMid-Senior levelEmployment typeEmployment typeContractJob functionJob functionInformation TechnologyIndustriesDefense and Space Manufacturing, Software Development, and Armed ForcesReferrals increase your chances of interviewing at PlanIT Group, LLC by 2xSign in to set job alerts for “Senior Data Warehouse Engineer” roles.Chantilly, VA $90,300.00-$189,600.00 2 weeks agoSenior Data Mining and Analytics Engineer (Security Clearance Required) - Remote work - Local DC Metro or FLArlington, VA $107,936.00-$183,491.00 6 days agoSenior Engineer- Data Efficiency/DatalakehouseMcLean, VA $130,000.00-$140,000.00 5 days agoMcLean, VA $120,000.00-$140,000.00 1 week agoBethesda, MD $140,000.00-$180,000.00 1 day agoWashington, DC $140,000.00-$180,000.00 6 hours agoReston, VA $89,203.00-$151,646.00 14 hours agoHerndon, VA $111,850.00-$131,735.00 1 week agoColumbia, MD $140,000.00-$180,000.00 6 hours agoSenior Software Engineer (Data-Oriented)Montgomery County, MD $137,439.00-$167,981.00 7 hours agoSenior Engineer - Finance Data SpecialistChevy Chase, MD $100,000.00-$215,000.00 4 days agoSenior Staff Data Engineer - AI SolutionsSenior Software Engineer – Data Lakehouse PlatformWe’re unlocking community knowledge in a new way. Experts add insights directly into each article, started with the help of AI. #J-18808-Ljbffr