Aniruddha Samanta

Aniruddha Samanta

Software Engineer

Followers of Aniruddha Samanta836 followers
location of Aniruddha SamantaKolkata, West Bengal, India

Connect with Aniruddha Samanta to Send Message

Connect

Connect with Aniruddha Samanta to Send Message

Connect
  • Timeline

  • About me

    DCT Consultant at Deloitte USI | Ex- Senior Consultant at PwC India | Ex- Mu Sigman | Ex- Tech Mighty

  • Education

    • St.Xavier's School Higher Secondary Section-Haldia

      2009 - 2011
      Higher Secondary ( State Board ) Science Subjects ( Physics,Chemistry,Mathematics & Biology ) 77.85

      Activities and Societies: Took part in Quiz contests,sports & annual functions.....

    • St.Xavier's School-Haldia

      1998 - 2009
      Secondary General subjects 81.67

      Activities and Societies: Took part in Debate, Quiz competition, Annual School Sports & Cultural Functions....

    • College of Engineering & Management, Kolaghat

      2011 - 2015
      Bachelor of Technology (B.Tech.) Computer Science 8.73

      B.Tech in Computer Science & Engineering

    • West Bengal University of Technology, Kolkata

      2011 - 2015
      Bachelor of Technology (B.Tech.) Computer Science & Engineering 8.73
  • 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
  • Licenses & Certifications

    • Certificate Of Excellence on Sixth Sense Technology

      TECHNOPHILIA SYSTEMS PRIVATE LIMITED
      Mar 2014
    • Certificate on Microelectronics Technology and VLSI Design

      Jadavpur University
      Jun 2014
    • AMCAT Certified Telesales Professional

      Aspiring Minds
      Nov 2014
      View certificate certificate
    • Certificate on Advanced Java (JEE)

      Globsyn Business School
      Dec 2013
    • AMCAT Certified Channel Sales Professional

      Aspiring Minds
      Nov 2014
      View certificate certificate
    • Certificate on Participation on Network Implementation & Security

      Indian Institute of Technology, Delhi
      Oct 2013
    • AMCAT Certified Collections Specialist

      Aspiring Minds
      Nov 2014
      View certificate certificate
    • AMCAT Certified Customer Service Specialist

      Aspiring Minds
      Nov 2014
      View certificate certificate