Amsterdam, North Holland, Netherlands
Collaborated with business and architecture team to develop, recommend, implement and manage the technical architecture used for Business Intelligence reporting applications in a large, distributed and cross-platform environment. Designed solutions that will integrate with new and legacy applications and ensure that the system architecture balances functional, service quality and systems management requirements. Provided guidance and advise on appropriate design standards, methods, tools and ensured that they are applied effectively. Provided direction and guidance to clients on strategy and road-map to move from traditional data warehouse to advanced analytics. Skills - Data Integration, Data Analysis, Data Modeling, ETL, Reporting Technologies - Informatica, OBIEE, Oracle BI Apps, SQL, Teradata, Power BI, Tableau
Producing detailed component requirements, specifications and translate these into detailed solutions/designs for implementation using selected products. Provide advice on technical aspects of system development, integration, and processes. Transforming requirements into conceptual data models, including socializing and implementing logical and physical DW/data mart data models; identifying data sources and metadata (including business rules, definitions, attributes, etc.) to deliver analytic requirements Impact Analysis, High Level Design, Detailed design specifications for ETL and Reporting. Develop and Review ETL methodology for supporting Data Transformations & Data Processing using Informatica Participate in creating the implementation plan as per the project level quality plan and work on go live activities as per the Implementation plan. Skills - Relational modeling, Star Schema, OLAP, Data Analysis, Performance tuning, ETL, BI Technologies - Informatica, OBIEE, Oracle BI Apps, SQL, MS SQL Server, DAC
Do impact analysis, participate in high level design, create design specifications for data Extraction, Transformation and Loading. Develop and review Artifacts (Informatica and Oracle Business Intelligence Code, Documentation, Unit test scripts) conduct reviews for self and peers, conduct unit test. Perform Validation activities (Functional, Integration, System, User Experience) based on the plans for Business Intelligence Solutions. Skills - Data Analysis, Dimensional Modeling, Performance tuning, ETL, Reporting Technologies - Informatica, OBIEE, Siebel Analytics, Teradata, DAC