Summary
Overview
Work History
Education
Skills
Timeline
Generic

Siba Shankar Senapati

Summary

8+ years of extensive experience in ETL tools and DWH/BI Expertise in ETL Development, Implementation, unit Testing, Enhancements, and support Extensively used ETL methodology for supporting data extraction, Transformation and Loading process. Extensive experience in Extraction, Transformation and Loading of data from heterogeneous Source systems. Experience in Informatica, Oracle, SQL, PL/SQL, Scheduling tools, Unix

Overview

8
8
years of professional experience

Work History

Senior Associate -Projects

Cognizant Technology Solutions
Hyderabad
04.2024 - Current
  • To monitor the daily loads, where the jobs are scheduled in Tidal.
  • Reporting the failures and analyzing the root cause of the failure in production, and resolving on time.
  • Solid understanding of the whole data flow for different source systems, such as one path, Nori, Symphony, Adzymna, Liquid Hub, iEngage, and Omni.
  • Extensively checked S3 paths for files that need to be picked up by BDM jobs as a source.
  • Knowledge of various IICS connections used in the project.
  • Worked on service tasks analysis and provided the required information to users.
  • Worked on the enhancement tasks in IICS and Informatica BDM mappings, and deployed them to the higher environments.
  • Extensively used Databricks and notebook jobs to check the data on different tables.
  • Worked on Ticketing tool ServiceNow to address the issues reported by users.

Senior Consultant

Capgemini Technical Services India Private Limited
Bangalore
07.2021 - 03.2024
  • To work on development and enhancement tasks.
  • Having experience working with Informatica IICS tool effectively, using it for data integration and data migration from multiple source systems in AWS.
  • Solid understanding of ETL design principles and good practical knowledge of performing ETL design processes through Informatica intelligent cloud services (IICS)
  • Designed, Developed, and Implemented ETL processes using IICS Data integration.
  • Created IICS connections using various cloud connectors in IICS administrator.
  • Extensively used performance tuning techniques while loading data into AWS S3 using IICS.
  • Extensively used cloud transformations – Aggregator, Expression, Filter, Joiner, Lookup (connected and unconnected), Rank, Router, Sequence Generator, Sorter, Update Strategy, Union Transformations
  • Extensively used cloud connectors: Flat file, AWS, Oracle, and Google Cloud.
  • Gathering requirements and implementing them into source to target mappings in landing, staging, and ODS.
  • Continuously in touch with the Product Owner and Scrum Master to get additional information details.
  • Parameterized all mapping, session parameters, and DB connections wherever necessary in the sandbox and common folder, and updated them whenever necessary for migrations in different environments at the root directory.
  • Scheduled jobs for running daily, weekly, and monthly loads through Informatica for each workflow in a sequence with Autosys.
  • Involved in meeting minutes for status reports, updates, any issues for any change procedures to the Scrum Master.
  • Effectively understood session error logs and used debugger to test mapping, and fixed bugs in DEV, following change procedures and validation.

Informatica Developer

Infosys Limited
Bangalore
10.2018 - 07.2021
  • Interacting with client manager to gather requirements.
  • Created mappings to populate the data marts from heterogeneous sources.
  • Executing workflows through workflow manager and using third-party tools like UC4.
  • Extensively used GitLab to implement CI/CD.

Informatica Developer

HCL Technologies
Bangalore
06.2016 - 09.2018
  • Involved in unit testing.
  • Extracted data from the database and spreadsheets, staged it into a single place, and applied business logic to load it into the central database.
  • Created mappings using expression, filter, router, sequence generator, joiner, aggregator, lookup (connected/unconnected), source qualifier, update strategy transformations.

Education

B.Tech - Electronics And Communications Engineering

Gandhi Institute of Science And Technology
Rayagada
05-2013

Skills

  • Operating System: Windows, Linux
  • Database: SQL, Oracle 11g, DB2, Oracle 21C, MS SQL Server, Databricks
  • ETL Tools: Informatica PowerCenter V104, IICS
  • Scripting Languages: SQL, PL/SQL, Unix Shell scripting, Python
  • Scheduling Tools: Automic (UC4), Autosys, Tidal
  • Other Tools: Serena Dimensions (deployment tool), HP Quality Center, IT Service now, Jira Board, Putty
  • Management and Leadership Skills: Analysis of Business Requirements, Leading, Development and testing
  • Training & Development: Completed Core Python Training and IICS R38 Training
  • Knowledge on Other Technology: Knowledge on IICS CDI Knowledge on AWS S3, Redshift, EC2, Lambda Services

Timeline

Senior Associate -Projects

Cognizant Technology Solutions
04.2024 - Current

Senior Consultant

Capgemini Technical Services India Private Limited
07.2021 - 03.2024

Informatica Developer

Infosys Limited
10.2018 - 07.2021

Informatica Developer

HCL Technologies
06.2016 - 09.2018

B.Tech - Electronics And Communications Engineering

Gandhi Institute of Science And Technology

Similar Profiles

CREATE PROFILE
Siba Shankar Senapati