Job Description :
Position: ETL Architect
Location: Southfield, MI
Duration: Contract to hire

Need candidates on W2 only

15-17 yrs. Experience
This person will lead teams and work with management and executives
Must have excellent communication
This person is not hands on but must be able to speak to and understand how things work (Healthcare)
Must have 3-4 yrs. as an architect and be able to show their career progression
Cognos and Business Objects are nice to have

The Informatica ETL Architect has the overall responsibility for assessing requirements and defining the strategy, technical architecture, implementation plan and delivery of data warehouse projects. The Informatica ETL Architect must have prior experience completing successful data warehousing implementations as well as broad background and experience with IT application development. This individual is responsible for establishing the long term strategy and technical architecture as well as the short term scope for a multi-phased data warehouse effort and should have strong professional consulting skills and the ability to communicate well at all levels of the organization. Top Skill Set:• Lead ETL architecture and design as well as data flow diagramming• Define and implement ETL development standards & procedures• Ensure ETL quality through code reviews and throughout inspection & knowledge sharing• At least 12 years experience with Informatica in a Developer/Tech Lead role• Knowledge of Health Care Insurance Payer Data Warehousing Preferred• Ability to develop a technical work plan and assign work and coordinate across multiple developers and projects. Required Skills/Experience• 12 to 16 Years of Informatica ETL development experience• At least 4 years experience as Informatica ETL Architect• At least 8-10 years experience with Informatica in a Developer/Tech Lead role• Mastery in data warehousing concepts. Candidate should be able to clearly communicate fundamental concepts during the interview and demonstrate previous experience in all aspects.• MUST HAVE strong SQL skills in Oracle Partitioned Environment• Experience in Business Intelligence reporting tools like Cognos and Business Objects preferred• Experience in Oracle database programming using Partitioning, Materialized View and OLAP• Experience in tuning Oracle queries/processes and performance management tools TOOLS & TECHNOLOGIES Informatica 8.x and above (9.1 Preferred) PowerCenter PowerExchange Data Quality Oracle 10g and above Unix Shell Scripting (AIX, Linux) Scheduling Tools (any one of Tivoli, Autosys and Ctrl-M) SQL