Job Description :
Title : ETL Business Analyst
Location : Denver
Visa : GC/US/H4EAD ( Need locals)
Interview : Telephonic and In-Person
-ONLY LOCALS - ONLY LOCALS -
Description: Need a strong Business Analyst with strong ETL project experience* = NEED PERFECT MATCHING
As a Business Analyst you will perform requirement gathering and analysis, data analysis, data mapping, functional design, quality assurance/Testing and documentation for ETL related projects. The individual will be working closely with ETL Leads, Solution Consultants and testing team.
Responsibilities:
Primary responsibilities include: Perform requirement gathering and analysis of applications and their business processes
Performs analysis that is diverse and very complex and works independently under general direction (i.e. writing queries)
Perform Data Analysis, develop Data Mapping and Functional Solution Design documents for ETL projects.
Works with Development Team to ensure feasibility of design and clarify user requirements.
Capture business rules and build physical design document to meet user requirements.
Work with Data Modelers and DBA to create/update table structures.
Understand and Interpret Logical design document and Data Model diagrams to understand requirements to build physical design document.
Effectively communicate the functional design to developers and confirm the same with solution design team.
Develops test scenarios and scripts that match the business user''s objectives to confirm system functions are met.
Work with Development and Testing team to support testing activities.
Qualifications:
Typically requires a minimum of 3-5 years of related experience or equivalent combination of education and experience.
Strong knowledge and experience in Foundation Systems (Membership System for CA regions)
Candidate must have hands on experience in Mainframe and Oracle technologies
Candidate must have strong knowledge and experience in interpreting user requirements and building Physical Solution Design Document.
Candidate must have good knowledge and experience in understanding logical mapping and data model to build Physical Design document.
Strong knowledge and experience in Data Warehousing (ETL, Data Analysis, etc) concepts.
Strong intuitive and analytical problem solving skills.
Good understanding on testing principles, concepts and tools. Advanced working knowledge of Testing, Business Analysis techniques and tools.
Should have ability to write and execute complex SQL Statements especially in Oracle Environments.
Expertise with Defect Management Tools preferably Mercury Tools preferred.
Good understanding and experience in writing test cases/plans, executing test cases & identifying defects.
Technical Qualifications: Sound knowledge and experience in Oracle, and Mainframe systems.