Distance
    Nationwide

    Posted within
    Sort-by
    Specialized Skills
    States

Sr.Technical Analyst with strong SQL/ETL

Location:   VA

Posted On:  15days ago

Job Description

BI Technical Analyst experience with strong Oracle SQL skills, MS Excel and Reporting skills required.

Why does this need exist?

  1. Asurion is embarking on SSIS to Informatica migration engagement. The migration will take place all through 2016 and into 2017. Asurion wants to leverage Agile / Scrum teams to have these migrations completed as part of monthly Sprints.
  2. Other initiatives and back filling.

WHAT WILL DAY TO DAY RESPONSIBILITIES BE FOR THIS CONSULTANT?

  1. Responsible for business requirements gathering and fit/gap analysis with business team for BI / DW / ETL initiatives.
  2. Understand business process and perform analysis of SSIS jobs.
  3. Work closely with Lead ETL Developer to come up with a migration solution to be developed in Informatica.
  4. Assist in data mapping exercise with Insurance / Financial legacy systems.
  5. Assist in gap analysis and data mapping between the warehouse, data mart and ETL layer.
  6. Build Traceability matrix for all attributes and measures.
  7. Build Data flow, Design flow and Navigation flow diagrams.
  8. Develop functional specifications and establish priorities for accomplishing design, development and testing of ETL solution.
  9. Review, develop, recommend, and implement activities, programs, or functions as assigned.

IMPORTANT - AREAS CANDIDATES MUST BE ABLE TO DO/SPEAK TO - REQUIREMENTS ANALYSIS

  • Testing (data validation testing, end to end, test cases etc.)
  • SQL – aggregate and analytic functions, queries
  • Data Analysis (data mapping, data diagrams, etc.)
  • DWH background – Support of projects with SQL/Oracle/SSIS/Informatica (any combination of these) in their environments.
  • Cloud/Big data exposure - ideal.