![]() Experience in Creating SSIS package development and implementation for different tasks.Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, user defined data types and functions.Involved in the Migration process from Development, Test and Production Environments.Experience on Monitoring and Scheduling of Jobs using UNIX (Korn & Bourn Shell) Scripting.Familiar in using cloud components and connectors to make API calls for accessing data from cloud storage ( Google Drive, Salesforce, Amazon S3, DropBox ) in Talend Open Studio.Experience with Informatica Advanced Techniques like Dynamic Caching, Memory Management, Parallel Processing to increase Performance throughput.Strong Experience in developing Sessions/tasks, Worklets, Workflows using Workflow Manager Tools - Task Developer, Workflow & Worklet Designer.Worked extensively with complex mappings using different transformations like Source Qualifiers, Expressions, Filters, Joiners, Routers, Union, Unconnected / Connected Lookups and Aggregators. ![]() ![]() Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.Have extensively worked in developing ETL for supporting Data Extraction, transformations and loading using Informatica Power Center and Informatica Cloud Real Time(ICRT).Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server and Worked on integrating data from flat files like fixed width and delimited.Good knowledge of Data warehouse concepts and principles - Star Schema, Snowflake, SCD, Surrogate keys, Normalization/De normalization.Over 7+ years of experience in Information Technology with a strong background in Database development and Data warehousing and ETL process using Informatica Power Center 9.x/8.x/7.x.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |