Keywords
Skills
- A highly dedicated professional with 6.2 years of Experience in Data warehouse implementation using ETL Tools.
- Very good understanding of Data Warehousing concepts & Dimensional Modeling such as Star/Snow Flake Schemas.
- Well understanding of preparing the inputs for ETL high level and low level design documents.
- Excellent experience in Design & Implementation of ETL processes, Transformation, mappings and loading data from various sources like Oracle, Teradata and Flat files using Informatica Power center 9.x.
- Exposure to all kinds of transformations such as Source qualifier, Update strategy, joiner, lookup, Filter and Sequence generator, Union, Router.
- Experienced at performance tuning in ETL and SQL query level in Oracle.
- Exposure to Talend, Used the most of the components like tMAP, tOracleInput, tHDFSInput, tHiveLoad, tRun, tJava, tHDFSOutput and Context group.
- Well versed in developing the complex SQL queries, unions and multiple table joins and experience with Views.
- Good exposure of SQL, PL/SQL (Stored Procedures, Functions, Package, Cursors, Query optimization, Complex queries, External tables etc.) on Oracle database.
- Well understanding of writing Unix scripting to perform various operation.
- Experienced at creating effective test data and development thorough Unit test cases to ensure successful execution of the data & used page for notifying the alerts after successful completion.
- Good communication and Interpersonal Skills & always curious to learn new technologies.
Project history
Previous Employer : Capgemini
Client Cox Communication
Role ETL Designer & Developer
Work LocationBangalore
Duration April 2013 to June 2018
Client Cox Communication
Role ETL Designer & Developer
Work LocationBangalore
Duration April 2013 to June 2018
Local Availability
Only available in these countries:
India