Aniruddha Samanta

Experience

• 

  Tech Mahindra

  Jan 2016 - Nov 2018

  Software Engineer

  Department :- UDMF, BI and BIG DATA.*********************Current Project*****************************--- > Currently, I am working as an ETL Developer of Rogers Telecommunications Inc Canada. ( Client )--- > Interacted with end users and line managers to gather business requirements and conducted user acceptance.---> Interacted with third party vendors and identified different external and internal homogeneous and heterogeneous sources and extracted and integrated data from flat files, Oracle, SQL Server sources and migrated those applications to Oracle Exadata platform using INFORMATICA BI tool.---> Created Informatica Data quality plans according to the business requirements to standardize, cleanse data and validate addresses.---> Co-ordinate monthly road map releases to push enhanced/new informatica code to production.---> Wrote various technical documents, including Business Requirements, Functional and Technical Specifications, SDS, SDD,Change Summary Documents, Data Flow and Process diagrams using MS Power Point and MS Word.---> Developed and maintained ETL (Data Extraction, Transformation and Loading) mappings using Informatica Designer 9.6 to extract the data from multiple source systems that comprise databases like Oracle 10g, SQL Server 7.2, flat files to the Staging area, EDW and then to the Data Marts.---> Created mappings using different look-ups like connected, unconnected and Dynamic look-up with different caches such as persistent cache.---> Performed Impact Analysis of the changes done to the existing mappings and provided the feedback.---> Worked on Informatica Source Analyzer, Mapping Designer, and various Transformations like Source Qualifier, Expression, Router, Aggregator, Filter, Update Strategy, Joiner, etc.Environment:- Informatica Power Center 9.6.1, BMC Control M, UNIX, Oracle SQL Developer 10g Show less

• 

  Mu Sigma Inc.

  Dec 2018 - Oct 2019

  ETL Developer
• 

  PwC India

  Nov 2019 - Mar 2022

  • Senior Consultant

    Oct 2020 - Mar 2022

  • Consultant

    Nov 2019 - Oct 2020
• 

  Deloitte

  Apr 2022 - now

  Consultant