Professional Trainer, Developer, Python, ETL, AWS Redshift, Snowflake, Data warehousing, Informatica powercenter, Pentaho and UNIX Shell scripting
Aktualisiert am 30.10.2020
Profil
Freiberufler / Selbstständiger
Verfügbar ab: 05.10.2020
Verfügbar zu: 100%
davon vor Ort: 100%
Datawarehousing
ETL Process
InformaticaPowerCenter

Einsatzorte

Einsatzorte

Regensburg (+50km)
nicht möglich

Projekte

Projekte

1 Jahr 10 Monate
2017-09 - 2019-06

Logitech engineering and design India private Ltd

Technical Lead
Technical Lead
  • Developed a data insight application to assist enterprise sales and marketing team in decision making.
  • Mentoring and leading a group of data engineers who resolve L3 data issues in Data warehousing application.
  • Involved in Platform migration of ETL application from On-premise to Cloud environment – AWS Redshift and Snowflake
10 Monate
2016-11 - 2017-08

Design efficient data models

AWS Redshift Consultant
AWS Redshift Consultant
  • Freelance trainer on AWS Redshift development and best practices in data loading.
  • Design efficient data models – distribution and sort keys, analyze data skew and periodically tune the Redshift environment
1 Jahr 3 Monate
2015-08 - 2016-10

AstraZeneca India private Ltd

Consultant
Consultant
  • Profile and cleanse Veeva CRM data, defining data quality rules
  • Bulk load activity data from oracle database to AWS Redshift database using SnapLogic Redshift bulk load snap
  • Maintained Redshift database – User creations, fixing long running queries, perform vacuum, performance tuning – table design and query design
2 Jahre 3 Monate
2013-05 - 2015-07

Analyst Apps Prog

  • Defined and developed data quality and data lineage framework for Bank’s Globalization of reporting initiative.
  • Extensively used Informatica PowerCenter, Informatica Data quality and Metadata manager
  • Part of design committee – evaluating Business use cases, involved in Proof of Concepts, Benchmark ETL tools.
Bank of America
6 Monate
2012-11 - 2013-04

NTT Data

Team Lead
Team Lead
  • Leading a team of L3 / L2 support engineers and ensuring Staples data warehouse operations runs smoothly to cater the business intelligence team
  • Performance tune data load pipelines by identifying the bottle necks.
6 Monate
2012-05 - 2012-10

Data quality and administration

Data warehousing Trainer
Data warehousing Trainer
  • Provided training on Data warehousing concepts and ETL best practices.
  • Training session on Informatica PowerCenter, Informatica Data quality and administration
1 Jahr 6 Monate
2010-11 - 2012-04

Associate projects

Cognizant Technology solutions
Cognizant Technology solutions
  • Involved in developing ETL solution for Dun and Bradstreet initiative Max CV – Maximizing customer values
  • Maintained and supported D&B ETL servers
  • Generated and projected weekly reports dashboard using Data analyzer to monitor the data volume flow in D&B applications
2 Jahre 2 Monate
2008-08 - 2010-09

WellPoint and developed

Software Engineer
Software Engineer
  • Worked with renowned client WellPoint and developed an Internet Provider Finder (IPF) application which collects provider details from different sources (mainframe and MS ACCESS) and integrates the provider information by applying the business logic and FTP the provider extracts to web application
UST Global

Aus- und Weiterbildung

Aus- und Weiterbildung

2007  2007

BSA Crescent Engineering college, Anna University
Chennai, India

  • Master of Computer Applications ? 72.5%

2004 - 2004

Poonga College of Arts and Science, University of Madras
Chennai, India

  • Bachelor of Computer Applications - 72%

Kompetenzen

Kompetenzen

Top-Skills

Datawarehousing ETL Process InformaticaPowerCenter

Produkte / Standards / Erfahrungen / Methoden

SUMMARY

  • More than 10 years of experience in developing and implementing data analytic solution across various domains – Healthcare, Banking and Retail.
  • Specialized in designing and delivering ETL solutions, Data management, platform migration and performance tuning.

Tools and Languages

  • Proficient in Advanced SQL, Shell scripting and Python
  • Familiar with PL/SQL, Java and R
  • ETL Tools: Informatica suite, SnapLogic and Pentaho
  • Area of interest: Data analytics using Artificial intelligence

Platforms
AWS, UNIX and Window

Datenbanken

AWS Redshift
Oracle Exadata
Snowflake

