Clearance: Public Trust
Job Description: Under general supervision, responsible for product support and maintenance of the data warehouse. Performs data warehouse design and construction. Codes and documents scripts and stored procedures. Designs and implements data strategy methods. Develops appropriate programs and systems documentation. Assists with metadata repository management. Prepares and implements data verification and testing methods for the data warehouse. Creates index and view scripts. Performs all functional duties independently. Works on high-visibility programs, or mission-critical aspects of assigned program(s). Oversees the efforts of direct reporting resources and/or is responsible for the efforts of all staff assigned to a specific job. Required Skills/Experience: Specific abilities for the Performance Data Engineer: The knowledge, skills, and abilities of the Teradata relational database must be far and above that typically found in application developers. Significant experience with the Teradata optimizer is required; the ability to read SQL "explain" plans and take action to effectively utilize the massive parallel nature of the database engine. A thorough understanding of the internal "DBC Accounting" information is expected in order to effectively measure the performance of application code. Specific ability with the following languages, tools and utilities is 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 Azure/Databricks Support: Cloud operations Cloud Governance Data Engineering Platform Engineering Data Integration Data Observability AI/ML 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 Additional Required Skills/Experience:
A minimum of ten (10) years experience in software development or related field, with at least 5 years in a data warehouse environment and/or related field. A degree from an accredited College/University in Software Engineering, Computer Science, or a related discipline is preferred. Able to perform all functional duties independently on high-visibility programs, or mission-critical aspects of a given program. Able to oversee the efforts of direct reporting resources and/or be responsible for the efforts of all staff assigned to a specific job. Experience training/mentoring less experienced personnel. Extensive experience with data warehouse design, construction, and/or maintenance, including design and implementation of data strategy methods, coding and documentation of scripts and stored procedures, and creation of index and view scripts. Extensive experience with the development of data warehouse programs and system documentation. Able to assist with metadata repository management. Extensive experience preparing and implementing data verification and testing methods for data warehouses. Able to obtain Postal clearance. Excellent communication skills. About Ohm Systems, Inc: Ohm Systems, Inc. specializes in IT and Healthcare staffing services, dedicated to linking highly skilled professionals with our public and private clients across the United States. Our track record showcases our commitment to delivering outstanding staffing and consultancy solutions to our clients. We prioritize diversity and inclusivity and take pride in being an employer that promotes equal opportunities and affirmative action. Our goal is to foster an inclusive work environment that embraces individuals from all backgrounds, irrespective of their gender, race, or orientation.
