Vacancy expired!
- Act as a Business Systems Analyst in client Data Integration & Account Conversion project team
- Analyze the impacts of data integration on Data Warehouse and Big Data environment
- Analyze and coordinate regression testing requirements across all lines of businesses
- Analyze the performance impacts of moving Data Warehouse to Google Cloud Platform (Google Cloud Platform)
- Coordinate with source systems and downstream system teams to assess the impacts and implement a remediation plan
- Coordinate with infrastructure teams, DBA’s, and admins to evaluate the performance impact on ETL jobs, SLAs on data availability, and plan on remediation
- Analyze source system data, profiling data (using SQL and Hive QL), and arranging service level agreements with data providers
- Design conceptual and logical data models (using Erwin), create metadata definitions and create the source-to-target mapping.
- Act as requirements coordinator for 1-2 medium to large projects, capture usage requirements, and design the semantic/information layer.
- Partner with business users and acting as a liaison between business and technical teams.
- Coordinate data model reviews and handoff to the ETL development team.
- Build a deep understanding of the warehouse data and capabilities.
- Must have at least 1-year of recent experience using Google Cloud Big Query.
- Experience in data modelling (logical and/or physical) with a solid understanding of 3NF, Star Schemas, and performance concerns
- Familiarity with Informatica and Hive preferred.