Rudra Prasad Barik

Currently deployed in the role of a resident offshore Data Architect for the client called UMG(Universal music group). The project is all about building a royalty portal which is expected to be accessed by various singers across the globe for Artist Royalty, Copyright related statements etc. The underlying technology stack is primarily built on top of AWS cloud services.

Medtronic is one of the largest health care equipment providers on the Globe. The goal of this project is to perform integration on CSOD data ,which serves as a platform where the intended users could leverage that data and draw insight from it.

• Created data pipeline in AWS Glue using Pyspark and Python.
• Prepared Pyspark/python scripts and performed unit testing both locally and using AWS GLUE provided dev end point , before making a script ready as a whole for glue jobs.
• Participated in POC on IICS- Snowflake Integration in the early phase of the project.
• Contributed on building Synchronization task ,Mapping task etc in IICS in order to build a robust data pipeline which would populated 200 gb+ data daily in the target system.
• Designed and created tables in Snowflakes and used snowpipe for ingesting data in near realtime.
• CICD approach was followed with the help of Jenkins and GIT, so contributed to code deployment across different environments.

Project Entail: The goal of this project is to build a Green filed DWH from scratch that would accommodate a range of technologies such as Big Data (AWS EMR), Advanced Analytics (R, SAS for statistical analysis), AWS Redshift, Web services, Message Queue (Amazon SQS), Teradata & AWS Glue (ETL)

• Engaged with other teams and projects to enable best architecture practice for the implementation of complex system landscape comprising of Data Lake Warehouse to align with enterprise business policies, principles and standards.
• Involved in loading data from the different Data sources like (Teradata and Oracle) into S3 and Redshift using Glue.
• Design and Develop ETL Processes in AWS Glue to migrate data from external sources like S3, ORC/Parquet/Text Files into AWS Redshift.
• Create external tables with partitions using Hive, AWS Athena and Redshift.

Jio Analytics program is an initiative to give an edge to business by providing the right information to the right people at the right time, enabling them to take the right decisions.

• Routine health check of all applications, monitoring the informatica/ Oozie workflows and sharing the job status of scheduled batches report to the respective stakeholders.
• Migrated Informatica objects from Dev to Prod environment by using deployment group.
• Involved in leveraging Hadoop ecosystem components including Pig and Hive for data analysis, Sqoop for data migration.
• Worked with different data sources like csv files, JSON files, SQL server and Oracle to load data into Hive/relational tables.

Genworth’s Adminserver takes care of various annuities related reports say fixed annuities, variable annuities etc. Adminserver Screen front-end application accesses the underline data marts in order to address various business queries.

• Used Informatica client tools - Source Analyzer, Target designer, Mapping Designer, Mapplet
• Designer, and Transformation Developer for defining Source & Target definitions and coded the process of data flow from source system to a staging area.

Singapore Telecommunications Limited, commonly abbreviated as SingTel, is a telecommunication company based in Singapore is one of the largest mobile operator in the world .SingTel has a well- established and extensive communications network and infrastructure in Singapore and Australia.This Project is to Design and Construct EDW for SingTel Mobile Singapore Inc.

• Involved in analyzing and importing source tables from the respective databases and flat files
• Used various transformations as part of mappings like source Qualifier, Filter, Aggregator, Expression, and lookup, Sequence Generator
• Developed standard and re-usable mappings and mapplets using various transformations
• Created Mappings, Sessions, workflows for extracting the data from various source systems, flat files and load data in to the staging layer using informatica objects.