BHAVYA BHASIN

The AA Company is a UK’s leading provider of roadside assistance system which offers car insurance, Breakdown cover, Route planner etc.

Roles:

• I worked as a developer on this project and used Informatica BDM, Python, Pyspark, and Azure Databricks.
• We work on the User Stories-drafted business requirements.
• First, files are sent to us by various source teams.
• Following file receipt, we build a pipeline to extract data from the source and transform it into a table format if it is available in files such as JSON, XML, etc.
• Finally, we execute a workflow that calls our task that we created to call the pipelines that we built.
• The first task under our task is to create a table using our schema files.
• The second task is to carry out any necessary conversions in accordance with the mapdoc that has been approved by the business.
• We push data into targets that are present in Azure DataBricks after completing these tasks.
• We collaborate with the QA and testing team for unit testing after the first development phase is complete.
• After testing is finished, we will plan our jobs to be deployed to their secure environment. We will use Azure Devops system to do this deployed code in Production, and after that, we must release this table for end users on the Power Bi reporting system so that downstream users can access it.

Blue shield of California is a Healthcare system which offers health plans for every budget that include individual and family plans, Medicare, Medi-Cal, dental and vision.

In This Project, we have to convert Informatica PowerCenter mapping into Informatica MDM standards. I have used Data Ingestion Framework and Data Distribution Framework to Ingest different types of data from raw layer to hive database using these frameworks.

Roles:

• I have worked as a developer in this project. Firstly, we have to import PowerCenter mapping into MDM environment. As in PowerCenter we use Netezza-based data marts that we want to convert into Hadoop based data marts.
• So to get this objective, we use sources and targets both as Hive tables instead of Netezza sources and targets.
• We try to covert and implement same logics in MDM as of we used in PowerCenter by using MDM standards. While doing this we have used many transformation to get to main objectives
• To reach this objective we have use both Data Ingestion Framework and Data Distribution Framework.
• Data Ingestion Framework is used for ingesting data into Hadoop-based Enterprise Data Lake. It is a home grow Solution built using Informatica MDM Suite and Hadoop ecosystem Tools. We have used this from ingesting hive sources.
• Data Distribution Framework is a dynamic mappings featuring to implement configurable workflows that can be re-used for publishing data using various targets such as Mainframe, Relational Database and Flat File.
• I have used this Framework to convert hive target into appropriate data target as per downstream users.

BB&T is a banking system which has different aspects such as ATM, Insurance, Account Opening etc. In This Project, we have to convert Informatica PowerCenter mapping into Informatica BDM standards. I have used Data Ingestion Framework and Data Distribution Framework to Ingest different types of data from raw layer to hive database using these frameworks.

Roles:

● I have worked as a developer in this project.

● Firstly, we have to import PowerCenter mapping into BDM environment. As in PowerCenter we use Netezza-based data marts that we want to convert into Hadoop-based data marts.

● So to get this objective, we use sources and targets both as Hive tables instead of Netezza sources and targets. We try to covert and implement same logics in BDM as of we used in PowerCenter by using BDM standards.

● While doing this we have used many transformation to get to main objectives. To reach this objective we have use both Data Ingestion Framework and Data Distribution Framework.

● Data Ingestion Framework is used for ingesting data into Hadoop-based Enterprise Data Lake. It is a home grow Solution built using Informatica BDM Suite and Hadoop ecosystem Tools. We have used this from ingesting hive sources.

● Data Distribution Framework is a dynamic mappings featuring to implement configurable workflows that can be re-used for publishing data using various targets such as Mainframe, Relational Database and Flat File. I have used this Framework to convert hive target into appropriate data target as per downstream users.

BB&T is a banking system which has different aspects such as ATM, Insurance,Account Opening etc. In This Project I have used Data Ingestion Framework to Ingest different types of data from raw layer to hive database.

Roles:

● I am working as a developer on this project.

● We work on business requirements drafted in User Stories.

● Firstly, we receive files from the source team, by using BDM we can transfer whole data at once in their environment.

● After receiving files we create flat file data objects and relational data objects in BDM to set a base for data as we insert column names of source data we receive.

● Afterwards we use hadoop and hive queries to validate whether data in source file is the same as data in target files or not.

● After initial development is done we connect with the QA & testing team for unit test.

● Once testing is completed then we will schedule our jobs to deploy to their secure environment, for Deployment we use CA workstation.

Full-Stack AI Developer Cognizant Internship Engagement During this program, I got trained as AI fullstack developer. I learnt technologies like AWS, Oracle SQL , Python and also Data Warehouse concepts. Developed and implemented end-to-end AI solutions, leveraging machine learning algorithms and deep neural networks, resulting in a improvement in accuracy and efficiency of predictive analytics models. Optimized the performance of existing AI algorithms and frameworks through parallel processing techniques, resulting in a reduction in processing time for large-scale data sets.