{"id":1111,"date":"2008-09-25T17:15:05","date_gmt":"2008-09-25T21:15:05","guid":{"rendered":"http:\/\/www.asianinny.com\/?p=1111"},"modified":"2008-09-30T17:19:02","modified_gmt":"2008-09-30T21:19:02","slug":"etl-architect","status":"publish","type":"post","link":"http:\/\/www.asianinny.com\/?p=1111","title":{"rendered":"ETL Architect"},"content":{"rendered":"<table width=\"420\" border=\"1\" cellpadding=\"5\" cellspacing=\"1\">\n<tr>\n<td width=\"70\"><strong>Company Name:<\/strong><\/td>\n<td>American Partners Inc.<\/td>\n<\/tr>\n<tr>\n<td><strong>Job Category:<\/strong><\/td>\n<td>Accounting\/Finance\/Insurance<\/td>\n<\/tr>\n<tr>\n<td><strong>Location:<\/strong><\/td>\n<td>Multiple Locations<\/td>\n<\/tr>\n<tr>\n<td><strong>Position Type:<\/strong><\/td>\n<td>Type: Experienced (Non-Manager)<\/td>\n<\/tr>\n<tr>\n<td><strong>Job Title:<\/strong><\/td>\n<td>ETL Architect<\/td>\n<\/tr>\n<tr>\n<td><strong>Website Address:<\/strong><\/td>\n<td><a href=\"http:\/\/www.americanpartnersinc.com\">http:\/\/www.americanpartnersinc.com\/<\/a><\/td>\n<\/tr>\n<\/table>\n<p><!--more--><br \/>\n<strong>Responsibilities include:<\/strong><\/p>\n<ul>\n<li>Interview business and technical personnel to understand requirements<\/li>\n<li>Document requirements<\/li>\n<li>Develop architecture for project that includes integration (ELT &#038; ETL), logical data model, metadata architecture<\/li>\n<li>Collaborate with BI architects and developers to support design and development of Business Objects universes<\/li>\n<li>Collaborate with ETL developers to develop Informatica mappings and work flows<\/li>\n<li>Collaborate with database administrators to physicalize the logical models<\/li>\n<li>Collaborate with QA personnel to design test plans and test scripts<\/li>\n<\/ul>\n<p><strong>Qualifications include:<\/strong><\/p>\n<ul>\n<li>Assertive but not arrogant or pushy<\/li>\n<li>Bachelor\u2019s Degree or equivalent plus 7+ years of data warehouse and business intelligence architecture experience<\/li>\n<li>3 years Informatica PowerCenter ETL &#038; ELT development experience<\/li>\n<li>4 years experience architecting ETL and ELT into Oracle<\/li>\n<li>2-3 years architecting ETL and ELT into Teradata<\/li>\n<li>1-2 years use of Informatica \/ Teradata Push Down technologies<\/li>\n<li>1-2 years data modeling using ERWin<\/li>\n<li>1-2 yrs experience Metadata modeling<\/li>\n<li>Excellent oral communication skills, both upwardly (managers, directors, vice presidents) and downwardly (developers)<\/li>\n<li>Strong written communication skills<\/li>\n<li>Strong presentation skills<\/li>\n<li>Demonstrated initiative and follow-through<\/li>\n<li>Familiarity with at least one Teradata industry logical data model<\/li>\n<li>Communications LDM preferred<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>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\/<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1111","post","type-post","status-publish","format-standard","hentry","category-looking-for-work-search-our-premium-job-database"],"_links":{"self":[{"href":"http:\/\/www.asianinny.com\/index.php?rest_route=\/wp\/v2\/posts\/1111","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.asianinny.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.asianinny.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.asianinny.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"http:\/\/www.asianinny.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1111"}],"version-history":[{"count":0,"href":"http:\/\/www.asianinny.com\/index.php?rest_route=\/wp\/v2\/posts\/1111\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.asianinny.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1111"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.asianinny.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1111"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.asianinny.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1111"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}