View all jobs
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:
Required Education/Certifications:
Minimum Required Experience:
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.
Guiding Principles
PTP offers a comprehensive benefits program:
Senior ETL (Extract-Transform-Load) Developer
Tampa, FL| Job Title: | Senior ETL Developer |
| Job Location: | Tampa, FL |
| Salary: | Competitive, Depends on Qualifications |
| Clearance: | None |
| Travel: | Possible travel is anticipated |
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
Required Education/Certifications:
- 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.
Guiding Principles
- Satisfy the customer - "Exceed expectations"
- Set the Example - "Be out front"
- Be Responsive - "Timing is everything"
- Persevere - "Find a way"
PTP offers a comprehensive benefits program:
- Medical insurance
- Dental insurance
- Vision insurance
- Supplemental benefits (Short Term Disability, Cancer & Accident).
- Employer-sponsored Basic Life & AD&D Insurance
- Employer-sponsored Long-Term Disability
- Employer-sponsored Value Adds – FreshBenies
- 401(k) with matching
- 10 Paid Holidays
- 120 hours PTO accrual per year