ETL/B2B Informatica Developer

Job Title :ETL/B2B Informatica Developer

Position Type :18+ Months Contract

City :Columbus

State :OH

Required Skills :

Informatica, B2B

Job Description :

Senior ETL/B2B Informatica Developer who will be responsible for creating
custom integration workflows using Informatica v10 ETL and B2B.

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