No 3rd party or CTC

Hybrid- onsite 3 days a week in Irving, TX

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 Azure Data Factory and or Treasure Data
• 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
  • Azure preferred
    • ADF CDI

GDT IS AN EQUAL OPPORTUNITY EMPLOYER. Applicants and employees are considered for positions and are evaluated without regard to mental or physical disability, race, color, religion, gender, national origin, age, genetic information, military or veteran status, sex, marital status, gender identity or any other protected Federal, State/Province or Local status unrelated to the performance of the work involved.