Description
Professional Summary: * Over 9 years of IT experience in analysis, design and development of data warehouse and oracle related applications. * 8 years of solid experience in Extraction, Transformation and Loading (ETL) * Processes using IBM Datastage 9.1, 8.1, 8.0, Ascential Datastage 7.5, Teradata 12.0 version, Netezza and Oracle 7.x/8i/9i/10g/11g * Designed and developed Teradata utility scripts to load data into database * Experience in Oracle, Teradata and well acquainted with RDBMS concepts * Good experience with Teradata Queryman, BTEQ, MultiLoad, FastLoad, and Tpump utilities. * Worked in Banking, Financial and Health Insurance domains. * Extensive knowledge of Software Development Life Cycle (SDLC), having thorough understanding of various phases like Requirements, Analysis/Design, Development and Deployment. * Used IBM information analyzer extensively for complete source system profiling and analysis, to validate data values, validate column/table relationships and drill down to exception rows for further analysis. * Ensured data projects contain trusted information and lower the risk of propagating bad data by using information analyzer * Experience in integration of various data sources with Multiple Relational Databases RDBM systems Oracle, SQLServer, DB2. * Performed Debugging, Troubleshooting and performance tuning of Datastage Jobs. * Extensively worked on Transformer, lookup, join, merge, funnel, Sort, Remove Duplicates, Copy, Filter, Switch, Sequential file, dataset, Change capture and Database stages. * Expert in Dimensional Data Modeling, Star Schema modeling, Snowflake Schema modeling, fact and dimension table design, physical and logical Data modeling using Erwin * Used EPM strategy to review the overall business requirements, and how these requirements have been translated into a project plan and system design.
Accomplishments
Highlights:
Keywords
