Oracle PL/SQL Developer – USPS! ICF is looking for a Data Integration expert, specializing in PL/SQL development for enterprise applications that integrate data from multiple data sources into a cohesive analytical data warehouse to provide business intelligence applications. We need expertise in Analysis, Design, Development, and Administration of commercial BI, Client/Server, ETL, and Web-based applications. The best candidate for this role will have a background in implementing big data solutions, Dimensional Data Modeling, and Data Visualization using real-time analytics and reporting solutions. Full development – packaging, stored procedures, triggers in MS SQL, PL/SQL, data migration/conversion from legacy systems. We need the knowledge and experience working with life cycle and production support/application maintenance in an Agile rapid development environment.
This role is able to be fully remote.
What you’ll be doing:
- Develop complex database processes with PL/SQL containing batch or ETL functionality
- Develop and enhance an existing DataMart in an OLAP schema
- Requirements gathering, design, development, testing, and documentation
- Design logical and physical ERD diagrams, process flow diagrams, or related data processing documentation
- Leverage Oracle 11G/12C features to their fullest on a large-scale multi-terabyte system
- Assist Decision Support team members including DBAs, database developers, requirements analysts, and others, in understanding data and meeting user requirements
- Participate in project workgroups with Subject Matter Experts and stakeholders to understand data specific needs
- Participate in performance tuning activities
- Provide production deployment and production support as needed
- Analyzing and converting business requirements to technical requirements, followed by designing and implementing the solutions
- Involved in all aspects of the software development life cycle; demonstrate abilities to learn both the business processes as well as new and existing technologies
- Work on sprint team in agile, rapid development, and deployment environment.
- Support production application - investigate and resolve production inquiries and issues.
- Requires flexible schedule.
What you must have:
- 5+ years of experience in designing, creating, and developing Oracle database systems
- US Citizenship required by federal contract
What we’d like you to have:
- 3+ years using Spark, Apache Cassandra 2.0, Kafka, Scala, Oracle 11g, Teradata 15.10, SQL/PLSQL, Teradata SQL Assistant 14.10, UNIX, Agile Development, JIRA, Junit, Git, SVN, TOAD
- 3+ years of experience working with IVES and LOC within USPS
- Bachelor's Degree in Computer Science or related IT field
- 5+ years of experience programming/development skills using PL/SQL (package, procedures, functions, triggers) and batch coding skills such as Bulk collections, dynamic SQL, and parallel processing
- 5+ years of experience designing partitioned and non-partitioned tables, indexes, temporary tables and external tables to maximize storage and performance, developing logical and physical data models, and designing OLAP systems
- 5+ years of experience in SQL development, SQL analytics, and tuning skills
- Postal or mailing industry experience
- Excellent analytic, troubleshooting, and performance tuning skills
- Detail-oriented with strong problem-solving skills
- Ability to analyze complex and large amounts of data
- Strong communications skills (both verbal & written)
Working at ICF
ICF is a global advisory and technology services provider, but we’re not your typical consultants. We combine unmatched expertise with cutting-edge technology to help clients solve their most complex challenges, navigate change, and shape the future.
We can only solve the world's toughest challenges by building an inclusive workplace that allows everyone to thrive. We are an equal opportunity employer, committed to hiring regardless of any protected characteristic, such as race, ethnicity, national origin, color, sex, gender identity/expression, sexual orientation, religion, age, disability status, or military/veteran status. Together, our employees are empowered to share their expertise and collaborate with others to achieve personal and professional goals. For more information, please read our EEO & AA policy.
Reasonable Accommodations are available, including, but not limited to, for disabled veterans, individuals with disabilities, and individuals with sincerely held religious beliefs, in all phases of the application and employment process. To request an accommodation please email [email protected] and we will be happy to assist. All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodations. Read more here: Requesting an Accommodation for the ICF interview process.
Read more about workplace discrimination rights, the Pay Transparency Statement, or our benefit offerings which are included in the Transparency in (Benefits) Coverage Act.
Candidate AI Usage Policy
At ICF, we are committed to ensuring a fair and equitable interview process for all candidates based on their own skills and knowledge. As part of this commitment, the use of artificial intelligence (AI) tools to generate or assist with responses during interviews (whether in-person or virtual) is not permitted. This policy is in place to maintain the integrity and authenticity of the interview process.
However, we understand that some candidates may require accommodations that involve the use of AI. If such an accommodation is needed, candidates are instructed to contact us in advance at [email protected]. We are dedicated to providing the necessary support to ensure that all candidates have an equal opportunity to succeed.
Pay Range - There are multiple factors that are considered in determining final pay for a position, including, but not limited to, relevant work experience, skills, certifications and competencies that align to the specified role, geographic location, education and certifications as well as contract provisions regarding labor categories that are specific to the position.
The pay range for this position based on full-time employment is:
$89,203.00 - $151,646.00
Nationwide Remote Office (US99)
Top Skills
What We Do
ICF is a global advisory and technology services company with approximately 9,000 employees in industries across the public and private sectors. For over 50 years, we’ve been helping clients take on some of the world’s most complex challenges to produce exceptional results. Our work is the catalyst to help shape the future for all.
Beyond our purpose-driven work, we invest in our employees and their experience with us. We have numerous options for healthcare and many additional benefits, including immediate access to 401k retirement matching and pet insurance. Our Employee Community Networks help members find support, belonging, and growth by enhancing internal networks and professional development. We offer paid volunteer time and match your donations. As learning is a never-ending journey, we offer tuition reimbursement, mentorship programs, communities of practice to contribute to and grow from, and memberships to LinkedIn Learning and Coursera. We aim to consider every aspect of how to invest in people so they can belong, grow, and thrive with us.
Why Work With Us
At ICF, we are a purpose-driven company with a strong culture and underlying values that prize diversity, opportunity, equality, and respect. We are not all the same. And that has always been our greatest strength. We are at our best when every member of our team feels respected, included, and heard—when everyone can show up as themselves and do th
Gallery
