Sanjana B.

Sanjana B.

Teradata/Informatica Developer

Bengaluru , India

Experience: 8 Years

Sanjana

Bengaluru , India

Teradata/Informatica Developer

17142.8 USD / Year

  • Start Date / Notice Period end date: 2020-01-27

8 Years

Now you can Instantly Chat with Sanjana!

About Me

8+ years of extensive experience in Data Integration, Data Migration, Data management ,Data Profiling and Data Cleansing using Teradata and Informatica . Have experience in working with Retail, Healthcare and Banking Domain. Working experience on...

Strong consulting professional with a Bachelor of Engineering (BE) focused in Electronics and Communications Engineering from Sathyabama Institute of Science and Technology

Show More

Portfolio Projects

LIDL(on behalf of Teradata corporation)

Company

LIDL(on behalf of Teradata corporation)

Description

Sr. Teradata Developer ---Teradata (Lidl-Germany) 01/2017-10/2018

Task:

  • Created various fast performing set and Multiset table which was being used directly by reporting tools.
  • Created various views on complex table for faster performance. Experience in creating join Index and Materialized view.
  • Developed various SQL scripts using complex join and sub queries. Extensively worked on performance tuning using Explain, Collect Stats, Compression,NUSI and join Index.
  • Extensively used various Teradata features as TPT, NUPI ,UPI, No PI.tera

Show More Show Less

Deloitte Consulting

Company

Deloitte Consulting

Description

Consultant ---Deloitte Consulting (Bangalore India) 08/2013 – 11/2016

Task:

  • Worked in Healthcare domain for client (Anthem).
  • Involved in gathering business requirements, logical modeling, physical database design, data sourcing, data transformation, data loading and SQL performance tuning.
  •  Designed and developed a number of complex mappings using various transformations like Source Qualifier, Aggregators, lookups, Filters, Sequence generators, Routers, Update Strategy, Expression, Sorter, Normalizer etc.
  • Created reusable session, workflow, worklet, event wait and Raise, Email Task.
  • Extensively used Mapping variables, Mapping parameters and Dynamic parameter Files for improved performance and flexibility.
  • Experienced with identifying performance bottlenecks and fixing code for optimization.
  •  Involved in creating Unit test plan and testing the data for various applications. Used UNIX scripts to automate several ETL processes. and to handle deferent file processing.
  • Lead small team of 5 and delivered all the solution on time.

Show More Show Less

Wipro Technology

Company

Wipro Technology

Description

Project Eng.—Wipro Technology (Bangalore India) 08/2010 – 08/2013

Task:

  • Worked in Banking and Financial domain for client Lloyds bank.
  • Designed and developed various Teradata BTEQ scripts.
  •  Documentation of end product for customer assistance.
  •  Performed Unit Testing & supported UAT(user Acceptance Testing) .

Show More Show Less

Skills

Teradata

LIDL Germany

Company

LIDL Germany

Description

Sr. Teradata Developer ---Teradata (Lidl-Germany) 01/2017-10/2018

Task:

  • Created various fast performing set and Multiset table which was being used directly by reporting tools.
  • Created various views on complex table for faster performance. Experience in creating join Index and Materialized view.
  • Developed various SQL scripts using complex join and sub queries. Extensively worked on performance tuning using Explain, Collect Stats, Compression,NUSI and join Index.

Extensively used various Teradata features as TPT, NUPI ,UPI, No PI.

Show More Show Less
Share: