5 Years of experience in Software development and services. Extensively worked on Data Warehousing, and Data Integration projects using Informatica tools.
Strong Hands-on experience with Informatica PowerCenter 9.x /10.x…
5 Years of experience in Software development and services. Extensively worked on Data Warehousing, and Data Integration projects using Informatica tools.
Strong Hands-on experience with Informatica PowerCenter 9.x /10.x
Knowledge in implementing Data Warehouse application, especially ETL processes using Informatica Power Center.
Extensive experience in Extraction, Transformation and Loading of data directly from heterogeneous source systems like flat files, Oracle by using Informatica power center.
Extensively Worked on Informatica Designer Components - Source Analyzer, Target Designer, Transformation Developer, Mapplets and Mapping Designer.
Experience in developing Informatica Mappings/Mapplets to extract data from multiple sources, transform data, and then loaded into Operational Data Store (staging area) and then load into Data Warehouse.
Experience in Creating complex mappings using Aggregator, Expression, Joiner, Filter, Sequence Generator, Connected & Unconnected Lookup, Router, Union and Update Strategy transformations using Informatica Power center designer.
Experience in Creating Connected, Un-Connected & Dynamic lookups (Cache).
Created mapplets / reusable transformations embedding business logic.
Experience in Creating SCD Type-1 and Type-2 mapping technique to load the data into various dimension tables.
Experience in Error handling as per the business validations, preparing unit test cases in Informatica.
Experience in Fact Loading.
Customized SQL override queries where ever possible to minimize the use of Joiner, Sorter, Filter Transformations.
Developed all the mappings according to the design document and mapping specs provided and performed unit testing.
Used Parameterization for Mapping, Workflows and sessions.
Hands on dynamic parameter file creation.
Identifying the bottlenecks and implement the Performance tuning & Optimization techniques in power center.
Experience in creating mapping parameters and variables to load the stage and Data warehouse incrementally.
Worked on Versioning Concepts on Informatica PowerCenter.
Below is a list of important products, tools and methods that I have worked.
Working as ETL Developer in Antrix Technology India Private Limited (TCS), Bangalore since Oct-2018 to till date.
Having Strong Communication Skills and intercommunication among Team members and Onsite team.
Excellent team player, innovative and quick learner. Extremely interested in new technologies, ideas and learning.
Exceptionally good in anticipating client requirements.
Punctual, Dedicated.
My role here is to do mappings, sessions and workflows according to business request and change request.
In this project I got the sources in the form of tables and files , these tables and files are stored in staging area by using Incremental load and mapping Variable.
Working as ETL Developer in Antrix Technology India Private Limited (TCS), Bangalore since Oct-2018 to till date.
Understanding existing business model and customer requirements.
Understanding the mapping specifications and requirements.
Extraction of data from various sources using Informatica.
Designed various mappings for extracting data from various sources involving flat files and relational tables.
Used Source Analyzer and Warehouse Designer to import the source and target database schemas, and the mapping designer to map source to the target.
Created various transformations such as Source Qualifier, Aggregator, Expression, Joiner, Filter, Router, Normalizer, Sorter, Lookup, Union and Sequence Generator transformations.
Created various tasks like sessions, worklets, and workflows in the workflow manager to test the mapping during development.
Worked with Mapping Variables and Mapping Parameters.
Developed mapping to load the data in slowly changing dimensions SCD Type -1 and Type-2
Checked the output according to the specifications.
Experience in Un-Connection & Dynamic Lookup
Experience in extracting the data using Incremental loading.
Customized SQL override queries where ever possible to minimize the use of Joiner, Sorter, Filter Transformations.
Deployed the code from DEV to Test Environments.
Created mapplets , reusable transformations and Workets embedding business logic.
Worked on Versioning concepts.
Configured and ran the Debugger from within the Mapping Designer to troubleshoot the mapping before the normal run of the workflow.
Tuned several mappings for the better performance and involved in Performance Testing.
Worked on Different Types Tasks like Event-wait , Command , Email , Control and Decision Tasks.
Worked on UNIX commands.
Verified column mapping between source and target tables.
Prepared documentation for business data flow from source to target and also for the changes made to the mappings/sessions existing to eliminate the errors.
Provide weekly status report to the Project Manager and discuss issues related to quality and deadlines.
Extracted data from oracle database and flat files provided and staged into a single place and
Used Various Transform components such as Filter, Router, Union, Sequence Generator, Sorter, Lookup, Joiner and Aggregator.
Analysis of the specifications provided by the clients.
Created Mappings, Sessions and Workflows using Informatica PowerCenter.
Loaded the Dimension tables using SCD Type-1 Logic.
Participated in testing and performance tuning by identifying bottlenecks in mapping logic and resolving them.
Created reusable mapplets/transformations embedding business logic.
Working on the aggregator for calculating the aggregate values.
Verify the both runs and records on daily basis.
Verifying the data in target database after ETL process.
Designed workflows with many sessions with decision, assignment task, event wait, Command and Email Tasks.
Customized SQL override queries where ever possible to minimize the use of Joiner, Sorter, Filter Transformations.
Reporting daily Development status.
Attending Sprint planning calls and status calls.
Worked closely with the onsite team to understand the business requirements and applying the business rules to make them up to the DW
نظام التوظيف التشغيلي المعتمد على الذكاء الاصطناعي أولاً، الذي يوحّد ويؤتمت دورة التوظيف بالكامل للمؤسسات الحديثة حول العالم.
د.جوب منطقة حرة ذ.م.م. 2026 © جميع الحقوق محفوظة
