Current jobs related to Senior OAS/ODI Developer - Washington - International Logic Systems, Inc.


  • Washington, DC, United States International Logic Systems, Inc. Full time

    Job Title: Senior ODI/OAS DeveloperInternational Logic Systems, Inc. is seeking a highly skilled Senior ODI/OAS Developer to join our team in Washington, DC.Job SummaryWe are looking for a seasoned professional with expertise in designing and implementing Enterprise-level solutions for multi-dimensional databases, as well as experience with Oracle Data...

  • OBIEE OAS consultant

    4 weeks ago


    Washington, United States Vigna Solutions Inc. Full time

    Title: OBIEE OAS Consultant Location: Washington DCDuration: Long termW2 s and GCsJob Description:We are looking for an OBIEE and OAS consultant for our client in Washington DC. Candidates for this role need to have good experience in ETL development as well as in OBIEE and OAS or ODI. Candidates with banking or finance industry preferred.

  • Senior ETL Developer

    4 weeks ago


    Washington, United States International Logic Systems, Inc. Full time

    ILS is looking for Senior ETL Developer to support one of our projects in Washington, DC. This resource will be responsible for designing Enterprise-level solutions for multi-dimensional databases, will design and plan BI solutions, execute strategies for database backup, and provide documentation implementation and quality assurance....

  • Senior ETL Developer

    4 weeks ago


    Washington, DC, United States International Logic Systems, Inc. Full time

    Senior ETL Developer Job DescriptionInternational Logic Systems, Inc. is seeking a highly skilled Senior ETL Developer to join our team in Washington, DC. As a key member of our project team, you will be responsible for designing and implementing enterprise-level solutions for multi-dimensional databases, developing and testing advanced ETL/ELT solutions,...


  • Washington, Washington, D.C., United States Providence Full time

    Transformative Opportunity in Cloud-Based ERP DevelopmentProvidence Health & Services is seeking a highly skilled Principal Oracle Cloud FDI Developer to join our Enterprise Business Applications team. As a key member of our team, you will have the opportunity to optimize and enhance our ERP and time-tracking systems that support over 122,000 employees.About...


  • Washington, Washington, D.C., United States InsideHigherEd Full time

    Job SummaryThe Associate Director of Development, McCourt School of Public Policy is a key member of the University's frontline fundraising team, responsible for building connectivity, engagement, and philanthropic support for the McCourt School. This position will play a critical role in raising funds specifically for the school, while also representing the...


  • Washington, Washington, D.C., United States Commonwealth Senior Living Full time

    Job Summary: We are seeking a highly motivated and experienced Senior Business Development Director to join our team at Commonwealth Senior Living. The successful candidate will be responsible for identifying and developing strategic partnerships with key stakeholders in the senior living industry.Key Responsibilities:Identify and develop strategic...


  • Washington, United States PCI Government Services LLC Full time

    OverviewThe Senior Human Capital Design Consultant will lead the development, documentation, and assessment of the U.S. Department of Transportation (DOT) HR business processes across its eleven Operating Administrations (OAs). This role involves performing a comprehensive HR Business Process Analysis, identifying gaps, and recommending process improvements...


  • Washington, United States PCI Government Services LLC Full time

    OverviewThe Senior Human Capital Design Consultant will lead the development, documentation, and assessment of the U.S. Department of Transportation (DOT) HR business processes across its eleven Operating Administrations (OAs). This role involves performing a comprehensive HR Business Process Analysis, identifying gaps, and recommending process improvements...


  • Washington, United States PCI Government Services LLC Full time

    OverviewThe Senior Human Capital Design Consultant will lead the development, documentation, and assessment of the U.S. Department of Transportation (DOT) HR business processes across its eleven Operating Administrations (OAs). This role involves performing a comprehensive HR Business Process Analysis, identifying gaps, and recommending process improvements...


  • Washington, Washington, D.C., United States Providence Full time

    Transformative OpportunityProvidence Health & Services is seeking a highly skilled Principal Oracle Cloud FDI Developer to join our Enterprise Business Applications team. As a key member of our team, you will have the opportunity to optimize and enhance our ERP and time-tracking systems that support over 122,000 employees.Key ResponsibilitiesProvide...

  • Senior Office Manager

    1 month ago


    Washington, Washington, D.C., United States OCT Consulting, LLC Full time

    Job SummaryWe are seeking a highly skilled Senior Office Manager to join our team at OCT Consulting, LLC. As a key member of our operations team, you will be responsible for providing exceptional administrative support to our federal client, the U.S. Customs and Border Protection (CBP) Office of Acquisition (OA).Key ResponsibilitiesProvide administrative...


  • Washington, Washington, D.C., United States BroadPoint Federal, Inc Full time

    Job Title: Oracle EBS Technical DeveloperCompany Overview: BroadPoint Federal, Inc. is a leading provider of IT solutions for federal agencies, with 20 years of experience in application development, information technology, and operations & maintenance services.Job Description: We are seeking an experienced Oracle Technical Analyst to join our team. The...


  • Washington, Washington, D.C., United States Collins Consulting Full time

    Job SummaryThis is a hybrid position that requires on-site work 2-3 days a week. The ideal candidate must be a US Citizen or Permanent resident.Key ResponsibilitiesModernize financial business processes for USAC, including implementing Oracle EBS.Work on two main workstreams: Federal Universal Service Fund and commercial USAC entity.Discovery, Design, Build,...


  • Washington, United States PCI Government Services LLC Full time

    OverviewThe Human Capital Design Analyst will support the U.S. Department of Transportation (DOT) in conducting an HR Business Process Analysis for the Department of Human Resources Management (DOHRM). This position will assist in documenting current HR processes across the DOT’s eleven Operating Administrations (OAs), identifying areas for improvement,...


  • Washington, United States PCI Government Services LLC Full time

    OverviewThe Human Capital Design Analyst will support the U.S. Department of Transportation (DOT) in conducting an HR Business Process Analysis for the Department of Human Resources Management (DOHRM). This position will assist in documenting current HR processes across the DOT’s eleven Operating Administrations (OAs), identifying areas for improvement,...


  • Washington, United States PCI Government Services LLC Full time

    OverviewThe Human Capital Design Analyst will support the U.S. Department of Transportation (DOT) in conducting an HR Business Process Analysis for the Department of Human Resources Management (DOHRM). This position will assist in documenting current HR processes across the DOT’s eleven Operating Administrations (OAs), identifying areas for improvement,...


  • Washington, Washington, D.C., United States BroadPoint Federal, Inc Full time

    Job DescriptionBroadPoint Federal, Inc. is a leading provider of IT solutions for federal agencies, with 20 years of experience in application development, information technology, and operations & maintenance services.The Oracle Technical Analyst will be responsible for designing and developing RICE-W in the Oracle Federal Financial modules, supporting all...


  • Washington, Washington, D.C., United States AMERICAN SYSTEMS Full time

    Job Title / LevelProgram Lead, Business Support - TS Clearance RequiredJob DescriptionAre you an experienced Business Support Program Lead with strong managerial experience organizing, planning, directing, and managing contractor staff? Then we have a great opportunity for you to support our U.S. Government Customer.Key ResponsibilitiesAssist the Program...


  • Washington, Washington, D.C., United States Business Performance Systems, LLC Full time

    As a Senior IT Project Manager at Business Performance Systems, LLC, you will oversee the scope, cost, and schedule of large projects or significant segments of complex projects. Your expertise in IT project management will enable sound IT and portfolio management practices and high-quality delivery of program contract support.You will analyze new and...

