Shankar Sahu
Bhubaneswar
Summary
Shankar has more than 10 years of experience in the area of DWBI application development using Informatica PowerCenter, IICS, Oracle, DB2, Snowflake,R with focus on requirement analysis, design, development, coding, quality reviews and testing majorly in Insurance and Banking domain. Experienced in client management and proven collaboration skills have helped in expanding client engagement. Extensively worked with Informatica performance tuning involving source level, target level, mapping level and session level bottlenecks. Actively participated in Requirement Analysis and Documentation with Clients at offshore on application migration and development process.
Overview
11
11
years of professional experience
1
1
Certification
Work History
Sr Data Engineer
Tata Consultancy Services
Bhubaneswar
03.2022 - Current
- Migrated approximately 200 PowerCenter workflows, achieving nearly 100% data consistency with IICS.
- Developed test plans and conducted thorough testing of migrated workflows to validate performance and functionality.
- Identified and resolved discrepancies and performance bottlenecks through systematic troubleshooting.
- Implemented quality assurance best practices to minimize disruption during migration.
- Provided guidance in troubleshooting migration-related challenges and optimizing workflow performance in IICS.
Data Engineer
Ernst And Young
Bangalore
02.2021 - 02.2022
- Currently working as data engineer for AML managed services.
- Generate alerts for suspicious transaction in Fin Crime domain by assessing customer transaction behavior.
- Performed customer segmentation and Above/Below line testing to tune thresholds for AML risk assessment.
- Developed CRS techniques to detect money laundering activity.
- Designed KPIs' to check monitoring efficiency and effectiveness of transaction monitoring.
Senior Informatica Developer
HCL Technologies Ltd
Chennai
09.2019 - 02.2021
- Played role of ETL expert along with taking care of client engagements - which involved weekly meetings with clients for strategy and planning.
- Worked closely with clients and business analysts, gathering requirements, determining capacity based on timelines and coordinated with onshore counterparts.
- Worked on complex ETL pipelines involving data ingestion from heterogeneous sources, including complex multi-hierarchy XML.
- Created various Data Integration mappings using different transformations then loaded data into snowflake.
- Used Snowflake to ingest data from different file formats like Json, Parquet etc.
- Have worked in snow pipe, Stream, task, external stage, Snow SQL & external tables in snowflake.
- Was part of Informatica Centre of Excellence and worked closely with senior architects and leaders.
- Was also core member of innovation team to drive innovations across account.
- Decreased batch running time by 15% after optimizing workflows.
Senior Informatica Developer
Cognizant Technology Solution
Kolkata
09.2015 - 08.2019
- Have performed source system analysis for designing purpose.
- Involved in Designing area like S2T preparation, HLD & TTD preparation.
- Have performed Code development in Informatica (10.2) with proper unit testing and involved in peer review to enhance coding standard.
- Prepared various mappings to generate XML files.
- Unit testing performed with proper Unit test cases & test log.
- Managing module by preparing estimation on project plan and Status Reports.
- Performed data loading for QA & UAT.
- Involved in guidance & grooming of team members.
- Have worked on POC for Configuration of MQ in Informatica PowerCenter.
ETL Developer
People Prime Worldwide
Kolkata
10.2014 - 08.2015
- Have performed source system analysis for designing purpose.
- Involved in Designing area like S2T preparation, HLD & TTD preparation.
- Have performed Code development in Informatica (10.2) with proper unit testing and involved in peer review to enhance coding standard.
- Prepared various mappings to generate XML files.
- Unit testing performed with proper Unit test cases & test log.
- Managing module by preparing estimation on project plan and Status Reports.
- Performed data loading for QA & UAT.
Education
Master of Computer Application - Computer Application
GITA Affiliated To Biju Patnaik University of Technology
Bhubaneswar, Odisha07.2013
Bachelors of Computer Application - Computer Application
Berhampur University
Berhampur, Odisha03.2010
Skills
- Informatica PowerCenter
- IICS
- Oracle
- SQL Server2008
- DB2
- Unix Shell Scripting
- Data Analytics with Python
- Data Analytics with R
- Snowflake
- PL/SQL
Certification
- PowerCenter Data Integration 10: Developer, Specialist Certification, 07/20
- Snowflake SnowPro Core Certification, 08/24
Timeline
Sr Data Engineer
Tata Consultancy Services
03.2022 - Current
Data Engineer
Ernst And Young
02.2021 - 02.2022
Senior Informatica Developer
HCL Technologies Ltd
09.2019 - 02.2021
Senior Informatica Developer
Cognizant Technology Solution
09.2015 - 08.2019
ETL Developer
People Prime Worldwide
10.2014 - 08.2015
Master of Computer Application - Computer Application
GITA Affiliated To Biju Patnaik University of Technology
Bachelors of Computer Application - Computer Application
Berhampur University
Similar Profiles
Vrunda ChindhadeVrunda Chindhade
HR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services LimitedHR Manager at Tata Consultancy Services, TCS, Tata Consultancy Services Limited
Sreya BasuSreya Basu
Procare Analyst at Tata Steel(Tata Consultancy Services)Procare Analyst at Tata Steel(Tata Consultancy Services)
Arun VArun V
Program Manager at Tata consultancy services | Financial Ombudsman ServicesProgram Manager at Tata consultancy services | Financial Ombudsman Services
Naimish AgnihotriNaimish Agnihotri
Assistant Delivery Manager at Tata Consultancy Services, Global Shared ServicesAssistant Delivery Manager at Tata Consultancy Services, Global Shared Services
SHAKTIPRASAD MISHRASHAKTIPRASAD MISHRA
Project Associate-I at BRIC-Institute of Life SciencesProject Associate-I at BRIC-Institute of Life Sciences