Job Description :
Local candidates only
All candidates must have strong communication skills
10+ years of experience with ETL and/ or 9-10 years specifically with Informatica for Locals to Columbus, OH
(OR) for candidates from Surrounding areas must have 10+ Years of experience and Strong Retail experience
The Intermediate Data Warehouse Developer is responsible for creating custom ETL workflows using various tools. This position is a specialized role which is dedicated to an Enterprise Data Warehouse team supporting Business Intelligence, Analytics, and Customer Relationship Management applications. Works with other teams to negotiate a solution and get results. They will resolve production issues with experienced resource support, troubleshoot and resolve application and data issues. The position reports to Manager, BI/EDW with no direct reports. Must possess the ability to:
Responsibilities
Review and analyze the ETL requirements
Design, develop, and implement ETL processes: mapping, workflows, configurations, etc
Assist QA designing and implementing test cases for ETL processes
Create and execute unit test plans
Troubleshoot, optimize and tune ETL processes
Document all ETL 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
Write and optimize SQL code and stored procedures (ORACLE 11 a MUST!)

Job Requirements
Strong understanding of Informatica Powercenter 9.x
4-5 years’ experience in Informatica development.
Possess great 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
Bachelor’s Degree strongly preferred
             

Similar Jobs you may be interested in ..