Data Integration Analyst
Previous Job
Previous
Data Integration Analyst
Ref No.: 13-03230
Location: Norcross, Georgia
JOB TITLE:  Data Integration Analyst                            
DEPARTMENT:  IT
LOCATION:  Norcross, GA
REPORTS TO:  Director, IT Data Integration Services
STATUS:  Exempt
DATE:  03-06-2013                                                                               
 
 
SUMMARY:     
 
Member of Data integration team will be assisting in the data integration of new and existing implementations. Development of scripts and configuration of data transformation tools between internal and external applications using SQL, PL/SQL, Informatica, GIS and other in house data related tools. Data Integration Analyst is responsible for monitoring data flows and resolution of issues on a daily basis.
 
ESSENTIAL DUTIES AND JOB RESPONSIBILITIES:    
 
  • Troubleshoot and resolve data transfer, import, and export failures
  • Perform Tier 2 support for IT Help Desk supporting internal and external customers
  • Conduct root cause analysis and recommend solutions for recurring production data issues
  • Development of scripts, SQL queries, data mapping, and configuration of data transformation tools
  • Work with Architect to gather, define, and document data transformation rules
  • Work closely with Developers to provide data integration services to existing and new applications
  • Maintain documentation on configuration and interface specifications
  • Test and certify client data transmissions for successful integration with backend systems
  • Automates creation and export of data files for recurring reporting requirements
  • Performs other duties as assigned
 
REQUIRED SKILLS:
 
  • Excellent written and verbal communication skills
  • Ability to interact professionally with customers, business analysts, managers, and subject matter experts
  • Experience with enterprise-wide requirements definition and management systems and methodologies
  • Proactively communicate and collaborate with external and internal customers
  • Successfully engage in multiple initiatives simultaneously
  • Strong analytical skills required
  • Independent and Creative thinker
  • Ability to travel as required
 
 

EDUCATION / EXPERIENCE:

  • Minimum 3 years of IT work experience
  • Minimum 1 year SQL experience including the use of SQL with systems utilizing a relational DBMS such as SQL Server, Oracle, or Informix is required.
  • Working knowledge of ANSI EDI standards and a variety of data file formats and structures.
  • Working knowledge of data file transfer techniques including FTP is preferred.
  • Must be able to perform in a fast paced environment and oriented to meeting project deadlines.
  • Must manage time well and keep up with simultaneous tasks, projects, and assignments.
  • Experience with Informatica and GIS (Gentran Integration Suite) is desired.