نبذة عني
•Results-oriented professional with 5 years of hands-on experience specializing in the implementation of Data Warehousing applications utilizing ETL tools. •Proficient in executing ETL operations leveraging Informatica P…
•Results-oriented professional with 5 years of hands-on experience specializing in the implementation of Data Warehousing applications utilizing ETL tools. •Proficient in executing ETL operations leveraging Informatica PowerCenter 9.5.1/10.5.1 and adept at utilizing Informatica client tools including Repository Manager, Designer, Workflow Manager, and Workflow Monitor. •Extensively skilled in Informatica Designer Components such as Source Analyzer, Target Designer, Transformation Developer, and Mapping Designer. •Demonstrated expertise in developing Informatica Mappings for data extraction from diverse sources, transformation, and loading into Operational Data Store (staging area) and Data Warehouse. •Experienced in creating session, scheduling and configuring workflow using Informatica Workflow Manager. •Demonstrated proficiency in repository object migration, ensuring smooth transitions from development to QA and production environments.
الخبرة
ETL Informatica Developer
Results-oriented professional with 4 years of hands-on experience specializing in the implementation of Data Warehousing applications utilizing ETL tools., Proficient in executing ETL operations leveraging Informatica PowerCenter 9.5.1/10.5.1 and adept at utilizing Informatica client tools., Extensively skilled in Informatica Designer Components and developing Informatica Mappings for data extraction., Proven track record in crafting mappings incorporating various transformations using Informatica PowerCenter Designer., Experienced in creating session, scheduling and configuring workflow using Informatica Workflow Manager., Skilled in creating parameter files for source connections, target connections, filenames, session log names, mapping parameters, and variables., Demonstrated proficiency in repository object migration and ensuring smooth transitions from development to other environments., Monitored and resolved any failures in daily running production jobs by analyzing session logs., Developed various mappings encompassing all Sources, Targets, and Transformations using Informatica Designer., Responsible for designing and customizing existing workflows and mapping logics., Developed ETL solutions for reporting purposes and provided ongoing support and maintenance for ETL jobs.
ETL Informatica Developer
Results-oriented professional with 4 years of hands-on experience specializing in the implementation of Data Warehousing applications utilizing ETL tools.
Proficient in executing ETL operations leveraging Informatica PowerCenter 9.5.1/10.5.1 and adept at utilizing Informatica client tools including Repository Manager, Designer, Workflow Manager and Workflow Monitor.
Extensively skilled in Informatica Designer Components such as Source Analyzer, Target Designer, Transformation Developer, and Mapping Designer.
Demonstrated expertise in developing Informatica Mappings for data extraction from diverse sources, transformation, and loading into Operational Data Store (staging area) and Data Warehouse.
Proven track record in crafting mappings incorporating various transformations including Aggregator, Expression, Joiner, Filter, Sequence Generator, Connected & Unconnected Lookup, Router, Union, and Update Strategy transformations using Informatica PowerCenter Designer.
Proficient in creating reusable transformations embedded with business logic.
Experienced in creating session, scheduling and configuring workflow using Informatica Workflow Manager.
Skilled in creating parameter files for source connections, target connections, filenames, session log names, mapping parameters and variables.
Familiar with Versioning Concepts in Informatica PowerCenter.
Successfully extracted data from diverse database sources including Oracle, SQL Server, and Flat files.
Demonstrated proficiency in repository object migration, ensuring smooth transitions from development to QA and production environments.
Monitored and resolved any failures in daily running production jobs by analysing session logs.
Developed various mappings encompassing all Sources, Targets, and Transformations using Informatica Designer.
Responsible for designing and customizing existing workflows and mapping logics to enhance performance and reduce complexity.
Developed ETL solutions for reporting purposes to effectively meet business outcome requirements.
Provided ongoing support and maintenance for ETL jobs, including addressing production issues, troubleshooting failures, and implementing enhancements or bug fixes as necessary.
المشاريع
Inhouse Project Enhancement
The project aims to enhance existing projects in accordance with business requirements. This involves modifying and designing mappings using Informatica PowerCenter and implementing database changes using Oracle SQL Developer.Roles and responsibilities:•Designed, developed, tested, and implemented ETL (Extract, Transform, Load) processes using Informatica PowerCenter to migrate data from various source systems to target databases/data warehouses.•Monitored and resolved any failures in daily running production jobs by analysing session logs.•Developed various mappings encompassing all Sources, Targets, and Transformations using Informatica Designer.•Responsible for designing and customizing existing workflows and mapping logics to enhance performance and reduce complexity.•Developed ETL solutions for reporting purposes to effectively meet business outcome requirements.•Delivered timely, validated, and well-tested work products.