![]() Experienced in coding UNIX shell scripts.Expertise in the QA process of ETL mappings like Unit, Functional and Integration testing.Experience in writing PL/SQL stored procedures, triggers and functions.Experience in writing and tuning complex SQL queries.Experience wif data cleansing issues and Meta Data Management in the implementation of ETL methodology in Data Extraction, Transformation and Loading using Informatica Power Center 9.5.1/9.1.0/9.0.1.Experienced wif Dimensional modeling to Design and develop Star/Snowflake schemas using Erwin data modeling tool.Experienced in performance tuning of mappings, sessions and workflows including partitioning using Informatica Power Center 9.5.1/9.1.0/9.0.1.Extracted data from (SFDC),Oracle, excel, data files using Informatica ETL mappings/SQL PLSQL scripts.Extensively worked on creating Mappings, Transformations, Sessions, Workflows and, worklets to extract data from various sources and load into targets using Informatica Power Center 9.5.1/9.1.0/9.0.1.Involved in functional and technical Systems Analysis & Design, Systems architectural design, Presentation, process data flow design system impact analysis, star schema, snowflake, changing dimension, Gap analysis and documentation. ![]() Experienced in all phases of the Systems Development Lifecycle - Analysis, Design, System Implementation, System Testing, Acceptance and Maintenance.Extensively worked on databases Oracle, Teradata, SQL server, Netezza and DB2.Experienced in Informatica Data validation output.Experienced in Informatica cloud and Informatica data masking.Experienced in Informatica B2B Data exchange.Extensive experience in ETL using Informatica Power Center including installation and configuration in Client/Server environment.8 Years of IT experience in Data Warehousing & RDBMS wif in - depth noledge on operational and reporting environments in all phases including design, development, testing and implementation of enterprise data warehouse.
0 Comments
Leave a Reply. |