Defined and design schema, staging tables, and landing tables, base objects foreign-key Relationships, look up systems and tables, packages, query groups and queries/custom queries.Worked with vendors to identify challenges and utilized existing solution for Confidential customer master data for efficiency reporting.Designed MDM end to end process the streamline the Customer master operation for GCOI. ![]() Perform proofs of concept (PoCs) and other technical evaluations of technologies, designs, and solutions as required.Execute on set architectural guidelines and long term architecture strategy, and ensure compliance of the reference architecture and security requirements. Working with MDM team for implementation of TDM for dynamics data masking for securitization of customer information.Defined overall MDM solution architecture and sets technical direction, defines component architecture, and reviews detailed designs for accuracy and overall compliance to defined architecture.Areas of concentration include End to End integration solution, Real time changes, Security, Enterprise Architecture, and Transformative IT Technologies including Business Process Modeling, Real time Computing, and SOA. Provided technology and architecture-related thought, strategic direction, and long-term vision.Worked with Stakeholders and Business Partners through the journey of delivering projects in a co-production model by developing a customer Center of Excellence focused on PRPC and skills.Oracle warehouse builderOracle 10g/9i/8i.Informatica 10.0 8.6/8.1/7.1.2/7.1.1/6.2/5.1.2/4.7 (Informatica power center/power mart/power exchange Informatica Data Quality Siperian MDM).Experience with Data governance suite, Informatica PDM (Persistent Data Masking), DDM (Dynamic Data Masking).Extensive experience with Multiple Relational Databases like Oracle, SQL Server, Teradata,SAP.Solid skills in Informatica Power Center, SQL, PL/SQL, Stored Procedures and Triggers, Performing Debugging, Troubleshooting and Performance Tuning.Strong knowledge in Kimball and Inmon methodology and models, Dimensional modeling using Star schema and Snowflake schema.Proficient in developing Informatica IDQ transformations like Parser, Classifier, Standardizer and Decision. Worked on Data Profiling using IDE-Informatica Data Explorer and IDQ-Informatica Data Quality to examine different patterns of source data. ![]()
0 Comments
Leave a Reply. |