Senior Data Warehouse AnalystAbility to combine traditional data warehousing, data analysis, reporting and Online Analytical Processing (OLAP) implementations with operational and analytical systems. To include devising methods for identifying data patterns and trends in available information sources.• Services include real-time data warehousing, enterprise public and internal facing portals, master data management, executive dashboard implementations and ad-hoc solutions.• Build real time integrations solutions from third-party solutions e.g., Salesforce.com. To include creating business intelligence tools or systems, including design of related databases, spreadsheets or outputs.• Development of ETL (Extract, Transform and Load) programs using the Informatica tool suite (PowerCenter and PowerExchange).• Develop and deploy Data Quality (DQ) platforms leveraging Quality and Profiler components.• Define metadata management strategy and its implementation using Informatica's Metadata manager.• Define and integrate client specific ETL best practices.
Leverage, modify and customize ETL architecture components in developing client integration solutions.• Train and mentor client resources on all ETL Technology components.• Ability to perform other senior data analyst functions that may or may not be related to Data Warehouse:o Generate standard or custom reports summarizing business, financial, market or economic data for review by executives, managers, clients, and other stakeholders.o Synthesize current business intelligence or trend data to support recommendations for actiono Maintain library of model documents, templates, or other reusable knowledge assets.o Manage timely flow of business intelligence information to usersQualifications :Bachelor's Degree with advanced experience with one or more leading data warehouse products.• Must have strong core technical competency in database and multi-tier technologies and an understanding of and experience with data extraction from legacy systems.• Understanding of data warehouse modeling concepts a plus.• Must have experience writing and deploying stored procedures, tuning SQL scripts/queries and using database monitoring facilities.