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!
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
Experience with a version control system (e.g., SubVersion)
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.
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 www.Leidos.com.
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 Leidos.com 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.