Sunil Gupta

Sunil Gupta

Informatica ETL Developer

Followers of Sunil Gupta225 followers
location of Sunil GuptaBengaluru, Karnataka, India

Connect with Sunil Gupta to Send Message

Connect

Connect with Sunil Gupta to Send Message

Connect
  • Timeline

  • About me

    Datawarehousing |ETL| Data Analytics| AWS Certified Soultions Architect| Informatica PowerCenter| Oracle l SQL|SAP BO|SAP BODS| Performance tuning

  • Education

    • Great Learning

      2022 - 2022
      Postgraduate Degree Cloud Computing

      Post Graduate Program in Cloud computing covering Amazon AWS, Microsoft Azure and Google GCP.

    • Madan Mohan Malaviya University of Technology

      2002 - 2006
      B.Tech.(Hons.) Electronics and Communications
  • Experience

    • Tata Consultancy Services

      Jan 2006 - Jan 2010
      Informatica ETL Developer

      Informatica PowerCenter ETL Developer for CVS Pharmacy,USA. Developed ETL Datawarehouseto support reporting requirements of both business lines of CVS - Pharmacy and Retail. Key Skills:Informatica PowerCenter, Oracle DB, Teradata , Unix Shell scripting ,Pro*C , Oracle PerformanceTunning, CTL-M Scheduling

    • Genpact Headstrong Capital Markets

      Feb 2011 - Apr 2013
      Business Intelligence Developer

      Senior ETL and Business Intelligence BI Developer for Morgan Stanley,USA. Developed corporateDatawarehouse and corresponding reporting requirements for Morgan Stanley. Key Skills: InformaticaPowerCenter, IBM DB2, SAP Business Objects, Qlik View, Unix Shell Scripting

    • Tata Consultancy Services

      May 2013 - now

      Data warehousing, Informatica Power center, Oracle ,SQL,PL SQL,Unix, Solution Design Technical Lead and Designer for on Prem and Cloud based Data warehousing and BI Reporting forUK's Leading Building Society . ETL Tools: SAP BODS ( Business Objects Data Services), DataBase:Oracle SQL/PL-SQL, Performance Tunning, Versioning: Perforce , Cloud : AWS, Scripting : Unix ShellScripting, Python, Reporting: SAP Business Objects, Crystal Reports Lead Design and Solutions for Merger of Building Societies in UK. Implemented MI/BI ( BusinessIntelligence) Solution for new Commercial Lending business for a Leading building society in UK. KeySkills: Design Thinking, SAP Business Objects Data Services, Oracle SQL/PL SQL, PerformanceTunning,SAP Business Objects, Tivoli Scheduling Technical Lead and Senior Developer for complex implementation of Datawarehouse and analyticsplatform for Royal Bank of Scotland (RBS) ,UK. This Datawarehouse is used to meet both Regulatoryand Operational Reporting Requirements using OBIEE. Key Skills: Informatica PowerCenter, Unix ShellScripting, Oracle- SQL/PL SQL, Performance Tunning

      • Data Tech Lead

        Sept 2023 - now
      • Data Tech Lead and Designer

        Aug 2019 - Jun 2024
      • Solutions Designer - DataWarehouse ( MI/BI)

        Oct 2017 - Jul 2019
      • Informatica Data Warehouse Tech Lead

        May 2013 - Sept 2017
  • Licenses & Certifications