Profile
• 9+ years industrial experience in Healthcare, Sales and Supply chain domains.
• 7+ years of experience in Development, Enhancement, Application/Production support in Business Intelligence (BI) with tools such as Informatica 9x.
• Hands on experience in designing and developing the ETL objects using Informatica Power Center with business understanding and knowledge of Extraction, Transformation Load (ETL) of data from heterogeneous source systems like Flat files, Excel, XML, Oracle, Teradata, SQL Server.
• Experience in ETL, Data warehousing using Informatica PowerCenter 8.x/9.0.1,9.5, 9.6 Designer tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Workflow Manager and Workflow Monitor, Repository Manager.
• Working experience on transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, Update Strategy, Transaction Control, Sequence Generator, Rank and Stored Procedure transformations.
• Secondary skills Oracle 11G/XE, Teradata, SQL Server, SQL, PL/SQL, Unix shell scripting.
• Possesses good understanding in Business Intelligence (BI), Data warehousing concepts/methodologies.
• Good experience in handling huge volumes of data (terabytes) and good at analyzing the data related issues.
• Hands on experience on SQL and PL SQL concepts.
• Implemented UNIX shell scripts for scheduling various tasks.
• Good knowledge on Big Data Ecosystems: Hadoop, MapReduce, Hive, Pig, Sqoop, Cassandra.
• Excellent analytical, problem solving, logical and interpersonal skills with a good understanding at the conceptual level.
• Ability to interact with client/business users and can work as a part of a team/individual.