Priyanka - Senior ETL Developer

Priyanka

Senior ETL Developer

India | Asia/Kolkata (USD)

$19/hr
Part-time:10-30 hrs/week
0, Followers

ABOUT ME

I possess over 7 years of experience in ETL projects which resulted in data warehousing, analytical and reporting component and capabilities.
I have got expertise in building DWH and Analytics applications. I have built and supported Enterprise Data Warehouses applications for USA, EU and SA clients.
I have got sound experience on Informatica power center , Teradata SQL, Oracle SQL, MS SQL, Unix, dimensional modelling.
I am currently handling data in-out of Hive and HDFS. I also have experience in hadoop, apache sqoop, JIRA, HP ALM, Tivoli Workload scheduler, Autosys.
I have worked into data integration as well as data migration projects extracting data from various types of sources viz text files, relational sources, application sources, HDFS/hive tables.
Worked on performance improvement of informatica codes and tuning SQL queries. I am proficient in writing complex SQL queries and well versed in root cause analysis of issues.
I have supported he product releases and worked in Production support. I am good at analysing complex issues and fixing the same.
I have worked in waterfall SDLC model projects and Agile methodology projects. Have played significant role in sprint planning and scrum meetings.
I am experienced in performing unit/integration/regression/user acceptance testing.
I am also Teradata 14 certified database professional (TE141).
I have handled projects in banking & financial sector, healthcare insurance and pharmaceutical domain.
Entire experience includes balanced mix of responsibilities containing strong technical background as well as excellent analytical ability and communication skills.

SKILLS

EMPLOYMENT HISTORY OUTSIDE OF TOOGIT

Senior systems engineer

Infosys Technologies - Mar, 2011 to Feb, 2014, India

Associate technical consultant

Teradata India Private Limited - Mar, 2014 to Nov, 2015, India

Consultant

Deloitte Consulting India Pvt Ltd - Nov, 2015 to Jun, 2017, India

Senior Software Engineer

Larsen and Toubro Infotech Ltd - Jun, 2017 to present, India

EDUCATION HISTORY

BE, Electronics and Telecommunication

(2006 - 2010) Pune University
Data Quality Reporting DataMart - Data Extraction / ETL One of the prominent Bank in US wanted to build data mart hosting the data of quality checks performed on banking applications. My role was to extract the data from disparate data sources such as oracle, teradata, mainframe and SAS systems and build Informatica mappings to do quality checks and run profiling algorithms on the same. Later loading these results into Data mart hosted in Oracle. I developed reusable codes to perform calculations. I created mapplets for this and it saved lot of development efforts
Consolidated warehouse in Teradata -Client wanted to build enterprise data warehouse enabling the business to offer the full range of services to the entire user base. My role was to fetch the new services' data from flat files and other relational sources and load it to EDW. I built the informatica ETL mappings/workflows that handled millions of records. I used the pushdown optimisation as well as TPT API in Informatica to boost the performance. I was able to achieve tremendous performance improvement where jobs loaded over 45 millions of records in just 4 minutes.