CDI Engineer

As a data-driven, strategic marketing agency, we believe our clients become stronger when they leverage the wealth of information consumers provide every day. At Targetbase, we integrate technology, analytics, creative, digital and strategy to create a better consumer experience, which improves consumer engagement and drives a more profitable outcome for clients.

JOB SCOPE & PURPOSE

The Customer Data Integration (CDI) Engineer is responsible for developing code to integrate, transform, and populate data in the client database from data sources provided by the client and/or third-party data sources. The CDI Engineer understands the complete data life cycle in an agency environment. This requires both technical and business skills that include technical requirements, documentation, and development as part of the complete software development life cycle (SDLC). In addition to new projects, there are existing implementations where the CDI Engineer is called upon to handle data maintenance items like data quality management, error handling, and code break/fix.

MAIN RESPONSIBILITIES

• Based on business requirements, contributes to detailed technical requirements and specifications; identifies missing details in the business requirements and engages the appropriate resource(s) for clarification
• Develops mapping and data processing procedures to import data from various data sources and populate the client database
• Develops data extracts and procedures to support internal and client (external) business analytics
• Develops unit test cases and ensures successful test completion before delivery of code to quality assurance (QA) team (unit tests should be thorough and cover all functions dealing with business logic and data layouts)
• Develops efficiencies throughout the SDLC on an iterative basis; this includes reuse of existing internal/third-party components
• Coordinates with QA team to ensure quality deliverables; this includes delivering bug fixes, documentation, and appropriate dependency information with every release
• Consistently checks work area code into repository to guarantee safety of code artifacts and minimize code dependency impact to other team members 
• Identifies cross-competency needs and assists with development of standard operating procedures within and across client teams
• Contributes to the project estimation process
• Multitasks through project execution and prioritizes accordingly, ensuring project deadlines are met and deliverables are completed in a timely fashion
• Assists with the transition from project completion to ongoing production and production support
• Communicates requirements and status with other teams and competencies, as required on an ongoing basis

EXPERIENCE & EDUCATION

• 2+ years of Informatica experience
• 2 years of SQL/database experience, preferably Oracle
• Bachelor’s Degree in Computer Science, Engineering, MIS, or IIS is preferred 

KNOWLEDGE & ABILITY

• Development Tools/Platforms    
  • Informatica
  • SQL and PL/SQL
  • UNIX/LINUX
  • Shell scripting
  • PERL (a plus)
  • .NET (a plus)
• Database
  • Oracle
  • SQL Server 2005/2008
• Methodologies
  • Dimensional data warehousing 
• Cloud Technologies
  • Axure preferred
    • ADF CDI

***We are a hybrid company working 3 days a week in office and 2 days a week at home.  Candidates must live in the Dallas/Ft Worth area and willing to be in office on required days

POSITION REQUIREMENTS

• Overtime as necessary

Targetbase is a part of Omnicom Precision Marketing Group (OPMG). OPMG aligns Omnicom’s global digital, data and CRM capabilities to deliver precisely targeted and meaningful customer experiences at scale. Using its universal framework of connected data, connected intelligence and connected experiences, OPMG provides services that include data-driven product / service design, technology strategy and implementation, CRM / loyalty strategy and activation, econometric and attribution modelling, technical and business consulting and digital experience design and development.