Business Analyst - New york, NY - Georgia IT Inc.
New york, NY
About the Job
Job Title : Business Analyst
Location : New york, NY
Rate : DOE
Position Type : Contract (6-12 months +)
Interview : Phone
(US Citizens/ GC/GC-EAD/TN/E3 preferred)
Job description
Location : New york, NY
Rate : DOE
Position Type : Contract (6-12 months +)
Interview : Phone
(US Citizens/ GC/GC-EAD/TN/E3 preferred)
Job description
- Stong Business Analyst with excellent communicaiton skills and ability to interface with all levels of management. Must have excellent reporting skills and Business Intelligence perspective. OBIA / EBS experience would be highly desireable.
- Design & Develop BI Physical Data Model
- Determine whether calculations and processing should be done in BI application or the ETL process
- Determine requirements for aggregate tables, hierarchies, level based measures, etc.
- Move data into the data warehouse for report unit testing
- Experience with leading a team of developers (1 to 7 resources) through the business requirements and analysis process, as well as the full SDLC implementation
- Ability to manage and mentor junior developers, including delegating work, performing design reviews, and code reviews
- Version controlling code, handling both production branches as well as enhancement branches effectively
- Understanding of Business Analysis for dimensional data model
- Experience with creating / maintaining Informatica ETL workflows and mappings
- Design and development of ETL programs for creating all data warehouse tables, to support initial load, refresh and on-going update strategies
- Experience with maintaining and troubleshooting Oracle DAC workflows.
- Understanding of Oracle E-Business Suite/Hyperion source system data models
- Work with the project manager, architects, and other team members to define metrics and performance goals for the application
- Participate in transitioning the requirements and use cases to the designers, and ensure a clear and complete understanding of the requirements
- Assist in translating requirements and use cases into test conditions and expected results for product, performance, and user acceptance testing
- Provide guidance on RDBMS system configuration and performance tuning including tuning on detailed, base aggregate and additional aggregate fact and dimension tables
- Suggest index strategies and other adjustments to optimize performance
- Years of Experience with Informatica: 7 to 10 years
- Knowledge of Oracle Business Intelligence Applications 7.9.6.3 and 7.9.6.4 a plus
Source : Georgia IT Inc.