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
<p>Currently working as an ETL Developer in Roots Systems PVT LTD, Chennai from Oct 2019 to till date.</p>
<p>Used Informatica PowerCenter 10.5.0 for extraction, transformation and load (ETL) of data in the data warehouse.<br>
Worked on Informatica Power Centre client tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet designer and Transformations Developer.<br>
Used Informatica PowerCenter Workflow manager to create sessions and workflows.<br>
Developed complex mappings in Informatica to load the data from various sources.<br>
Created various transformations such as Source Qualifier, Aggregator, Expression, Joiner, Filter, Router, Normalizer, Sorter, Lookup, Union and Sequence Generator transformations.<br>
Creating workflows and sessions.<br>
Created mappings that involved implementation of Business Logic to load data in to staging area.<br>
Used Informatica Reusable concepts like Reusable Transformations, Mapplets and Worklets at various levels of development<br>
Experience in loading Various Dimension tables using SCD Type-1 & Type-2.<br>
Experience in Fact Loading.<br>
Experience in Un-Connection & Dynamic Lookup.<br>
Experience in extracting the data using Incremental loading.<br>
Created Mapping parameters and variables using Informatica Parameterization.<br>
Created the parameter files to parametrize Source connections, target Connections, Filename, session log names, mapping parameters and variables etc.<br>
Tested the mapping to view data got populated according to specified logics in the technical specification document.<br>
Applied Informatica Performance tuning steps on Mappings<br>
Deployed the code from DEV to Test Environments.<br>
Worked on Versioning concepts.<br>
Worked on Different Types Tasks like Event-wait, Command, Email, Control and Decisions Tasks<br>
Configuring the Databases connections in Informatica.<br>
Verifying the ETL data in target database<br>
Involved in Unit Testing.<br>
Worked on UNIX shell scripting.<br>
Verified column mapping between source and target tables.</p>
<p>Got Trained on Informatica PowerCenter.<br>
Developed various mappings with the collection of all Sources, Targets, and Transformations using Informatica Designer.<br>
Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica PowerCenter<br>
Created various transformations such as Aggregator, Expression, Source Qualifier, Joiner, Filter, Router, Sorter Union and Sequence Generator transformations.<br>
Created Mappings, Sessions and Workflows using Informatica PowerCenter.<br>
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.<br>
Loaded the Dimension tables using SCD Type-1 Logic.<br>
Participated in testing and performance tuning by identifying bottlenecks in mapping logic and resolving them.<br>
Verifying the data in target database after ETL process.<br>
Reporting daily Development status.<br>
Attending Sprint planning calls and status calls.</p>
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
