Occupation:Datawarehouse Designer |
Location:Owings Mills, MD |
Education Level:Bachelor |
Will Relocate:YES |
Description
Experience Summary: Informatica Certified in MDM Hub and IBM certified in ETL DataStage with more than 9 years of IT experience in: * Performing MDM Solution Architect/ MDM Lead and Data Scientist role in current Project. * Quantitative analysis, data mining, and the presentation of data to benefit end users and guide them for SOPs to interact with our applications. * Working with Partner/Vendor's Product and Engineering teams to solve problems and identify trends and opportunities for custom solution specific to client needs. * Analysis, design, development, testing, maintenance and quality assurance with implementation of software applications in data warehousing. * Design visualization systems for tracking performance metrics and trends for a complex system and actionable items. * Performing Design, Development, testing team and production support (OME) and providing end to end solutions for MDM/ETL projects. * Identify and implement process improvements and effective enhancements in support of an enhanced customer experience. Includes involvement of Downstream Capability teams, key stakeholders and user testing of the new processes to engage customers early in the process. * Installed & Configured core Informatica MDM Hub components: Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, and Cleanse Adapter. * Upgraded several versions (MDM v 10.x and v9.x) of Informatica MDM and applied many Hot Fixes and EBF on different Infrastructure environments. * Administrative knowledge and expertise on Informatica MDM tool and Application server like WebLogic/jBoss. * Business and technical knowledge for the D&B, Global Soft, Address Doctor, FIDA and other web service used in Supply Chain/Pharmaceutical domains. * Testing and Implementation experience of various Custom UIs, ETL and MDM processes components. * Implemented Persistent IDs, IDD/Custom UI, Active VOS integration to accommodate downstream requirements and use out of Box functionality. * Configured JMS messaging and have done customization of XSDs and de-duplication process for the capability teams. * Defining and configuring Base Objects, Staging Tables, Landing Tables, Look-ups, Foreign Key Relationship, Hierarchies, Queries, Query Groups and Update/Display Packages. * Mapping data from Landing Tables to Staging Tables. * Informatica MDM Hub Match and Merge Rules, Batch Jobs and Batch Groups. * Designed & developed multiple cleansing functions and standardization scenarios using Address Doctor. * Importing and exporting the ORS repositories from different environments. * Configuring Entity Base Objects, Entity Types, Relationship Base Objects, Relationship Types, Profiles using Hierarchy tool. * Data warehousing tools like DataStage v7.1, 8.0, 8.5 and 8.7 and Informatica v8.5 and v9.0 Power Center. * Implementation experience in Pharmaceutical domain and Supply Chain and financial domain. * Handling critical situations where: * DataStage WebSphere services are unavailable, or * Oracle performance is reduced for Oracle EBS or * Rebooting a cluster of Oracle/DB2 nodes or * Reports services for intra-applications are unavailable. * Database transformation using the DataStage - Designer and Informatica - workflow, session and mappings. * Monitoring performance of Oracle EBS, DB2, DataStage, Informatica, UC4 and Cron Jobs. * Designing fact and dimensional tables, physical and logical data modeling. * Data warehousing techniques such as Data Cleansing, Slowly Changing Dimension phenomenon, Surrogate key assignment, and change data capture. * DataStage suite of server-side and client-side tools like Designer, Workflow Director, Workflow Manager and Repository Manager. * Different transformation stages such as Aggregate, Joiner, Lookup, Filter, Custom and Expression Transformation. * Complex analytical thinking ability and communication skills. * Various phases of Project Life Cycle such as Requirement gathering, Design, Development and Testing. * Enterprise Dataware Housing Testing - Data Integration, preparation and execution of test strategy, test plans and UAT, test scripts and performing regression testing for any business requirement for performance tuning and data validation.
Accomplishments
Highlights:
Keywords
