Now you can Instantly Chat with Himalayanaidu!
- Over 7.5 Years of IT experience in Data warehousing technologies using Informatica Power Center. Having 4 years of relevant experience in Teradata ...
Processing tasks using Workflow Manager to move data from multiple sources into target systems
- Worked on Informatica Power Center Transformations such as Source qualifier, Sorter, Filter, Expression, Aggregator, Router, Lookup, Sequence Generator, Update strategy, Union transformations
- Strong experience in creating complex mappings using various transformations and developing strategies for Extraction, Transformation and Loading (ETL) mechanism by using Informatica. Extensively used the Mapping Parameters, Mapping Variables, and Mapplets for mapping re-usability
- Experience in creating Incremental Extraction by using mapping variables
- Expertise in integration of various Relational and Non-Relational sources such as Oracle, Teradata, MSSQLServer, Flat files and Excels into Staging Area
- Experience in developing SCD Type-1, SCD Type-2 mappings and CDC
- Extensive knowledge on Teradata Load utilities like BTEQ, FastLoad, MultiLoad, TPump and FastExport
- Having Strong knowledge on Data Modeling in both Relational and Dimensional modelling, Data warehouse Concepts, Teradata Architecture, Statistics collection, Joins, Queries, Sub Queries, Functions, OLAP Functions
- Good observation on the usage of SI, JI, HI, PPI, compression on various tables,
EXPLAIN and ARCMAIN Command in UNIX
- Experience in performance Tuning of Informatica sources, Targets, Mappings. Identifying the long running queries, scripts, spool space or no room issues etc. implementing the appropriate tuning methods
- Involved in implementing Error Handling Process and working with Configuration Files. Handled Errors with the help of ET, UV and WT Tables
- Good knowledge on MSBI (DQS, SSIS, SSAS and SSRS), Writing MDX Queries and Tabular Model.
- Solid understanding of Data warehousing concepts, Star schema and Snow-flake schema, Data Marts, Dimension and Fact tables
- Performed Data reconciliation in various source systems and also in Teradata. Involved in unit testing and prepared test cases accordingly
- Exceptional communication skills, strong analytical and problem solving skills. Highly capable to rapidly learn new technology and adapt to a new environment