Previous
ETL/ Informatica Developer
Next
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
|