Shankar Sahu
Data Specialist
Bhubaneswar
Summary
Shankar has more than 7 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
8
8
years of professional experience
7
7
years of post-secondary education
1
1
Certification
Work History
Assistant Consultant
Tata Consultancy Services
Bhubaneswar
03.2023 - Current
Data Engineer
Ernst And Young, EY
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,Odisha 03.2010 - 07.2013
Bachelors of Computer Application - Computer Application
Berhampur University
Berhampur,Odisha 01.2007 - 03.2010
Skills
Informatica PowerCenter/ IICS
Certification
PowerCenter Data Integration 10: Developer, Specialist Certification
Work Availability
monday
tuesday
wednesday
thursday
friday
saturday
sunday
morning
afternoon
evening
swipe to browse
Quote
The way to get started is to quit talking and begin doing.
Walt Disney
Timeline
Assistant Consultant
Tata Consultancy Services
03.2023 - Current
Data Engineer
Ernst And Young, EY
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
03.2010 - 07.2013
Bachelors of Computer Application - Computer Application
Berhampur University
01.2007 - 03.2010
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