PL/SQL Developer w/ETL Experience (Telework Available)

　　Job Category: Information Technology

　　Time Type: Full time

　　Minimum Clearance Required to Start: Secret

　　Employee Type: Regular

　　Percentage of Travel Required: Up to 10%

　　Type of Travel: Local

　　What You’ll Get to Do

　　CACI is seeking an experienced PL/SQL developer with ETL experience to join our program as a member of our team supporting our DOD clients. In this role, you will perform as a developer providing PL/SQL expertise on our web based DOD financial management systems. You will also support a new effort involving migration of data from legacy systems into new formats for the target system in support of our customer.

　　You will play a key role in supporting a new data transformation and migration project moving data from a legacy source to a new target system. You will work with our business systems analysts to understand business needs and translate those into solutions for our government client. You will participate in the planning, design, development, and support of new financial management applications to modernize legacy systems. You will be part of a team where complex problem solving, and communication skills are critical to success.

　　Your contributions will directly impact the success of the customers' mission, our team, and ultimately CACI! In return, CACI will provide you with a company that fosters a culture based on integrity, strong ethics, quality work, and professionalism, while supporting your career growth aspirations.

　　More About the Role

　　In this role you will

　　Work closely with cross-functional teams to help create and maintain source to target data mappings and transformation business rules.

　　Develop migration scripts using PL SQL and SQL related technologies to perform data extract, transformation and load.

　　Perform the migration of data from legacy systems to new system.

　　Perform data profiling and validation of source to target migrated data

　　Identify data anomalies, address data issues by applying data validation rules and remediation routines

　　Recommend improvements to processes and procedures to increase productivity, reduce maintenance cycles, and improve quality delivery.

　　Design, develop, unit test, debug, document, and maintain program code.

　　Support formal testing before code is deployed to production

　　Work cooperatively with functional and technical staff, to meet timelines and deliverables

　　You’ll Bring These Qualifications

　　Bachelor’s degree in relevant field or equivalent work experience

　　10+ years software development experience

　　10+ years PL/SQL experience

　　10+ years experience supporting Oracle Forms/APEX applications development

　　Experience with extract, transform, load (ETL) of data from diverse databases and file structures to leverage in a different target system

　　Experience in data validation and cleaning to ensure the quality and integrity of data

　　Must have strong analytical skills and can demonstrate strong problem-solving skills

　　Minimum current DoD Secret clearance

　　Must be US citizen

　　These Qualifications Would Be Nice to Have

　　Fill in this section: (This section should include any preferred or desired qualifications or attributes)

　　Experience writing complex CTE SQL queries

　　Experience with Toad, DBeaver or SQL Developer

　　Experience with Azure DevOps

　　Experience with Git

　　Experience with Postgres

　　Experience working with .Net development projects

　　Experience with DoD Oracle implementations

　　What We Can Offer You:

　　We’ve been named a Best Place to Work by the Washington Post.

　　Our employees value the flexibility at CACI that allows them to balance quality work and their personal lives.

　　We offer competitive benefits and learning and development opportunities.

　　We are mission-oriented and ever vigilant in aligning our solutions with the nation’s highest priorities.

　　For over 60 years, the principles of CACI’s unique, character-based culture have been the driving force behind our success.

　　Company Overview: At CACI, you will have the opportunity to make an immediate impact by providing information solutions and services in support of national security missions and government transformation for Intelligence, Defense, and Federal Civilian customers. CACI is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, status as a protected veteran, or any other protected characteristic.