Senior OAS/ODI Developer

3 months ago


Washington, United States International Logic Systems, Inc. Full time

ILS is looking for a Sr. ODI/OAS Developer to support one of our projects in Washington, DC. This resource will be responsible for designing Enterprise-level solutions for multi-dimensional databases, will design and plan BI solutions, execute strategies for database backup, and provide documentation implementation and quality assurance.


Responsibilities:
Understand database design, programming concepts, data modeling, and framework management
Design, develop, and test advanced complex ETL/ELT solutions
Automate a robust data loading processes with exception handling and notification.
Support the project team throughout the design, development and testing process.
Identify and reuse of ETL components and services to avoid duplicative implementations.
Communicate ideas to both technical and non-technical people in all levels of the organization.
Knowledge of ETL architecture
Strong knowledge of Oracle database, SQL and analytical skills
Designing and developing ETL (Extract, Transform, Load) processes using Oracle Data Integrator (ODI) toolset.
Collaborating with business analysts and business users to gather ETL requirements translating them into technical specifications.
Developing and optimizing SQL queries and stored procedures for data extraction and transformation.
Creating and maintaining technical documentation related to ETL processes and data integration workflows.
Performing unit testing and supporting system testing and user acceptance testing phases.
Troubleshooting and resolving issues related to data integration processes.
Create/maintain reports using Oracle Analytics Server (OAS)
Sound knowledge on Data warehousing principles (dimensional and normalized modeling concepts) and Problem solving
Desirable knowledge on ODI Architecture and development in medium to large scale data warehouse environments
Knowledge of performance tuning of SQL queries
Analyze functional business applications and design specifications for functional areas such as finance, accounting, personnel, manpower, logistics, and contracts.
Develop block diagrams and logic flow charts.
Prepares required documentation, including both program-level and user-level documentation.
Enhance ELT/ELT process to reduce operating time or improve efficiency.

Qualifications:
10 years of experience, of which at least 5 years must be “specialized”
Specialized experience includes:
Experience as a data warehouse/database developer on medium to large-scale data warehouse environments
Knowledge of data warehouse methodologies and ability to develop complex ETL/ELT code to satisfy design objectives
Strong SQL/PL-SQL knowledge

Demonstrated ability to work independently or under only general direction
Experience in using:
Oracle database (12c/19c)
Logical/Physical Data Modeling
Oracle Data Integrator tool (must possess strong skills)
Proven experience as an Oracle ODI Developer.
Strong proficiency in Oracle Data Integrator (ODI) toolset, including ODI Studio, ODI Console, and ODI Agent.
Solid understanding of data warehousing concepts and dimensional modeling.
Proficiency in SQL programming and performance tuning techniques.
Strong experience with Oracle databases (SQL, PL/SQL).
Ability to design and implement Oracle Apex applications from scratch as well as customize existing applications.
Experience developing with Python.
Excellent analytical and problem-solving skills.
Strong communication and interpersonal skills.
Enterprise Data Warehouse Reports and Dashboard (OBIEE+/OAS)
ETL/ELT tools like ODI, Informatica, any reporting tools (PowerBI)
Master Data Management (MDM)
Must be strong in SQL and PL/SQL

A Bachelor’s degree in Computer Science, Information Systems, Engineering, Business, or other related scientific or technical discipline is required.