Intend to build a career in a work environment where I can get a chance to explore cutting-edge technologies and realize my potential. Willing to work as a key player in challenging & creative environment.
• Regular practitioner of Informatica and oracle databases.
• Extracted data from oracle database and flat files provided and staged into a single place.
• 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.
• 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
Currently working as an ETL Developer in Roots Systems PVT LTD, Chennai from Oct 2019 to till date.
Used Informatica PowerCenter 10.5.0 for extraction, transformation and load (ETL) of data in the data warehouse.
Worked on Informatica Power Centre client tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet designer and Transformations Developer.
Used Informatica PowerCenter Workflow manager to create sessions and workflows.
Developed complex mappings in Informatica to load the data from various sources.
Created various transformations such as Source Qualifier, Aggregator, Expression, Joiner, Filter, Router, Normalizer, Sorter, Lookup, Union and Sequence Generator transformations.
Creating workflows and sessions.
Created mappings that involved implementation of Business Logic to load data in to staging area.
Used Informatica Reusable concepts like Reusable Transformations, Mapplets and Worklets at various levels of development
Experience in loading Various Dimension tables using SCD Type-1 & Type-2.
Experience in Fact Loading.
Experience in Un-Connection & Dynamic Lookup.
Experience in extracting the data using Incremental loading.
Created Mapping parameters and variables using Informatica Parameterization.
Created the parameter files to parametrize Source connections, target Connections, Filename, session log names, mapping parameters and variables etc.
Tested the mapping to view data got populated according to specified logics in the technical specification document.
Applied Informatica Performance tuning steps on Mappings
Deployed the code from DEV to Test Environments.
Worked on Versioning concepts.
Worked on Different Types Tasks like Event-wait, Command, Email, Control and Decisions Tasks
Configuring the Databases connections in Informatica.
Verifying the ETL data in target database
Involved in Unit Testing.
Worked on UNIX shell scripting.
Verified column mapping between source and target tables.
Got Trained on Informatica PowerCenter.
Developed various mappings with the collection of all Sources, Targets, and Transformations using Informatica Designer.
Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica PowerCenter
Created various transformations such as Aggregator, Expression, Source Qualifier, Joiner, Filter, Router, Sorter Union and Sequence Generator transformations.
Created Mappings, Sessions and Workflows using Informatica PowerCenter.
Extracted data from oracle database and flat files provided and staged into a single place and applied business logic to load them in the oracle database.
Loaded the Dimension tables using SCD Type-1 Logic.
Participated in testing and performance tuning by identifying bottlenecks in mapping logic and resolving them.
Verifying the data in target database after ETL process.
Reporting daily Development status.
Attending Sprint planning calls and status calls.
The AI-first Recruitment Operating System that unifies and automates the entire hiring lifecycle for modern enterprises worldwide.
Dr Job FZ LLC. 2026 © All Rights Reserved
