wwwLathaHR.com ETL Architect

Please send the resume with best rate and contact details to rukman@gallopresources.com

Job Description : ETL Architect

Atlanta, GA

6+ Months

Need minimum 8+ Years of experience

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:

• 8-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
  

--
You received this message because you are subscribed to the Google Groups "IT JOBS in USA" group.
To unsubscribe from this group and stop receiving emails from it, send an email to it-jobs-in-usa+unsubscribe@googlegroups.com.
To post to this group, send email to it-jobs-in-usa@googlegroups.com.
Visit this group at http://groups.google.com/group/it-jobs-in-usa.
For more options, visit https://groups.google.com/d/optout.