Company Name: | American Partners Inc. |
Job Category: | Accounting/Finance/Insurance |
Location: | Multiple Locations |
Position Type: | Type: Experienced (Non-Manager) |
Job Title: | ETL Architect |
Website Address: | http://www.americanpartnersinc.com/ |
Responsibilities include:
- Interview business and technical personnel to understand requirements
- Document requirements
- Develop architecture for project that includes integration (ELT & ETL), logical data model, metadata architecture
- Collaborate with BI architects and developers to support design and development of Business Objects universes
- Collaborate with ETL developers to develop Informatica mappings and work flows
- Collaborate with database administrators to physicalize the logical models
- Collaborate with QA personnel to design test plans and test scripts
Qualifications include:
- Assertive but not arrogant or pushy
- Bachelor’s Degree or equivalent plus 7+ years of data warehouse and business intelligence architecture experience
- 3 years Informatica PowerCenter ETL & ELT development experience
- 4 years experience architecting ETL and ELT into Oracle
- 2-3 years architecting ETL and ELT into Teradata
- 1-2 years use of Informatica / Teradata Push Down technologies
- 1-2 years data modeling using ERWin
- 1-2 yrs experience Metadata modeling
- Excellent oral communication skills, both upwardly (managers, directors, vice presidents) and downwardly (developers)
- Strong written communication skills
- Strong presentation skills
- Demonstrated initiative and follow-through
- Familiarity with at least one Teradata industry logical data model
- Communications LDM preferred