We provide IT Staff Augmentation Services!

Etl Resume

Summary

  • Over 7 years of IT experience in Design, Develop, Test and Maintain ETL methodology for supporting data transformations and processing. Design Testing Methodologies and Quality Assurance for testing Warehouse applications built in a corporate wide ETL Solution using InformaticaPower Center 9.1/8.6 and earlier versions.
  • Proficient in all phases of the Software development lifecycle (SDLC).
  • Extensive experience in Finance, Telecommunication, Retail and Healthcare Industries.
  • Sound Knowledge on ERP and Data warehousing Technologies. Advanced knowledge in ETL and Data warehousing with OLAP technology.
  • Expertise in Extraction/Transformation/Loading of the legacy data to Data Mart/Data Warehouse from various sources such as Flat file, VSAM files, Relational tables, XML, etc. using ETL Tool Informatica.
  • Proficient in gathering business requirements, establishing functional specifications and translating them to design specifications.
  • Good understanding of both dimensional and relational modeling concepts like Star-Schema Modeling, Snow Flaking, ER modeling at logical, physical and logical levels.
  • Implemented all types of Slowly Changing Dimensions.
  • Experience in basic Informaticaadministration like creating folder, users, assigning privileges, configuring the server settings for optimal performance, etc.
  • Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels such as sources, targets, mapping, sessions, SQL and database.
  • Experienced in Installation, Configuration, and Administration of Informatica Power Center Client/Server.
  • Experience in UNIX working environment, writing UNIX scripts for data modification, data validation, etc.
  • Used various database client tools like TOAD, SQL developer, SQLserver management studio, etc. To access/create/change database objects and create scripts.
  • Knowledge of a automation and scheduling of Informatica jobs using Tidal,CRONTAB and Autosys, etc.
  • Excellent communication and interpersonal skills. Ability to work effectively working as a team member as well as an individual.
  • Having Strong QlikView Dashboard implementationand integration experience.

Hire Now