Dharmabrata Pradhan

About Dharmabrata Pradhan

12 years plus of IT experience in developing, maintenance and enhancement projects in Data Integration, Data Migration and Data Warehouse technology solutions.Extensively worked on Data Warehouse and Data Migration environments with domain knowledge in Insurance, Re-insurance, Finance and Retirement.Informatica: 12 plus years of ETL development experience using Informatica. Created ETL mapping using most of the Transformation, worklet, workflow.Experience in integration of various data sources with Multiple Relational Databases Oracle, SQL Server, and XML files, Main Frames, IBM DB2, IBM Netezza and Worked on integrating data from flat files like fixed width and delimited.Extensive Experience in designing and developing various complex mappings applying various transformations such as lookup, source qualifier, update strategy, router, sequence generator, aggregator, rank, stored procedure, filter joiner and sorter transformations, Mapplets.Database (Oracle): 9 plus years of Database experience using Oracle 11g/10g; Experience in working with databases like SQL, PL/SQL, SQL*Plus, SQL*Loader. Well versed in using TOAD, PLSQL Developer 3.0 interfaces. Expert in Tuning Oracle SQL, PL/SQL Database Objects.Expert in the development of stored Procedures, Functions, Packages and Triggers, tables, indexes, Materialized Views, Procedures and synonyms.Strong PL/SQL programming skills and expertise with SQL tuning, performance tuning and Bulk binding techniques.Data Quality & Analysis: 6 years of strong Business Analysis experience on Data Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.

Experience

1. Senior Data Engineer

   Nationwide

   Jul 2024 — Present · Columbus, OH, US

Education

• Godavarish Mahavidyalaya , Banpur

  Bachelor of Science (BSc), Physics

  2004 — 2007

• college of engineering and technology ,BBSR

  Master of Computer Applications (MCA), Computer Science

  2007 — 2010

Skills

• Sql
• Linux
• Software Development
• Insurance
• Netezza
• Tws
• Autosys
• Informatica
• Oracle
• Requirements Analysis
• Unix
• Oracle Database
• Uc4
• Finance
• Retirement
• Data Integration
• Software Development Life Cycle (Sdlc)
• Pl/Sql