Having 2.8 years of Overall IT experience in development, analysis, design, enhancements, maintenance and support using business Intelligence technologies, its methodologies, architecture, design principles and current t…
Having 2.8 years of Overall IT experience in development, analysis, design, enhancements, maintenance and support using business Intelligence technologies, its methodologies, architecture, design principles and current trends. Extensively used ETL methodology for supporting Data extraction, transformation and loading processing using Informatica and Azure Data Factory. Expertise in ETL operations using Informatica Power Center 9.x / 10.x. Expertise in ETL operations using Azure Data Factory. Achieved Incremental load in azure databricks by using delta table's. Trained Cloud Technologies like Azure with focused on migration and data processing, automation. Worked on Informatica client tools Designer, Workflow Manager and Workflow Monitor. 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. Processed Clint files and validation of data using stored procedures and then loading the data in the database using Azure Data Factory Pipelines. 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 Fact Loading. Experience in Creating, Scheduling and configuring workflows, worklets and sessions using Informatica workflow manager. Experience in creating mapping parameters and variables to load the stage and Data warehouse incrementally. Involved in Performance tuning and peer review of code. Worked on Dynamic File generation as per the business Logic. Worked on Versioning Concepts on Informatica PowerCenter. Worked and extracted data from various database sources like Oracle, SQL Server and Flat files. Worked with heterogeneous data sources like Oracle, Postgres SQL, SQL Server & Flat Files. Responsible for working with the Data fixes team and supporting each other in all tasks. Interacting with the clients to understand their business requirements and Creating the Functional and Technical Documents. Organizing team meetings to propose viable solutions to key bottleneck issues. Excellent team player with good communication, presentation, analytical, reasoning, troubleshooting, problem solving and leading abilities. Strong analytical, communication, leadership and problem-solving skills. Capable of working as an individual as well as a part of a team.
Developed the pipeline for daily activities of copying the data from file to database.
Worked on ETL process in full load and incremental load.
Stored the data in ADLS after processing it in ADBS.
Created multiple pipelines based on different types of data from file/database.
Validated the data in Source and Target using stored procedures.
Checked the data in MySQL database and ADLS in Azure.
Monitored the pipelines everyday.
Performed full load and incremental load based on requirements.
Integrated data from different sources like BLOB, ADLS, SQL DB.
Processed Clint files and validated data using stored procedures and then loaded the data in the database.
Achieved incremental load in Azure Databricks by using delta tables.
Trained on cloud technologies like Azure with focus on migration and data processing, automation.
Took lead when communicating with client or customer when required.
Having 2.8 years of Overall IT experience in development, analysis, design, enhancements, maintenance and support using business Intelligence technologies, its methodologies, architecture, design principles and current trends.
Extensively used ETL methodology for supporting Data extraction, transformation and loading processing using Informatica and Azure Data Factory.
Expertise in ETL operations using Informatica Power Center 9.x / 10.x
Expertise in ETL operations using Azure Data Factory.
Achieved Incremental load in azure databricks by using delta table’s .
Trained Cloud Technologies like Azure with focused on migration and data processing, automation.
Worked on Informatica client tools Designer, Workflow Manager and Workflow Monitor
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.
Processed Clint files and validation of data using stored procedures and then loading the data in the database using Azure Data Factory Pipelines.
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 Fact Loading.
Experience in Creating, Scheduling and configuring workflows, worklets and sessions using Informatica workflow manager.
Experience in creating mapping parameters and variables to load the stage and Data warehouse incrementally.
Involved in Performance tuning and peer review of code.
Worked on Dynamic File generation as per the business Logic.
Worked on Versioning Concepts on Informatica PowerCenter.
Worked and extracted data from various database sources like Oracle, SQL Server and Flat files.
Worked with heterogeneous data sources like Oracle, Postgres SQL, SQL Server & Flat Files
Responsible for working with the Data fixes team and supporting each other in all tasks.
Interacting with the clients to understand their business requirements and Creating the Functional and Technical Documents.
Organizing team meetings to propose viable solutions to key bottleneck issues.
Excellent team player with good communication, presentation, analytical, reasoning, troubleshooting.
Created ETL mappings using Informatica Power Center to move data from multiple sources like Flat files and Oracle into a common target area such as Staging, Data Warehouse and Data Marts.
Developed different mappings by using transformations like Aggregator, Lookup, Expression, Update Strategy, Joiner, Filter, Sorter, Union and Router to load the data into staging tables and then to Dimension tables.
Used Workflow Manager for creating, validating, testing and running sequential and concurrent sessions and scheduling them to run at specified time.
Involved in performance tuning by optimizing the sources, targets, mappings and sessions.
Created Mapplet and Re-usable Transformations for applying few logics.
Implemented Fact load Mapping.
Tested existing Informatica workflows/mappings and fixed bugs.
Configured database connections in Informatica.
Monitored Informatica jobs and troubleshooting.
Used Informatica Power Center Workflow Manager to create sessions, tasks and workflows.
Verified the data in target database after ETL process.
Performed column data mapping between source and target database.
Monitored transformation processes using Informatica Workflow Monitor.
Identified and fixed bottlenecks and tuned complex Informatica mappings for better performance.
Used SQL tools like SQL Developer to run SQL queries and validate the data loaded into target tables.
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
