Data Integration Analyst lll

3 weeks ago

Thomasville, United States Old Dominion Freight Full time

Additional Job Description

Lead the Data Integration Analysts on a daily basis and provide technical expertise to create and enforce data integration standards. Responsible for building data integration solutions utilizing Oracle Data Integration (ODI) tools, Oracle Enterprise Data Quality (EDQ) tools and defining database reporting schemas. Lead project teams to build data migration solutions that are stable, scalable and follow best practices.

Primary Responsibilities

  • Lead the evaluation for ETL and Data Quality solutions actively being developed including performance optimization and high availability
  • Lead the analysis, design, development, and unit testing of ODI and EDQ programs from detailed and high-level specifications and assist with troubleshooting
  • Build low latency end to end solutions using ODI and EDQ for change data capture
  • Map business requirements into ODI Interfaces, Packages, and Load Plans using source to target mapping documents
  • Enforce business rules using ODI Constraints and EDQ data quality functions
  • Create database objects, develop database procedures, functions, and triggers to perform complex ETL processes
  • Lead the conversion of Logical Data Models into Physical Data Models
  • Setup Java EE ODI Agents running in a WebLogic server cluster for High Availability
  • Design and build components to assist with automation of common tasks via the ODI SDK
  • Extend the base ODI Knowledge Modules to create customized versions that will be re-usable across the companys data integration projects
  • Scrub and cleanse source data according to requirements and standards
  • Create both Design and Interface docs in support of data migration projects
  • Collaborate with the Development teams in a multi-user environment to promote code changes into source code control for deployment to INT, QA, Load and Production environments
  • Monitor ETL and data quality jobs and activities
  • Support ODI, EDQ and MDM software packages
  • Interface with Oracle Corporation for technical support
  • Provide guidance and mentoring to less experienced Data Integration Analysts
  • Rotate weekly on-call responsibilities

Job Qualifications

Education:

  • Bachelors Degree in Computer Science or related field or equivalent education and experience

Experience:

  • 9 years of experience working with ETL, Data Quality and MDM tools
  • Advanced capabilities with ETL and Data Quality Tools in Data Warehouse and MDM environments
  • Solid knowledge of RDBMS systems including Oracle, SQL Server and DB2
  • Solid capabilities with analysis, design, development, and implementation of major database structures
  • Proficient using SQL, SQL Plus and PL/SQL
  • Proficient using data modeling tools
  • Proficient with Oracle Data Integrator (ODI) and Oracle Enterprise Data Quality (EDQ)
  • Knowledge of Oracle RAC on a Super Cluster platform
  • Problem-solving ability and proven ability to work multiple deadlines
  • Demonstrated creativity and intellectual curiosity around problem resolution and solution definition
  • Detail oriented with strong interpersonal skills
  • Excellent verbal and written communication skills
  • Experience with Agile Development methodology preferred
  • Knowledge of WebLogic clustering and load balancing preferred
  • Exposure to iSeries DB2 preferred
  • Familiarity with Embarcadero ER/Studio preferred
  • UNIX experience preferred

