Purpose People, Technology and Processes, LLC is seeking a Senior ETL Developer to provide Extract-Transform-Load (ETL) processes and the management of its data ingestion, validation, and integrity checking workflows. The developer will support the design, testing, implementation, and maintenance of the ETL processes for delivery of economics research and bank supervision data. Support includes creating, maintaining, defect resolution, and enhancements of existing and new data products using technologies including SAS Base, Python, Pearl, and Bash scripts. *****THIS POSITION IS CONTINGENT UPON AWRD*****
Responsibilities include, but are not limited to:
Consulting with the data management team to find data needs, extracting data from databases, move it across to target DBs after necessary processing, and testing it upon completion.
Working with various business and technical people to understand the systems, data sources, business goals, technical goals, timelines, and financial impacts of multiple data conversion projects
Perform deep analysis of the data in source and target systems in order to document detailed data mapping requirements
Analyzing data quality, data availability, and defining data transformations
Consulting with data management teams to get a big-picture idea of the company’s data storage needs
Building data ingestion pipelines to ingest data from API, SFTP and Streams
Focusing on creating reusable components to be leveraged on future conversions
Developing detailed metrics related to all data migrations to report conversion progress and error rates
Working in a team environment where knowledge and reusable components are proactively shared
Utilizing procedural programming language or scripting language skills to code the required data transformations
Bachelor's degree in Computer Science, Information Systems, or equivalent background or experience (preferred).
Minimum Required Experience:
Fifteen (15) years of experience programming in Base SAS/SAS Macros,
SAS display manager, SAS coding to perform ETL
Fifteen (15) years of experience developing/maintaining Linux shell scripting
Ten (10) years of experience using Python to perform ETL functions
Six (6) years of experience using Perl to perform ETL
Four (4) years of experience using Tableau
Ten (10) years of experience using SQL
Two (2) years of experience working with applications using ETL, Database services available in AWS (Redshift, Aroura, Glue, Lambda, and AMR)
Two (2) years of experience working with applications using Amazon S3 (or similar).
Must be authorized to work in the United States
About the company: As a Service Disabled, Veteran Owned Small Business (SDVOSB) we are a provider of Information Technology (IT) professional services, software solutions and professional development training. Our core competencies evolved from leveraging IT enablers for knowledge management with an emphasis on Web Based Knowledge Portals and Portal Services, Server/System Services, SharePoint Development and System Administration and SQL Server Services. Our capabilities have expanded to include software development, technical training support and field support services.
Satisfy the customer - "Exceed expectations"
Set the Example - "Be out front"
Be Responsive - "Timing is everything"
Persevere - "Find a way"
Benefits PTP offers a comprehensive benefits program:
Supplemental benefits (Short Term Disability, Cancer & Accident).