Bipraraj Roy Email & Phone Number | 1. Write shell script to automate workflow execution and repetitive daily tasks. Scheduled workflows through Autosys and Control-M tool. 2. Created end to end integration to onboard application into Data Warehouse. Application data includes Claims, Policy, Endorsements etc. 3. Worked with various transformations, mapplets and worklets. Implemented key features of Informatica like Dynamic SQL, Indirect file loading, variables and parameters, Exception Handling etc. 4. Design and develop Enterprise Data Warehouse (EDW) solutions to accommodate various source system data into warehouse database. 5. Implement solutions to move incremental/full refresh data from various source systems like Oracle, MySQL, and Flat File etc. through staging area to store the data permanently in Data Mart. 6. Analyzing source data state to design data model and implement TYPE-1/TYPE-II in Datamart as per business requirement. 7. Implemented key ETL features like Partitioning, Push Down Optimization, SCD, CDC etc. 8. Worked with xml transformations to generate xml files from external application database and push xml to data Warehouse solutions through web service/MQ. 9. Tuned Informatica mappings and sessions for optimum performance and resolving performance bottlenecks. 10. Created snowflake schema design in Enterprise Data Warehouse using Dimension and Fact tables. This includes loading Dimension (SCD TYPE-1 or TYPE-II) and Fact tables and linking the fact table with different dimension tables by populating dimension keys into Fact tables. 11. Created Informatica Cloud (IDMC) based Ingestion Framework. It's a complete metadata driven cloud framework with many rich features like error handling, restartability, reusability, scalability etc. 12. Created Informatica (IICS) jobs to move historical and incremental data for 300+ tables from On Premise database to Azure Data Lake Storage Gen 2 as Parquet format. Also the same data was loaded into Azure Databricks tables. 13. Worked on many Informatica Cloud ETL features like Mapping, Mapping task, Synchronization task, Replication task, Task Flows etc. Also worked on various transformation like Source, Target, Filter, Expression, Router, Aggregator within IICS mappings. Used parameter and variable to implement complex features like restartability, error handling. 14. Designed and developed end to end integration to load data in latest cloud platforms like Azure Data Lake and Azure DataBricks. 15. Design and develop control tables in Azure SQL server database to support framework execution for logging and auditing.

Bipraraj Roy

1. Write shell script to automate workflow execution and repetitive daily tasks. Scheduled workflows...
Tata Consultancy Services, Tata Consultancy Services, India

*50 free lookup(s) per month.

No credit card required.

Bipraraj Roy’s Email bipraraj.roy@tcs.com

Bipraraj Roy’s Phone Numbers

Get BIPRARAJ’s Phone Number (For Free)

Social Media

Bipraraj Roy’s Location Tata Consultancy Services, Tata Consultancy Services, India

Bipraraj Roy’s Current Industry Cognizant

Bipraraj Roy’s Prior Industry Tata Consultancy Services

Not the Bipraraj Roy you were looking for?

Find accurate emails & phone numbers for over 700M professionals.

Work Experience

Cognizant

Associate

2022-08-01 00:00:00 - Present

Tata Consultancy Services

IT Analyst

2020-09-01 00:00:00 - 2022-05-01 00:00:00

Skills

No Skills Available

Languages

No Languages Available

FAQ About Bipraraj Roy

Bipraraj Roy is located at
Tata Consultancy Services, Tata Consultancy Services, India

Bipraraj Roy is a 1. Write shell script to automate workflow execution and repetitive daily tasks. Scheduled workflows through Autosys and Control-M tool. 2. Created end to end integration to onboard application into Data Warehouse. Application data includes Claims, Policy, Endorsements etc. 3. Worked with various transformations, mapplets and worklets. Implemented key features of Informatica like Dynamic SQL, Indirect file loading, variables and parameters, Exception Handling etc. 4. Design and develop Enterprise Data Warehouse (EDW) solutions to accommodate various source system data into warehouse database. 5. Implement solutions to move incremental/full refresh data from various source systems like Oracle, MySQL, and Flat File etc. through staging area to store the data permanently in Data Mart. 6. Analyzing source data state to design data model and implement TYPE-1/TYPE-II in Datamart as per business requirement. 7. Implemented key ETL features like Partitioning, Push Down Optimization, SCD, CDC etc. 8. Worked with xml transformations to generate xml files from external application database and push xml to data Warehouse solutions through web service/MQ. 9. Tuned Informatica mappings and sessions for optimum performance and resolving performance bottlenecks. 10. Created snowflake schema design in Enterprise Data Warehouse using Dimension and Fact tables. This includes loading Dimension (SCD TYPE-1 or TYPE-II) and Fact tables and linking the fact table with different dimension tables by populating dimension keys into Fact tables. 11. Created Informatica Cloud (IDMC) based Ingestion Framework. It's a complete metadata driven cloud framework with many rich features like error handling, restartability, reusability, scalability etc. 12. Created Informatica (IICS) jobs to move historical and incremental data for 300+ tables from On Premise database to Azure Data Lake Storage Gen 2 as Parquet format. Also the same data was loaded into Azure Databricks tables. 13. Worked on many Informatica Cloud ETL features like Mapping, Mapping task, Synchronization task, Replication task, Task Flows etc. Also worked on various transformation like Source, Target, Filter, Expression, Router, Aggregator within IICS mappings. Used parameter and variable to implement complex features like restartability, error handling. 14. Designed and developed end to end integration to load data in latest cloud platforms like Azure Data Lake and Azure DataBricks. 15. Design and develop control tables in Azure SQL server database to support framework execution for logging and auditing.