Poornesh Kolandareddy

Responsibility

• Extraction, Transformation and Loading (ETL) of data by using Informatica Power Center.
• Extracted source data from flat files, Oracle and loaded to an Oracle.
• Created mappings using the transformations such as the Source qualifier, Aggregator, Expression, Router, Filter, Sequence Generator, and Update Strategy.
• Involved in Creating Sessions, Workflows Using Workflow Manager

Walmart Inc. Jan/21 –May/22

Associate Software Engineer

Walmart: Wal-Mart Stores, Inc. (Walmart) is an American multinational retail corporation that operates a chain of hypermarkets, discount department stores, and grocery stores from the united states, headquartered in bentonville, arkansas. To handle the issues in processing the orders, ensure without delaying order, preventing the order returns and make sure the order adjustments are completed as planned.The following are scope of the project.

Responsibilities:

• Worked on gathering business requirements.
• Create an Assumption and issue log for dataMart.
• Created Logical data model, physical data model and bus matrix for order dataMart.
• Data cleansing by handling missing values, null values, de-duplicates and more.
• Worked on ETL tool- Informatica powercenter, reporting tool – excel.
• Implemented SCD frameworks for dimension tables in informatica powercenter.
• Implemented Incremental load for fact tables in informatica powercenter.