ABOUT JYG INNOVATIONS

JYG Innovations (JYG) is a professional solutions and services company focused on providing innovative and exceptional service in the Defense, State/Local and Commercial sectors. With a primary focus on IT Solutions, Cyber Security, Research and Analysis, and Medical/Clinical Staffing, JYG continues to receive exceptional customer satisfaction surveys due to the outstanding technical expertise and performance of its employees and strategic partners.
Job Title: ETL Developer/Administrator
Location: Wright Patterson Air Force Base, Ohio
Employment Type: Full Time, 100% On-Site
Targeted Start Date: 28 April 2025

JOB DESCRIPTION:

We are seeking an experienced ETL Developer/Administrator to provide comprehensive data integration services using Informatica PowerCenter. The ETL Developer/Administrator will be responsible for extracting data from diverse sources, transforming it per defined business rules, and loading it into an Oracle database. The ideal candidate will have a strong background in data transformation, process automation, and documentation.

REQUIRED QUALIFICATIONS:

• Proven experience with Informatica PowerCenter and Oracle databases in an ETL development/administration role.
• Strong SQL and PL/SQL skills.
• Experience in designing and implementing automated ETL processes.
• Familiarity with data modeling and reporting schema design.
• Excellent analytical, problem-solving, and communication skills.
• Ability to work independently with minimal supervision while delivering high-quality results.

• Design, develop, and maintain ETL processes using Informatica PowerCenter to support data integration from various source databases and file formats.
• Implement complex transformation logic based on business rules and load transformed data into Oracle target schemas.
• Automate ETL workflows and procedures to the fullest extent possible for operational efficiency and reliability.
• Ensure weekly data refreshes, with all processing completed and available by Monday 8:00 AM ET, including data extraction, staging, transformation, and final reporting.
• Conduct full software development lifecycle tasks, including research, analysis, design, coding, testing, deployment, and support of ETL solutions.
• Maintain and annually update technical documentation, particularly the Application Design Description, stored on the project SharePoint site.
• Collaborate with business users, system analysts, and other team members to gather requirements and implement solutions that meet system and functional needs.
• Troubleshoot and resolve issues related to ETL processing, data quality, and performance.