by Jobble

  • Data Integration Analyst lll

    1 month ago

    Thomasville, United States Old Dominion Freight Line Full time

    Additional Job DescriptionLead the Data Integration Analysts on a daily basis and provide technical expertise to create and enforce data integration standards. Responsible for building data integration solutions utilizing Oracle Data Integration (ODI) tools, Oracle Enterprise Data Quality (EDQ) tools and defining database reporting schemas. Lead project...

  • Data Integration Analyst lll

    4 weeks ago

    Thomasville, United States Old Dominion Freight Line Full time

    Additional Job DescriptionLead the Data Integration Analysts on a daily basis and provide technical expertise to create and enforce data integration standards. Responsible for building data integration solutions utilizing Oracle Data Integration (ODI) tools, Oracle Enterprise Data Quality (EDQ) tools and defining database reporting schemas. Lead project...

  • Business Intelligence Developer ll

    5 days ago

    Thomasville, United States Old Dominion Freight Full time

    Additional Job Description Develop and test the implementation of Business Intelligence (BI) and Analytic reports, dashboards, and other supported applications based on business need and prioritization. Partner with the BI Architect, BI Business Analysts, and other OD Technology resources to deliver complex, well performing, stable and visually appealing...

  • Business Intelligence Developer ll

    4 weeks ago

    Thomasville, United States Old Dominion Freight Line Full time

    Additional Job DescriptionDevelop and test the implementation of Business Intelligence (BI) and Analytic reports, dashboards, and other supported applications based on business need and prioritization. Partner with the BI Architect, BI Business Analysts, and other OD Technology resources to deliver complex, well performing, stable and visually appealing...

  • Business Intelligence Developer ll

    4 weeks ago

    Thomasville, United States Old Dominion Freight Line Full time

    Additional Job DescriptionDevelop and test the implementation of Business Intelligence (BI) and Analytic reports, dashboards, and other supported applications based on business need and prioritization. Partner with the BI Architect, BI Business Analysts, and other OD Technology resources to deliver complex, well performing, stable and visually appealing...

  • Sr. Financial Analyst

    1 week ago

    Thomasville, United States Old Dominion Freight Full time

    This position will be responsible for supporting the Corporate finance function at Old Dominion Freight Line. This individual will provide critical financial insights and analytical support to help drive business decisions. The responsibilities will include financial analysis, reporting, forecasting and dashboard creation. The successful candidate will have...

  • Sr. Financial Analyst

    1 month ago

    Thomasville, United States Old Dominion Freight Line Full time

    This position will be responsible for supporting the Corporate finance function at Old Dominion Freight Line. This individual will provide critical financial insights and analytical support to help drive business decisions. The responsibilities will include financial analysis, reporting, forecasting and dashboard creation. The successful candidate will have...

  • Field Engineer

    9 hours ago

    Thomasville, United States Vantage Consulting Full time

    Are you an experienced field service engineer with experience in PLC's? If so, and you’re looking to take that next step, read below!This role is working with a cutting-edge automation integrator based in North Carolina with locations over the US. They focus on the entire system design, implementation and commissioning in control and data systems and are...

  • Field Engineer

    19 hours ago

    Thomasville, United States Vantage Consulting Full time

    Are you an experienced field service engineer with experience in PLC's? If so, and you’re looking to take that next step, read below!This role is working with a cutting-edge automation integrator based in North Carolina with locations over the US. They focus on the entire system design, implementation and commissioning in control and data systems and are...

  • Field Engineer

    14 hours ago

    Thomasville, United States Vantage Consulting Full time

    Are you an experienced field service engineer with experience in PLC's? If so, and you’re looking to take that next step, read below!This role is working with a cutting-edge automation integrator based in North Carolina with locations over the US. They focus on the entire system design, implementation and commissioning in control and data systems and are...

  • Customer Accounts Rep I

    5 hours ago

    Thomasville, United States City of Thomasville Full time

    Description Employee in this position receives moderate supervision from the Customer Accounts Supervisor and Customer Accounts Team Leader.Operates data entry terminals and software reports, in preparing water, electric, gas, sewer, and refuse billing and all CNS services. Also maintains customer records.Checks and investigates accounts for any errors that...

  • National Sales Director

    12 hours ago

    Thomasville, United States Nederman Full time

    Nordfab introduced Quick-Fit clamp-together ductwork, with its unique rolled edge ends and easy-to-use clamps, in 1990. As well as being the originator, Nordfab is the industry leader, and the world’s largest manufacturer of clamp-together ducting for industrial ventilation. Our ducting is an integral part of dust, mist, and fume collection systems around...

  • Nurse - LPN

    24 hours ago

    Thomasville, United States Meridian Center - High Point, NC Full time

    Job Description Meridian Center is hiring Full-Time / Part Time License Practical Nurse. All Shifts 7am to 3pm, 3pm to 11pm and 11p to 7am With every other weekends!!! BenefitsNursing Student Loan Debt Repayment and Tuition AssistanceVariable compensation plansTuition, Travel, and Wireless Service DiscountsEmployee Assistance Program to support mental...

  • Nurse - Licensed Practical Nurse

    14 hours ago

    Thomasville, United States Meridian Center - High Point, NC Full time

    Meridian Center is hiring Full-Time / Part Time License Practical Nurse. All Shifts 7am to 3pm, 3pm to 11pm and 11p to 7am With every other weekends!!! Benefits*Nursing Student Loan Debt Repayment and Tuition Assistance*Variable compensation plans*Tuition, Travel, and Wireless Service Discounts*Employee Assistance Program to support mental health*Employee...

  • Licensed Practical Nurse

    14 hours ago

    Thomasville, United States Meridian Center - High Point, NC Full time

    Meridian Center is hiring Full-Time / Part Time  License Practical Nurse. All Shifts 7am to 3pm, 3pm to 11pm and 11p to 7am With every other weekends!!!   Benefits*Nursing Student Loan Debt Repayment and Tuition Assistance*Variable compensation plans*Tuition, Travel, and Wireless Service Discounts*Employee Assistance Program to support mental...

  • Licensed Practical Nurse

    24 hours ago

    Thomasville, United States Meridian Center - High Point, NC Full time

    Job DescriptionMeridian Center is hiring Full-Time / Part Time  License Practical Nurse. All Shifts 7am to 3pm, 3pm to 11pm and 11p to 7am With every other weekends!!!   BenefitsNursing Student Loan Debt Repayment and Tuition AssistanceVariable compensation plansTuition, Travel, and Wireless Service DiscountsEmployee Assistance Program to support mental...

  • Disaster Recovery Specialist

    3 weeks ago

    Thomasville, United States Scicom Infrastructure Services, Inc. Full time

    About the job Disaster Recovery Specialist In addition to the responsibilities listed below, this position will serve as an IT Resiliency SME on the management of business continuity assets and processes for IT, resiliency business systems planning, financial and contracts management, audit, compliance, methods, processes and quality assurance functions by...

  • Vice President

    1 week ago

    Thomasville, United States Archbold Medical Center Full time

    Vice President, Revenue Cycle Operations Do you thrive in a fast-paced healthcare environment and have a passion for optimizing financial performance? Are you a strategic leader with a proven track record of building high-performing teams? If so, we want to hear from you! The Opportunity We are seeking a dynamic, seasoned, and results-oriented Vice President...