• Senior Data Programmer

    Posted Date 2 months ago(8/12/2019 11:07 AM)
    ID
    2019-3218
    # of Openings
    1
    Category
    Consulting
    Work Site - City
    Brooklyn
    Department
    Consulting Technical Services - Platform
    Work Site - State
    NY
    Security Clearance Level
    Public Trust
    Maximum Expected Travel
    None
    Type
    Any (Full-Time or Subcontract)
    Remote/Telecommute Available?
    No - Applicants Must be Local to Work Site
  • Job Overview & Responsibilities

    Mythics is looking for a Senior Data Programmer who will work onsite in Brooklyn, New York for a public service agency delivering Data Warehouse solutions. As the Senior Data Programmer, you must have Oracle Data Integrator and BI for successful delivery of an enterprise Data Warehouse (DW) solution and its related BI components for a public service agency.   You will be responsible for maintaining the current production application, design and develop new ETL, data mart design in Oracle Database 18c and ODI 12c.

     

    Responsibilities:

    The data model of the design is based on multidimensional design that intended for end­user queries and Bl process. The tasks include:

    • Definition of Information from each data sources integrating to the enterprise DW
      • Define the Dimension information
      • Define Fact information
      • Create Database objects
      • Map Business Rules
      • Build the Data Dictionary
    • Work with the business, end users, and technical information and facilities (server access and Database Administrative access, etc.) necessary to design and implement the solutions.
    • Develop technical design documents
    • Work with appropriate organizational personnel (stakeholders) representing the DW to meet with and engage in data modeling sessions and design the solution according specifications
    • Participate in and conducts peer reviews as needed
    • Provide technical and production support to end-users
    • Apply application changes based on information such as client feedback, requirement changes and new technology.

    Qualifications

    • * Must be able to obtain a Public Trust
    • * 100% onsite in Brooklyn, NY 
    • Bachelor's or Associate degree in Computer Science, Information Systems, Software Engineering or another engineering major or equivalent experience
    • 12+ years of experience with IT industry using Data warehouse build products (SQL Developer/Modeler, TOAD, Oracle RDBMS, etc.).
    • 4 years of experience in SQL, ODI, OBIEE, and Oracle database
    • Full lifecycle data integration experience including database connection to source, data mart development, ETL design, and advanced customization and configuration of ODI repository objects including Mappings, Interfaces, Packages, Scenarios and Knowledge Modules
    • Experience developing Packages, Procedures and Functions with PL/SQL to support ETL processes
    • Experience in performance analysis and tuning of ETL and other data transfer components
    • Experience with data models
    • Develop OBIEE reports and configure/develop the associated metadata
    • Develop materialized views, operational datastores to pull in data from source databases and combine into a single database
    • Implement different instances of databases into different environments: dev, test, and prod
    • Perform Database installation and configuration tasks
    • Assist in the development of strategies for data archive/recovery, database implementation and data acquisition/transfer
    • Clean and maintain data warehouses by restructuring and deleting old data
    • Perform Database Administration

    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 Account and Dependent Care Flexible Spending Account options
    • Generous PTO bank and paid holidays
    • Tuition reimbursement for continuing education
    • Engaging company events such as quarterly awards, annual kick off parties, and FUN Fridays (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.

    Options

    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.