Description
One of my top clients, a Bank in Alpharetta Georgia needs an ETL Architect.This is a Long Term Contract with the opportunity to turn Perm.
Will you please find the rest of the job spec below and if you are interested, please respond with a copy of your most recent resume and / or give me a call at ).
Job Description : ETL Architect
Previous ETL (Extraction, Transformation, and Loading) experience using IBM Information server 8.x tool is a must. Experience with any other ETL tool like Informatica is a plus.
Responsibilities:
- Perform technical analysis and prepare recommended ETL design approach
- Participate in a team environment for the design, development and implementation of data warehouse projects.
- Be able to work on multiple projects at a time and be self-motivated.
- Lead and drive a small team including onshore/offshore members responsible for ETL jobs development, debugging and testing to meet project time lines.
- Prepare and present ETL design to onsite DW architects (Internal design review) and BIS design panel.
- Work closely with development manager to finalize on estimated/actual project completion dates for ETL design, development, testing and production roll.
- Work with BIS project managers to finalize on estimated/actual project completion dates.
- Prepare and validate end to end business logic and mappings.
- Develop ETL Job as per design, prepare unit test cases, prepare test data and perform unit testing
- Perform final code review before moving to SIT environment and fix issues in warranty phase
- Prepare detailed design, architecture, mapping sheet and other ETL documents/artifacts
- Resolve all technical issues raised during SIT/UAT/ Warranty phases
- Prepare root cause corrective action document for the ETL issues.
- Participate in IBM Information Server Admin activities (team based)
Required Skills:
- 5-10 years of Data Warehousing experience
- Minimum of 3 years "hands on" ETL development experience with IBM Data Stage Tool
- Minimum of 1 year experience with IBM Information Server admin activities
- Minimum of 2 years of ETL Solutions Architect Experience (Designing ETL jobs/flows )
- Minimum of 2 year experience with any Relation Database. DB2 a plus
- 1-2 years of Unix scripting experience
- 2- 3 years of PL/SQL
- Data Stage jobs/ code debugging and performance improvement skills
Desired Skills:
- Information Analyzer
- Metadata Workbench
- Quality Stage
- Dimensional Modeling
- DB2/Oracle
- Visio
To find out more about Huxley Associates please visit www.huxley.com