Excellent skills in retrieving/manipulating data by writing simple/ complex SQL Queries and optimizing SQL and PL/SQL and PL/SQL Protocols to access the repository.Experience in developing logical and physical models and implementing them in Oracle.Familiar with Sybase ASE, Netezza and Oracle environments.Experience in modeling Transactional Databases and Data Warehouses using tools like Erwin and ER/Studio.Thorough experience in all stages of Software Development Life Cycle ( SDLC) with deep understanding of various phases like Requirements gathering, Analysis, Design, Development and Testing.Experience in application of metadata for packaged applications from Seibel, Oracle and SAP.Expertise in CDI (Customer Data Integrity) process.Developed SSIS packages for incremental data capture and historical data.Experience in Pushdown Optimization, Source Qualifier Optimization, and Partition methods in Informatica performance tuning.Very good experience in Performance Tuning for both ETL tools and Query Languages by identifying the amount of data volume to time ratio.Specialized Knowledge in Change Data Capture techniques like Slowly Growing Target and Slowly Changing Dimension (Type 1, Type2 and Type3) simple pass through mapping.Proficient in using Informatica Workflow manager, Workflow monitor, pmcmd (Informatica command line utility) to create schedule and control Workflows, tasks and sessions.Worked extensively in Transportation, Financial, HealthCare and Sales Domains.
#Dell toad data modeler software requirements update#
Experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Router, Filter, Rank, Expression, Aggregator, Joiner, Update Strategy, Key generation.