ICF International - Reston, VA
posted 3 months ago
ICF is seeking an Oracle PL/SQL Developer to join our team, focusing on data integration for enterprise applications. This role involves integrating data from various sources into a cohesive analytical data warehouse, which supports business intelligence applications. The ideal candidate will have a strong background in the analysis, design, development, and administration of commercial business intelligence, client/server, ETL, and web-based applications. We are particularly interested in candidates with experience in implementing big data solutions, dimensional data modeling, and data visualization using real-time analytics and reporting solutions. The responsibilities of this position include full development tasks such as packaging, creating stored procedures, triggers in MS SQL, PL/SQL, and managing data migration and conversion from legacy systems. The candidate will also be expected to work within an Agile rapid development environment, providing lifecycle and production support/application maintenance. This role is fully remote, allowing for flexibility in work hours. Key tasks will involve developing complex database processes with PL/SQL, enhancing existing DataMarts in OLAP schemas, gathering requirements, designing and documenting processes, and leveraging Oracle 11G/12C features on large-scale systems. The developer will assist team members in understanding data needs, participate in project workgroups, and engage in performance tuning activities. Additionally, the role requires analyzing business requirements and converting them into technical solutions, supporting production applications, and resolving production inquiries and issues as they arise.