Sevatec Inc.

  • Informatica/Oracle Developer - Senior

    Job Locations US-DC-Washington
    Posted Date 6 months ago(1/9/2019 9:48 AM)
    Job ID
    # of Openings
    Information Technology
  • Overview

    The Oracle/ETL Developer will work within an Agile Scrum/Kanban team providing Data Warehouse and Business Intelligence services to our government customer. The developer will work with varying data sources with different schemas and data elements in a fast-paced, agile environment to ultimately produce an effective and efficient Data Warehouse. The position will also help with our upcoming technology modernization program.


    • Develop Informatica workflows to ingest data from multiple transactional systems according to documented logic and source-to-target mappings
    • Work directly with customers Business Analysts, and System/Data Architects designing and developing most cost effective solution
    • Spearheading design, clarification of requirement, and development of data warehouse and enterprise business intelligence and ETL solutions
    • Present ETL design and test result to teams and customers to gain acceptance
    • Suggest architecture improvements, design and integration solutions
    • Conduct analyses of alternatives for different technical solutions and be able to communicate the strengths and weaknesses of each ETL solution
    • Proactively craft and propose solutions that clarify how Sevatec brings business value to address critical business challenges faced by customers
    • Migrate existing PL/SQL scripts to Informatica workflows for data ingest
    • Apply Informatica tool to provide data cleansing, data quality assurance, and PII data masking for testing purposes
    • Monitor ETL workflows and logging, providing detailed job reports and status
    • Perform ETL failure recovery when needed. Daily notifications on ETL workflow status will be required to ensure no interruption in service
    • Utilize Agile systems development methodology to plan, scope, and deliver rapid Sprint releases
    • Explore new database and ETL technologies as part of our modernization project.



    • At least 5 years of overall experience in IT applications development or consulting related to IT applications development and data ingest processes.
    • Experience with Oracle 10/11g RDMS and associated tools and infrastructure.
    • Experience with SQL in Oracle environment is must.
    • Experience with Informatica PowerCenter 9.5 from multiple transactional systems (RDBMS, flat files, XML, API, etc.)
    • Experience with Informatica Data Quality and Informatica Dynamic Data Masking
    • Experience in Data Warehouse and Business Intelligence environment preferred.
    • Ability and desire to research new technologies and create proof of concept applications.
    • Excellent interpersonal skills

    Desired Skills and Experience

    • At least 5 years in technical development roles on BI projects - with some experience along the way designing and developing with ETL tools and designing and developing with Relational Reporting Tools.
    • Experience working in an Agile environment


    Security Clearance:  Must be a US Citizen and have the ability to obtain a Secret Clearance


    EEO Statement:  Sevatec is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, or any other characteristic protected by law.




    Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
    Share on your newsfeed

    Need help finding the right job?

    We can recommend jobs specifically for you! Click here to get started.