The Oakleaf Group, LLC

  • ETL Developer, Informatica

    Job Location 3 weeks ago(3/3/2018 12:23 PM)
    Posted Date
    US-DC-Washington, DC
  • Overview

    ETL Developer, Informatica

    Washington, DC metro area



    For a large financial services client, we are seeking an ETL Developer with strong Informatica skills, to work on a 1 year or longer project to work on a large data mart.


    • Work on the development of a large-scale Oracle database, with an ETL setup using Informatica
    • Develop a Redshift reporting layer for deployment on the cloud, with real-time data transfer between Oracle and AWS
    • Design Oracle database packages and procedures
    • Design and develop complex ETL procedures using Informatica
    • Develop and tune SQL and PL/SQL code
    • Write ad-hoc queries based on schema knowledge for various application requirements


    • BS Degree in computer science or relevant fields
    • 5+ years using Informatica for ETL development with Oracle applications
    • Strong experience with application database design, analysis and implementation
    • Must have strong Oracle, PL/SQL, Redshift and Informatica ETL skills
    • Experience creating stored procedures, database triggers and SQL queries
    • Basic to intermediate knowledge of Linux scripting, SSH and FTP protocols
    • Experience querying, loading and reporting large volumes of data
    • Financial services experience preferred; GSE experience a strong plus


    Company Overview

    The Oakleaf Group is a mid-size consulting firm with offices in Bethesda, MD and New York, NY. Our people are our greatest assets and our company culture is grounded on that belief. Our goal is to thrill our clients and challenge and reward our employees.  As a member of the Oakleaf team, you will have an exciting opportunity to work with emerging technology, modernize financial applications, and grow in a friendly workplace where you can work independently and collaboratively. In this position the ideal candidate will work to solve complex “hot topic” issues currently faced by the financial services industry. We bring depth of experience to a wide range of highly satisfied clients, delivering trusted advice along with quantitative, technology, regulatory, and operations strategies. Do you possess the talent and dedication to be part of our growing team?


    Third party candidates will not be considered for this position.


    As a condition of employment with The Oakleaf Group, any successful job applicant will be required to successfully complete a background investigation, which may also include a pre-employment drug screen and/or a credit check for positions in some areas of our business. The Oakleaf Group is an equal opportunity employer. Applicants are considered for positions without regard to race, religion, gender, native origin, age, disability, or any other category protected by applicable federal, state, or local laws. The Oakleaf Group participates in the E-Verify program.


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