Biswajit Sahoo

Dynamic ETL Developer with a proven track record at Intelliswift, skilled in leveraging Informatica Cloud and SQL to create robust data pipelines. Adept at troubleshooting and optimizing processes, I excel in delivering complex business intelligence solutions while collaborating effectively with cross-functional teams to drive project success.

• English
• Odia
• Hindi

AIPML Data Warehouse, Aegon Life Insurance, Inc., ETL Developer, Windows, SQL, Oracle 10g, Informatica Power Center 10.2, understanding existing business model and customer requirements, understanding the mapping specifications and requirements, extraction of data from various sources using Informatica, designed various mappings for extracting data from various sources involving flat files and relational tables, used Source Analyzer and Warehouse Designer to import the source and target database schemas, and the mapping designer to map source to the target, created various transformations such as Source Qualifier, Aggregator, Expression, Joiner, Filter, Router, Normalizer, Sorter, Lookup, Union, and Sequence Generator transformations, created various tasks like sessions, worklets, and workflows in the workflow manager to test the mapping during development, worked with mapping variables and mapping parameters, developed mapping to load the data in slowly changing dimensions SCD Type-1 and Type-2, checked the output according to the specifications, experience in unconnected and dynamic lookup, experience in extracting the data using incremental loading, deployed the code from DEV to test environments, created mapplets, reusable transformations, and worklets embedding business logic, worked on versioning concepts, configured and ran the debugger from within the mapping designer to troubleshoot the mapping before the normal run of the workflow, tuned several mappings for better performance and was involved in performance testing, worked on different types of tasks like event-wait, command, email, control, and decision tasks, worked on UNIX commands, verified column mapping between source and target tables, prepared documentation for business data flow from source to target and also for the changes made to the mappings/sessions existing to eliminate the errors, provided weekly status reports to the project manager and discussed issues related to quality and deadlines Gift Cards Platform, TD Bank Canada, ETL Developer, Informatica 10.x, Oracle 11g, Unix, Extracted data from oracle database and flat files provided and staged into a single place and applied business logic to load them in the oracle database., Used Various Transform components such as Filter, Router, Union, Sequence Generator, Sorter, Lookup, Joiner and Aggregator., Analysis of the specifications provided by the clients., Created Mappings, Sessions and Workflows using Informatica Powercenter., Loaded the Dimension tables using SCD Type-1 Logic., Participated in testing and performance tuning by identifying bottlenecks in mapping logic and resolving them., Created reusable mapplets/transformations embedding business logic., Working on the aggregator for calculating the aggregate values., Verify the both runs and records on daily basis., Verifying the data in target database after ETL process., Designed workflows with many sessions with decision, assignment task, event wait, Command and Email Tasks., Reporting daily Development status., Attending Sprint planning calls and status calls., Worked closely with the onsite team to understand the business requirements and applying the business rules to make them up to the DW.

I hereby declare that the information furnished above is true to the best of my knowledge and belief.

• Date of Birth: 05/28/92
• Gender: Male
• Nationality: Indian
• Marital Status: Unmarried

Informatica Power Center 10.x, Oracle 11g, 12g, SQL Server 2008, Windows XP, 2000, UNIX, SQL, Putty, SQL Developer, SQL+, WinSCP