ETL Developer/Administrator

JYG Innovations; Fairborn (OH); On-site; USD 70,000 - 100,000; Full time

Job summary

An innovative solutions provider seeks an experienced ETL Developer/Administrator to join their team. This role involves designing and maintaining ETL processes using Informatica PowerCenter, ensuring data integration from various sources into Oracle databases. You'll have the opportunity to automate workflows and enhance operational efficiency while collaborating with business users to meet their needs. If you have a strong background in data transformation and enjoy problem-solving, this position offers a chance to make a significant impact in a dynamic environment.

Qualifications

• Proven experience in ETL development with Informatica PowerCenter.
• Strong SQL and PL/SQL skills required.

Responsibilities

• Design and maintain ETL processes using Informatica PowerCenter.
• Automate ETL workflows for operational efficiency.

Skills

Informatica PowerCenter

Oracle databases

SQL

PL/SQL

Data modeling

Problem-solving

Communication

Job description

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.

Key Responsibilities:

• 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.

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.

Certifications:

• Possess or be willing to obtain IAT Level II certification (e.g., CompTIA Security+ CE, CySA+, or GSEC) within 60 days of hire, in accordance with DoD 8570 requirements.

JYG Innovations is committed to hiring and retaining a diverse workforce. JYG Innovations is an equal opportunity/affirmative action employer and does not discriminate on the basis of race, color, creed, sex, national origin, religion, age, disability, pregnancy or veteran status. We welcome the employment of women, minorities, veterans and individuals with disabilities in our workforce. If you are in need of special assistance, please contact our Human Resources Department. Interested parties may view our Affirmative Action Plan for Veterans and Individuals with Disabilities by contacting the Human Resources Department. JYG Innovations participates in E-Verify.