Previous Job
Previous
ETL/ Informatica Developer
Ref No.: 19-00551
Location: Columbus, Ohio
ETL/ Informatica Developer

Location: Columbus, OH
Duration: 8 months
Interview: Phone and Skype

Responsibilities
  • Review and analyze the ETL, MFT and B2B requirements
  • Design, develop, and implement ETL, MFT and B2B processes: mapping, workflows, configurations, etc. using Informatica v10 ETL, DT, MFT solutions
  • Assist QA designing and implementing test cases for ETL, MFT and B2B processes
  • Create and execute unit test plans
  • Troubleshoot, optimize and tune ETL, MFT and B2B processes
  • Document all ETL, MFT and B2B related work per company's methodology
  • Maintain existing code and fix bugs as requested
  • Self-manage time and task priorities to meet project timelines and identify potential project risks
  • Handle multiple project and task workload
  • Participates in functional requirements and design sessions
  • Interprets data models and formats
  • Understands and documents complex data transformation rules
  • Creates functional specifications and mapping documents to company standards
  • Identifies solution methods (i.e. development, query tool or business process)
  • Provides the functional and technical specifications which may include SQL
  • Participates in testing, user training and result evaluation and oversees implementation
  • Evaluates production requests from user groups
  • Answers production questions from user groups
  • Analyze help desk development support tickets
  • Write and optimize SQL code and stored procedures (ORACLE 11 a MUST!)
 
Job Requirements
  • Strong understanding of Informatica PowerCenter 10.x ETL, MFT and B2B (DT)
  • 4-5 years' experience in Informatica development.  
  • Possess strong SQL skills
  • Experience with scripting language (Preferred Shell or Perl)
  • Experience with Oracle 11
  • Previous Teradata database experience preferred
  • Experience with Informatica CDC a plus
  • Understand SDLC
  • Understand industry standard implementation processes
  • Strong oral/written communications and analytical skills
  • Creative, strategic thinker and solutions-minded
  • Retail experience preferred