Systems Analyst - Florida Blue– Enterprise Data Warehouse
Jacksonville, Florida Area
Systems Analyst• Document system requirement specifications and business process rules• Perform data gap analysis and data profiling tasks• Resolve data issues for incident or request tickets• Write ad-hoc SQL queries for internal customers• Provide testing support• Map metadata into the organization’s Enterprise Metadata Environment• Execute weekly and monthly production data validation scripts• Work with external vendors to ensure that extract files are accurate• Voting member in IM’s Metadata Governance Committee• Strong adherence to SDLC methodology; exposure to AGILE methodology• SharePoint site steward experience• Created and maintained new hire onboarding document• Exposure to UNIX and Windows operating environmentsQA Tester• System test data warehouse tables to ensure all ETL (Extract, Transform, Load) processes perform as expected and that all business rules are followed• Build test cases in HP Quality Center and identify defects• Write complex DB2 SQL queries• Lead test case review sessions with business customers• Provide UAT (User Acceptance Testing) supportTeam SharePoint Site Steward• Manage team site content and permissionsTechnical Skills:Ab Initio EME, Ab Initio Meta SQL, SQL, TOAD and Data Studio for DB2, Basic UNIX commands, IBM Rational ClearCase, IBM Rational RequisitePro, HP Quality Center, Microsoft SharePoint, Microsoft Office, Outlook, Microsoft Visio