• Sr. ODI ETL Developer

    Posted Date 3 months ago(2/20/2018 10:14 AM)
    # of Openings
    Work Site - City
    Consulting Technical Services - Analytics
    Work Site - State
    Security Clearance Level
    None Required
    Maximum Expected Travel
    Regular Full-Time
    Remote/Telecommute Available?
    No - Applicants Must be Local to Work Site
  • Job Overview & Responsibilities

    Mythics is looking for a Senior ETL Developer with extensive ODI, Golden Gate and Oracle Database experience who will work onsite at our client site in Brooklyn, NY.  

    The Sr. ETL Developer is responsible for the maintenance and movement of data within and between environments. You will be responsible for building the initial and incremental load of the Operational Data Store (ODS), replicating data from the Microsoft SQL Server operational system using Oracle Data Integration tools (ODI and/or Golden Gate).  In addition, you will also be responsible for the design, delivery, and maintenance of the data that is moving from the ODS into the target Data Warehouse. 




    • Bachelor's degree and/or equivalent work experience
    • Must be a US Citizen to obtain necessary clearance
    • 4+ years of Oracle PL/SQL experience
    • 3+ years of ODI Experience
    • 2+ year of Golden Gate
    • 2+ years of Data Architecture
    • 2+ years Oracle DBA experience in a Data Warehouse environment
    • Experience Integrating Big Data into the overall Data Warehouse Solution
    • Good understanding of dimensional data models
    • Extensive knowledge of PL/SQL including experience with built-in Oracle 12c and higher analytics functions, to ensure top performance and elimination of errors of the ETL workflows is required. 

    • Ability to test the entire solution  
    • Experience collecting, analyzing and documenting user requirements
    • Excellent communications skills to interact with client and other developers, including training and mentoring of team members

    Company Overview

    Why work at Mythics?

    Because at Mythics, YOU count!  
    At Mythics, we have an environment that fosters creative thinking, respects your contributions, and accepts nothing less than excellence in serving our customers.  We demonstrate these core principles daily through our corporate Values of Respect – Empathy – Excellence – Fun (REEF). Our REEF values are the foundation of everything we do.

    • Comprehensive Health, Dental, and Vision plans available for you and your family
    • Premier 401k retirement plan with corporate matching and a 529 college saving plan
    • Tax-advantaged Health Savings Accounts and Flexible Spending Account options
    • Generous PTO bank and paid holidays
    • Fitness/gym membership reimbursement and other wellness activities
    • Tuition reimbursement for continuing education
    • Engaging company events such as quarterly awards, annual kick off parties, and FUN Friday’s (early release once a month)
    • Free gourmet coffee, tea, fresh fruits and healthy snacking alternatives
    • Community Service activities and charitable giving programs
    • Our GREEN approach – tracking energy consumption for reduction and purchasing only environmentally friendly products for our offices

    Founded in 2000, Mythics is an award-winning Oracle systems integrator, consulting firm, managed services provider and elite Oracle platinum resale partner. Our business model is all about deep knowledge of Oracle technologies and business processes. We offer procurement and Oracle systems integration expertise across the full range of Oracle cloud, software, support, hardware, engineered systems, and appliances.  It’s a focus that gives us the critical business experience and the Oracle technology advantage you need to succeed.


    Mythics, Inc. is an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, religion, national origin, sex, physical or mental disability, sexual orientation, gender identity, age, marital status, medical condition, veteran status, or any other factor determined to be unlawful by federal, state, or local statutes. Mythics, Inc. will treat all employees equally with respect to compensation; opportunities for advancement, including upgrading, promotion and transfer, and all other terms and conditions of employment. This company is a VEVRAA Federal Contractor, and has designed and agreed to implement an Affirmative Action Program in accordance with Executive Order 11246 and VEVRAA Final Rule.  Mythics, Inc. is able to provide alternative methods of application for those who are unable to complete an online form.  Please contact accommodationrequests@mythics.com to arrange reasonable accommodations.  To read more about your rights, please visit the Department of Labor Disability Rights Fact Sheet here. For more information about Federal laws prohibiting job discrimination, please view the “EEO is the Law” Poster here.


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

    Connect With Us!

    Don't see any positions that match your skillset? Not ready to apply? You can still Connect with us for future consideration!