Around 7 years of experience in ETL software development life cycle which includes Requirement, Analysis, Design, implementation, Testing, Debugging, and deployment of various Data Warehousing Applications. Experience in…
Around 7 years of experience in ETL software development life cycle which includes Requirement, Analysis, Design, implementation, Testing, Debugging, and deployment of various Data Warehousing Applications. Experience in the integration of various data sources with ETL tools and strong understanding of relational database concepts and data warehousing.
Co-ordination from various business users, stakeholders, and SME to get functional expertise, design, and business test scenarios review, UAT participation and validation of data from multiple sources.
Performed detailed data investigation and analysis of known data quality issues in related databases through SQL.
Created SSIS Package to load data from Flat file and XML to report-data mart and data warehouse.
Implemented REST API using .NET.
Created the Detail Technical Design Documents which have the ETL technical specifications for the given functionality.
Prepared source to target mapping and conducted meetings with the business to understand data / transformation logic.
Actively involved in Analysis phase of the business requirement and design of the Informatica mappings.
Performed data validation, data auditing and data cleansing activities to ensure high quality deliveries.
Used various transformations of Informatica, such as Source Qualifier, Expression, Look-up, Update Strategy, Filter, Router, Joiner etc. for developing Informatica mappings.
Developed Informatica mappings for TYPE 1 and 2 Slowly Changing Dimensions.
Created Mapping using Parameters and Variables (Session’s parameters and variables, Mapping parameters and variables).
Created sessions and workflows for the Informatica mappings.
Created mappings with connected look-up, unconnected lookups.
Created various Mapplets as part of mapping design.
Created effective Test Cases and performed Unit and Integration Testing to ensure the successful execution of data loading process.
Documented Mappings, Transformations and Informatica sessions.
Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.
Worked on performance tuning by determining bottlenecks at various points like targets, sources, mappings, sessions, or system. This led to better session performance.
I have been working as ETL Informatica developer for more than 5 years in different domains like banking, insurance and retail industry.
I have been designing and developing data warehouse which is my
Actively involved in interacting with business users to record user requirements and Business Analysis.
Participated in the Design Team and user requirement gathering meetings.
Documented Data Mappings/ Transformations as per the business requirement.
Extensively used Informatica Designer to create and manipulate source and target definitions, mappings, Mapplets, transformations, re-usable transformations.
Created different source definitions to extract data from flat files and relational tables for Informatica Power Center.
Developed Informatica Mappings and Reusable Transformations to facilitate Loading of Data of a star schema tables.
Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
Developed a standard ETL framework to enable the reusability of similar logic across the board.
Created different transformations such as Joiner Transformations, Look-up Transformations, Rank Transformations, Expressions, Aggregators and Sequence Generator.
Fixed Performance issue in Informatica mappings.
Migrated Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
Wrote SQL query for data analysis to validate the input data against business rules.
Improved performance testing in Mapping and the session level.
Analyze business requirements, technical specification, source repositories and physical data models for ETL mapping and process flow.
Worked extensively with mappings using expressions, aggregators, filters, lookup, joiners, update strategy and stored procedure transformations.
Developed mapping to load Fact and Dimension tables, for type 1 and type 2 dimensions and incremental loading and unit tested the mappings.
Coordinate and develop all documents related to ETL design and development.
Responsible for debugging and performance tuning of targets, sources, mappings, and sessions.
Optimized the mappings and implementing the complex business rules by creating re-usable transformations and Mapplets.
Optimized the source queries in order to control the temp space and added delay intervals depending upon the business requirement for performance.
Used Informatica workflow manager for creating, running the Batches and Sessions, and scheduling them to run at specified time.
Executed sessions, sequential and concurrent batches for proper execution of mappings and set up email delivery after execution.
Implemented and documented all the best practices used for the data warehouse.
Improving the performance tuning of ETL mapping/workflow.
Created Workflows, tasks, database connections using workflow manager.
Responsible for identifying bugs in existing mappings by analyzing data flow, evaluating transformations, and fixing bugs.
Code walks through with team members.
نظام التوظيف التشغيلي المعتمد على الذكاء الاصطناعي أولاً، الذي يوحّد ويؤتمت دورة التوظيف بالكامل للمؤسسات الحديثة حول العالم.
د.جوب منطقة حرة ذ.م.م. 2026 © جميع الحقوق محفوظة
