Professional Summary :
· Overall 8 years of IT experience in the Business Analysis, Design, Data Modeling, Implementation, Development and Testing of Applications using wide range of Technologies including Data Warehousing, ETL, Database and reporting systems for financial and Insurance companies.
· Proven track record in planning, building, and managing successful large-scale Data Warehouse and decision support systems. Comfortable with both technical and functional applications of RDBMS, Data Mapping, Data management, Data transportation and Data Staging.
· 6 years of experience using Teradata SQL Assistant, Informatica Power Center and other data load/export utilities like BTEQ, Fast Load, Multi Load, Fast Export, Exposure to Tpump on UNIX/Windows environments and running the batch process for Teradata CRM.
· Experience working with data modelers to translate business rules/requirements into conceptual/logical dimensional model and worked with complex denormalized and normalized data model.
· Highly experienced in SQL performance tuning and debugging of existing ETL process.
· Experienced in creating complex Informatica mappings using various transformations, and developing strategies for Extraction, Transformation and Loading (ETL) mechanism using Informatica.
· Extensive experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Normalizer and transformation using various COBOL sources, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
· Expertise in developing slowly Changing Dimensions mappings using Change Data Capture:Type 1,Type 2,Type 3.
· Well versed with Informatica 8.1 64 bit.
· Well versed in writing UNIX korn shell scripting.
· Experienced in extracting data from different source systems with different schema types and loading into teradata
· Responsible for designing ETL strategy for both Initial and Incremental loads
· Experience in Relational Data Modeling and Dimensional Data Modeling, Star Schema Modeling, Physical and Logical Data Modeling, Erwin 4.0/3.x, Oracle Designer.
· Demonstrate a willingness, interest, and aptitude to learn new technologies and skills
You received this message because you are subscribed to the Google Groups "dezynvalue" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dezynvalue+unsubscribe@googlegroups.com.
To post to this group, send email to dezynvalue@googlegroups.com.
Visit this group at http://groups.google.com/group/dezynvalue.
For more options, visit https://groups.google.com/d/optout.
