To our valued Leidos candidates:

Coronavirus is on everyone's mind with the effects being felt around the world. The markets are volatile, and we're all concerned for the health and safety of our families, friends, and colleagues. Please know that we're taking all necessary measures to safeguard our employees, customers and the communities in which we live, including following all recommended best practices around social distancing.

With that in mind, in an abundance of caution, we are canceling all face to face career events, such as job fairs and open house events. In the coming days and weeks, we will be hosting career events virtually, using our online chat tools so that we may continue our hiring practice safely and securely. You can find available virtual career events at

We are using telephone meetings and online chats via Brazen to conduct interviews and hiring discussions, and we are offering options for video interviews so that you can have a virtual face to face meeting with your potential new leader. We do not conduct interviews or extend offers via text or chat based social media, such as WhatsApp or MySpace.

Leidos will never ask you to provide payment-related information at any part of the employment application process, nor will Leidos ever advance money as part of the hiring process. And Leidos will communicate with you only through emails that are generated by automated system. If you receive an email purporting to be from Leidos that asks for payment-related information or any other personal information, please report the email to Chris Scalia, Leidos’ Senior Vice President of Talent Acquisition, at [email protected].

As a company, as a country, as a world, we have confronted challenging moments before. We are confident that, guided by our values and the strength of our community as well as the commitment we have to the important work we do each day, we will find our way through this time together. We will do this with the care and concern for one another and the common good that defines. Please keep those impacted by the virus in your thoughts.

Close Window
Join our talent network
Skip to main content

Job #: R-00119887
Location: Mechanicsburg, PA
Category: Software Engineering
Schedule (FT/PT): Full Time
Travel Required: Yes, 10% of the time
Shift: Day
Remote Type: Remote
Clearance: Secret
Referral Eligibility: Eligible
Referral Bonus Amount: $2,000
Group: Defense

This job posting is no longer active.

Share: mail twitter linkedin


Are you ready for a rewarding and inspiring career?

At Leidos, we deliver innovative solutions through the efforts of our diverse and talented people who are dedicated to our customers’ success. We empower our teams, contribute to our communities, and operate sustainable. Everything we do is built on a commitment to do the right thing for our customers, our people, and our community. Our Mission, Vision, and Values guide the way we do business.

Your greatest work is ahead!

The Leidos Software Factory has openings for talented ODI Software Engineer to come work in our state of the art facility in Mechanicsburg, PA. The responsibilities for this position will be to design, develop and implement ELT processes for database driven application and services within a Department of Defense asset visibility and decision support application.

The program needs a hands on Oracle ODI Developer to build appropriate ELT processes in an Oracle environment. Work in a team environment to research, design, develop, and support a software system which is undergoing a modernization. The candidate needs to have at least four years (five years plus preferred) experience with Oracle ODI and must also have experience in developing and supporting data warehouse applications. The candidate must have a thorough understanding of ELT architectures and must be able to effectively mentor other team members in building robust ELT solutions. The candidate should have strong knowledge of SQL and experience in working with PL/SQL based applications. Qualified candidates also must have strong experience in data modeling and data profiling activities.

This position will allow for the employee telework after obtaining approval.

If this sounds like the kind of environment where you can thrive, keep reading!

The Mission

Leidos Defense Group provides a diverse portfolio of systems, solutions, and services covering land, sea, air, space, and cyberspace for customers worldwide. Solutions for Defense include enterprise and mission IT, large-scale intelligence systems, command and control, geospatial and data analytics, cybersecurity, logistics, training, and intelligence analysis and operations support. Our team is solving the world’s toughest security challenges for customers with “can’t fail” missions. To explore and learn more, click here!

Are you ready to make an impact? Begin your journey of a flourishing and meaningful career, share your resume with us today!

Your Main Mission:

  • Closely work with functional and architecture teams to analyze business and IT requirements.

  • Design high level as well as low level ELT components that meets functional requirements and performance needs.

  • Build and implement high performance ELT (Extraction, load and Transform) process flows using appropriate ODI components to load packages for data warehousing. Debug mappings to resolve code issues. Perform unit and system testing of ELT packages.

  • Setup security within ODI working closely with the Security and Architecture teams.

  • Implement interfaces for loading Source data into Staging area and Staging data into Dimension and Fact tables of the Reporting Data mart.  

  • Perform housekeeping activities of ODI platform, ODS and data flows.

  •  Create load plans to run the scenarios in a hierarchy of sequential and parallel steps.

  • Develop stored procedures, functions, packages and database triggers using Oracle SQL*Developer and PL/SQL to improve query performance.

  • Perform extensive data modeling activities using standard COTS tools.

  • Extensively work with large Databases in Development, Testing and Production environments.

  • Perform across the SDLC (Software Development Life Cycle) from concept development, design, testing, implementation, integration and deployment.

  • Develop and maintain software technical documentation to assist with software and application maintenance and upgrades.

  • Closely work with the test team to develop test plans and procedures to ensure comprehensive testing of the ELT processes.

  • Review existing programs and assist in making refinements, reducing operating time, and improving current development methods.

  • Collaborate in team environment and develop new solutions within a culture that embraces standard processes and delivery of high quality solutions.

  • Adheres to laws, standards, established guidelines and industry best practices for development and delivery of software applications.

