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
- 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:
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.
Pay Range: There are a host of factors that can influence final salary including, but not limited to, geographic location, Federal Government contract labor categories and contract wage rates, relevant prior work experience, specific skills and competencies, education, and certifications. Our employees value the flexibility at CACI that allows them to balance quality work and their personal lives. We offer competitive compensation, benefits and learning and development opportunities. Our broad and competitive mix of benefits options is designed to support and protect employees and their families. At CACI, you will receive comprehensive benefits such as; healthcare, wellness, financial, retirement, family support, continuing education, and time off benefits. Learn more here
The proposed salary range for this position is:
$78,700 - $165,300