Etl Resume
2.00/5 (Submit Your Rating)
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.