ETL Architect (Must have experience over 10 years)

in Michigan(MI)

Location: Lansing, MI

Duration: 12+ months


Design and architect Extract, Transfer and Load (ETL) strategies needed to support required staging, warehouse, or data marts. Develop detailed implementation plans estimating duration and identifying dependencies. Collaborate across Information Technology areas and business areas to ensure data artifacts meet requirements of upstream and downstream claim processing needs. Ensure all artifacts comply with enterprise standards and governance. Design, build and deploy high quality, performance, integrated, and documented ETL solutions while following established standards. Conceptualize, analyze, develop, and deploy strategies for data acquisition, transformation, and loading on an enterprise level. Identifies key drivers of a defined problem and proposes solutions. Serves as an expert resource on matters of data architecture, design in all phases of data warehouse and data mart development, implementation and support. Ensure logical data model and other data artifacts are consistent, accurate, flexible and scalable. Ability to successfully work within multiple requirements, design, and development approaches and methodologies (agile, iterative, waterfall, etc.) Minimum of ten years as an DataStage Architect

Skills Needed

Experience of leading and supporting delivery of development services Required 5 Years

Experience in data architecture, data modeling, data warehousing, data mining, data entity analysis, logical and relational data base design. Required 5 Years

Exposure pulling data from multiple sources including: xml, web services, delimited flat files, and other data sources. Required 5 Years

Experience with Business Intelligence, Dashboards or 3rd party analytics platforms. Required 5 Years

Experience with IBM SAP Connectors and ABAP coding. Required 5 Years

Experience with UNIX scripting, Structure Query Language (SQL), Basic Teradata Query Reference (BTEQ), Macros. Required 5 Years

Experience in performing data mining and data analytics, on data-sets and data-marts within a Teradata/Oracle database environment. Required 5 Years

Experience in programming, in particular to drive analysis tools and prepare data marts, including expertise in writing Teradata Queries. Required 5 Years

Extensive knowledge of Teradata database, data warehousing and information management best practices. Required 5 Years

Experience in using Teradata utilities TPT, TPump, BTEQ, fastload, fastexport and multiload. Required 5 Years

Experience in SQL programming (views/store procedures/macros/functions) based on User requirements and architectural guidelines and standards. Required 5 Years

Hands on technical experience with Teradata, Oracle, SAP and Microsoft SQL Server. Required 5 Years

Experience working with IBM InfoSphere Suite Required 5 Years

Recent jobs at EADJObs.com
Senior Business Analyst in New York(NY) 29-12-2017
SQL DBA :: Lansing in Michigan(MI) 29-12-2017
Sr. ETL Developer in California(CA) 08-12-2017
devloper in California(CA) 08-12-2017
Java developer in Ohio(OH) 08-12-2017

« Go back to category
Recommend to a friend
Published at 01-09-2017
Viewed: 34 times