Previous Job
Previous
Business Analyst - New york, NY
Ref No.: 17-00487
Location: New york, New York
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
 
  • 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