What Sets You Apart:

  • A bachelors degree in Computer Science or related field with 4+ years of related software engineering experience

  • Demonstrated ability to plan, design, develop, test, implement and troubleshoot applications.

  • Proficiency in Oracle ODI 12c (required) – including customizing Knowledge Modules using PL/SQL, Python, and/or Java.

  • Proficiency with working in Oracle 12c or higher environment, SQL and PL/SQL (packages, stored procedures, triggers). Expertise in working with Oracle SQL*Developer.

  • Proficiency in data warehousing concepts, terminology, and architecture. Knowledge of dimensional modeling.

  • Experience working with multiple source/target systems such as Oracle, XML files, flat files and excel documents.

  • General knowledge of DISA STIGS and how they influence and establish best-practices within the IT environment.

  • Goal oriented and self-motivated.

  • Candidate must have the ability to work independently or within a team environment.

  • Strong oral and written communications skills with ability to create software design and engineering documents.

  • Ability to multi-task and deliver high quality work under tight deadlines is essential.

  • Ability to learn, excel and deliver at a quick pace is required.

  • Ability to create easy-to-follow IT documentation for work product design.

  • Must have good communication, interpersonal, writing, and presentation skills.

  • Ability to work in a team environment with peers to accomplish scheduled tasks.

  • Must be a US citizen with ability to obtain a DoD Secret Security Clearance

You Might Also Have:

  • Active DoD security clearance

  • Security+ certification

  • Experience with a version control system (e.g., SubVersion)

Clearance Required:

  • Must be able to obtain an active DoD Secret level clearance within 6 months of employment with Leidos.

Pay Range:

Pay Range $78,000.00 - $141,000.00

The Leidos pay range for this job level is a general guideline only and not a guarantee of compensation or salary. Additional factors considered in extending an offer include (but are not limited to) responsibilities of the job, education, experience, knowledge, skills, and abilities, as well as internal equity, alignment with market data, applicable bargaining agreement (if any), or other law.


About Leidos

Leidos is a Fortune 500® technology, engineering, and science solutions and services leader working to solve the world’s toughest challenges in the defense, intelligence, civil, and health markets. The company’s 47,000 employees support vital missions for government and commercial customers. Headquartered in Reston, Virginia, Leidos reported annual revenues of approximately $14.4 billion for the fiscal year ended December 30, 2022.   For more information, visit

Pay and Benefits

Pay and benefits are fundamental to any career decision. That's why we craft compensation packages that reflect the importance of the work we do for our customers. Employment benefits include competitive compensation, Health and Wellness programs, Income Protection, Paid Leave and Retirement. More details are available here.

Securing Your Data

Beware of fake employment opportunities using Leidos’ name. Leidos will never ask you to provide payment-related information during any part of the employment application process (i.e., ask you for money), nor will Leidos ever advance money as part of the hiring process (i.e., send you a check or money order before doing any work). Further, Leidos will only communicate with you through emails that are generated by the automated system – never from free commercial services (e.g., Gmail, Yahoo, Hotmail) or via WhatsApp, Telegram, etc. If you received an email purporting to be from Leidos that asks for payment-related information or any other personal information (e.g., about you or your previous employer), and you are concerned about its legitimacy, please make us aware immediately by emailing us at [email protected].

If you believe you are the victim of a scam, contact your local law enforcement and report the incident to the U.S. Federal Trade Commission.

Commitment to Diversity

All qualified applicants will receive consideration for employment without regard to sex, race, ethnicity, age, national origin, citizenship, religion, physical or mental disability, medical condition, genetic information, pregnancy, family structure, marital status, ancestry, domestic partner status, sexual orientation, gender identity or expression, veteran or military status, or any other basis prohibited by law. Leidos will also consider for employment qualified applicants with criminal histories consistent with relevant laws.

This job posting is no longer active.

Talent Community

Join our Talent Community to create a profile, enabling a streamlined application process and to help our recruiters better understand your areas of expertise and interest.

Join our Talent Community