Take2 Consulting, LLC · 18 hours ago
Senior ETL Developer
Take2 Consulting is seeking an experienced ETL Developer to support a federal law enforcement agency’s Resource Planning Office. This role supports critical data, analytics, and reporting functions used by senior government leadership.
Responsibilities
Design, develop, and enhance ETL mappings and workflows using Informatica and/or PL/SQL
Modify and optimize existing ETL processes, including performance tuning and troubleshooting
Perform hands-on technical and functional work with Oracle, PostgreSQL, Informatica, MicroStrategy, and AWS
Support a business intelligence and analytics team through ETL development, database procedures, and testing
Debug and resolve production ETL and data pipeline issues
Support data warehouse operations and dimensional data models
Qualification
Required
Minimum of 1 year of professional experience (Junior LCAT)
Hands-on ETL development experience (Informatica strongly preferred)
Strong SQL development experience
Working knowledge of dimensional data models and data warehouse concepts
Experience troubleshooting and supporting production data environments
Ability to performance tune ETL mappings and SQL queries
Active Top Secret clearance