Martin Marietta ETL Developer in Raleigh, North Carolina

Martin Marietta, an American company and a member of the S&P 500 index, is a leading supplier of aggregates and heavy building materials, with operations spanning 26 states, Canada and the Caribbean, and dedicated teams transforming more than 100 years of irreplaceable natural resources into the roads, sidewalks and foundations on which we live. Martin Marietta’s Magnesia Specialties business provides a full range of magnesium oxide, magnesium hydroxide and dolomitic lime products.

At Martin Marietta, we are always looking for the best and the brightest, for people who have the potential to be the Company's future leaders. We are building on our foundation of success by selecting the finest people and helping them realize their potential. When you decide to build your career at Martin Marietta, you'll know what it's like to be respected, challenged and rewarded.

The ETL Developer is responsible for Design and Development of ETL Layer, including the design and optimization of all inbound and outbound feeds.

Responsibilities:

  • Provide Tier III support for Data Stage, Oracle Stored Procedures (10g / 11g) and Unix Scripts

  • Will be the primary contact for questions about data acquisition and data quality

  • Aid in performance tuning efforts to ensure Jobs run within acceptable parameters

  • Monitor the daily loads and ensure success

  • Monitor the current architecture, keep up with evolving industry trends and recommend changes as appropriate

  • Contribute to the design and development of the Enterprise Data Warehouse

  • Ensure documentation is up to date

Requirements:

  • Bachelor’s degree with at least eight years of IS experience

  • Most recent experience must be Data Warehouse focused with at least five years of hands on experience in Data Warehouse development and production support

  • Hands on design and development experience in Data Stage 8.x and higher

  • Oracle Stored Procedure, Oracle Performance Tuning (Oracle 10g/ 11g)

  • Unix shell scripting

  • Prior experience sourcing from Oracle, SQL Server databases with proven knowledge and understanding of moving large volumes of data efficiently

  • Excellent trouble shooting skills

  • Strong Logical & Physical Data Modeling experience. Proven skills in 3rd Normal and Star Schema

  • Effective verbal, written and interpersonal communication

  • Prior experience modeling Finance, Sales, Inventory and other subject areas

Preferred:

  • Formal Training in Data Modeling would be a strong plus

  • Experience sourcing data from JDE

  • Experience with GoldenGate would be a plus

  • Understanding of SOX and Project management principles and concepts

  • Medical

  • Prescription Drug

  • Dental

  • Vision

  • Health Care Reimbursement Account

  • Dependent Care Reimbursement Account

  • Wellness Programs

  • Employee Assistance Plan

  • Paid Holidays and Vacation

  • 401(k) with Company matching

  • Pension

  • Salary Continuation – Short-Term Disability

  • Long-Term Disability Options

  • Employee Life Insurance

  • Spouse & Dependent Life Insurance

  • Business Travel Accident Insurance

  • Direct Deposit Payroll

  • Educational/Tuition Assistance Plan

  • College Scholarship Program – for dependent children

  • Matching Gift Program

  • New Auto Purchase Discount Plans

We are an equal opportunity employer.

Qualified minorities, women, veterans and individuals with disabilities are encouraged to apply.

Requisition ID: 2016-2192

Division: Corporate