About

Shivam Bajpai is an Associate IT Consultant with over 7 years of experience in Informatica Power Center, Oracle SQL and PL-SQL, UNIX, DAC, and Bitbucket. He holds a Bachelor of Technology degree in Electrical, Electronics, and Communications Engineering from ABES, Ghaziabad. Currently, Shivam is working with ITC Infotech as a Senior Informatica ETL Developer for their client Fidelity International in Gurgaon. He has previously worked with AWC Software Private Limited and HCL Technologies Ltd. as an Oracle Database and Informatica ETL Developer. Shivam has carried offer letters from two MNCs, HCL Technologies and Cognizant Technology Solutions. Shivam has a solid understanding of data warehouse concepts such as Star and Snowflake Schema, Facts and Dimension tables, OLTP Vs OLAP, Active and Passive Informatica transformations. He has strong technical and functional knowledge of Informatica Power Center Components such as Repository Manager(R), Power Center Designer(D), Workflow Manager(W), and Workflow Monitor(M). Shivam has implemented various mappings using transformations like Source Qualifier, Sorter, Lookup (both connected and unconnected), Router, Expression, Union, Sequence Generator transformation, etc. He has also been involved in implementing the Slowly Changing Dimensions (SCD) Type 1/Type 2 Logic in the mappings. Shivam has good experience in designing complex queries using various Oracle Database Concepts. He has also used Data warehouse Administration Console (DAC) for various activities such as executing workflows, configuring Physical Data Sources, Subject Areas, executing and monitoring execution plans. Shivam has been involved in various Admin related activities such as Informatica and DAC Environment Refresh from Production Environment. He has basic exposure in UNIX environment using Putty for making Informatica and DAC services UP/Down, checking Ports and Error Logs. Shivam has strong functional knowledge in Financial Services domain such as Accounting of Profit and Loss, Project Accounting, Account Payables, Account Receivables, and also worked on the implementation of Intercompany Transactions. He has basic exposure to OBIEE Application which is utilized in extracting various reports Dashboards and Ad-Hoc Reports. Shivam has utilized various Oracle SQL concepts such as while Joins, Procedures, Functions, Packages, Cursors, Indexes while implementing project enhancements. Shivam's tech stack includes SQL, ETL, Data Warehouse, Snowflake, and designer. He is a result-oriented professional with a track record