Einsatzorte

Einsatzorte

Regensburg (+50km)
nicht möglich

Projekte

Projekte

1 Jahr 10 Monate
2017-09 - 2019-06

Logitech engineering and design India private Ltd

Technical Lead
Technical Lead
  • Developed a data insight application to assist enterprise sales and marketing team in decision making.
  • Mentoring and leading a group of data engineers who resolve L3 data issues in Data warehousing application.
  • Involved in Platform migration of ETL application from On-premise to Cloud environment – AWS Redshift and Snowflake
10 Monate
2016-11 - 2017-08

Design efficient data models

AWS Redshift Consultant
AWS Redshift Consultant
  • Freelance trainer on AWS Redshift development and best practices in data loading.
  • Design efficient data models – distribution and sort keys, analyze data skew and periodically tune the Redshift environment
1 Jahr 3 Monate
2015-08 - 2016-10

AstraZeneca India private Ltd

Consultant
Consultant
  • Profile and cleanse Veeva CRM data, defining data quality rules
  • Bulk load activity data from oracle database to AWS Redshift database using SnapLogic Redshift bulk load snap
  • Maintained Redshift database – User creations, fixing long running queries, perform vacuum, performance tuning – table design and query design
2 Jahre 3 Monate
2013-05 - 2015-07

Analyst Apps Prog

  • Defined and developed data quality and data lineage framework for Bank’s Globalization of reporting initiative.
  • Extensively used Informatica PowerCenter, Informatica Data quality and Metadata manager
  • Part of design committee – evaluating Business use cases, involved in Proof of Concepts, Benchmark ETL tools.
Bank of America
6 Monate
2012-11 - 2013-04

NTT Data

Team Lead
Team Lead
  • Leading a team of L3 / L2 support engineers and ensuring Staples data warehouse operations runs smoothly to cater the business intelligence team
  • Performance tune data load pipelines by identifying the bottle necks.
6 Monate
2012-05 - 2012-10

Data quality and administration

Data warehousing Trainer
Data warehousing Trainer
  • Provided training on Data warehousing concepts and ETL best practices.
  • Training session on Informatica PowerCenter, Informatica Data quality and administration
1 Jahr 6 Monate
2010-11 - 2012-04

Associate projects

Cognizant Technology solutions
Cognizant Technology solutions
  • Involved in developing ETL solution for Dun and Bradstreet initiative Max CV – Maximizing customer values
  • Maintained and supported D&B ETL servers
  • Generated and projected weekly reports dashboard using Data analyzer to monitor the data volume flow in D&B applications
2 Jahre 2 Monate
2008-08 - 2010-09

WellPoint and developed

Software Engineer
Software Engineer
  • Worked with renowned client WellPoint and developed an Internet Provider Finder (IPF) application which collects provider details from different sources (mainframe and MS ACCESS) and integrates the provider information by applying the business logic and FTP the provider extracts to web application
UST Global

Aus- und Weiterbildung

Aus- und Weiterbildung

2007  2007

BSA Crescent Engineering college, Anna University
Chennai, India

  • Master of Computer Applications ? 72.5%

2004 - 2004

Poonga College of Arts and Science, University of Madras
Chennai, India

  • Bachelor of Computer Applications - 72%

Kompetenzen

Kompetenzen

Top-Skills

Datawarehousing ETL Process InformaticaPowerCenter

Produkte / Standards / Erfahrungen / Methoden

SUMMARY

  • More than 10 years of experience in developing and implementing data analytic solution across various domains – Healthcare, Banking and Retail.
  • Specialized in designing and delivering ETL solutions, Data management, platform migration and performance tuning.

Tools and Languages

  • Proficient in Advanced SQL, Shell scripting and Python
  • Familiar with PL/SQL, Java and R
  • ETL Tools: Informatica suite, SnapLogic and Pentaho
  • Area of interest: Data analytics using Artificial intelligence

Platforms
AWS, UNIX and Window

Datenbanken

AWS Redshift
Oracle Exadata
Snowflake

Vertrauen Sie auf GULP

Im Bereich Freelancing
Im Bereich Arbeitnehmerüberlassung / Personalvermittlung

Fragen?

Rufen Sie uns an +49 89 500316-300 oder schreiben Sie uns:

Das GULP Freelancer-Portal

Direktester geht's nicht! Ganz einfach Freelancer finden und direkt Kontakt aufnehmen.