View Bench List Portal

Similar candidates

• No Matching Candidates Found

•Over 8 years of IT experience in the Analysis, Architecture, Design, Development, Testing and Implementation of Database Applications, Business Intelligence solutions using Data Warehousing & ETL tools.

•Excellent knowledge of Software Development Life Cycle (SDLC) with industry standard methodologies like Waterfall and Agile including Requirement analysis, Design, Development, Testing, Support and Implementation.

•Expertise and hands on experience in RDBMS, Data Warehouse Architecture, Inmon and Ralph Kimball Technologies and thorough understanding and experience in data warehouse and data mart design. 

•Good understanding of Data Models (Dimensional & Transactional), Conceptual/Logical & Physical Data Models, DWH Concepts, ER diagrams, Data Flow Diagrams/Process Diagrams.

•Knowledge in designing and developing Data marts, Data warehouse using multi-dimensional Models such as Snow Flake Schema and Star Schema using Facts & Dimension tables.

•Expertise  in development and design of ETL methodology for supporting data transformations and processing, in a corporate wide ETL Solution using Informatica Power Center 9.5/9.1/8.6/8.5/8.1.1/7.1.3/7.1.1/7.0 and Power Exchange (Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Transformation developer).

•Experienced in creation of reusable objects Mapplets & Transformations using Mapplet Designer and Transformation Developer.

•Experience in Performance Tuning of Sources, Targets, mappings and using Push Down Optimization, different Session Partitioning techniques like Round robin, Hash-Key,Range & Pass Through. 

•Experience in implementation of the Informatica Web Services Hub setup and event based (SOAP request/response) triggering of workflows imported through WSDL

•Business Intelligence experience using Cognos, and Working knowledge of Business Objects XI R2.

•Experience in setting up Workflows for Concurrent execution.

•Experience in UNIX Shell scripting for high volume data warehouse instances.

•Proficiently rendered services on Oracle 11g/10g/9i/8i, Teradata, Netezza, SQL Server, DB2,SQL, PL/SQL

•Experience in Netezza Extract Load and Transformation mechanism by taking data from various sources and loading it into Netezza DB using NZ_SQL and NZ_LOAD utilities.

•Expertized in Netezza queries by performance tuning and techniques such as CBT, Collocation and collocated join.

•Expertise in utilizing Oracle utility toolSQL Developer and expertise in Toad for developing Oracle applications.

•Involved in setting up the standards for Architecture, design and development of database applications

•Expertise in Database development skills using SQL, PL/SQL, T-SQL, Stored Procedures, Functions, Views, Triggers and complex SQL queries. Proficient using TOAD, SQL Developer for system testing of the reports.

•Experinced  working with Job schedulers Autosys,WLM,Maestro and version tools Clear Case & SVN 

•Trained and working knowledge on Datastage.

•Used Informatica B2B to extract data from unstructured source files and PowerExchange to extract real time data.

•Designed Mappings using B2B Data Transformation Studio with the help of UDT (Unstructured Data Transformation).

•The process developed, takes input requirements from Excel File and outputs multiple data feed files at multiple schedules, file names, with/without control files, as specified.

•Worked on POC to implement Hadoop with Cloudera & Hortonworks technology.

•Worked with business SMEs on developing the business rules for cleansing. Applied business rules using Informatica Data Quality (IDQ) tool to cleanse data.

•Presented Data Cleansing Results and IDQ plans results to the OpCos SMEs.

•Worked with Informatica and other consultants to develop IDQ plans to identify possible data issues.

•Documented Cleansing Rules discovered from data cleansing and profiling.

•Expertise in Oracle BI Server, Oracle BI Answers, BI Interactive Dashboards and Oracle BI Publisher.

•Experience in developing OBIEE Repository (.rpd) at three layers (Physical Layer, Business Model and Mapping Layer &Presentation Layer), Time Series Objects, configuring metadata, Answers, Delivers / Interactive Dashboards / Reports with drill-down and drill-across capabilities using global & local Filters, Security Setup (Groups and Access Privileges), Web Catalog Objects and scheduling iBots.

•Worked in 24/7 production support of ETL and BI applications for large Life Sciences & Healthcare Data warehouses for monitoring, troubleshooting, resolving issues. 

•Worked with Informatica Server and Client tools, experience in the Data Analysis, Design, Development, Implementation, Production Support of Database, Data warehousing, Legacy applications for industries using Data Modeling, Data Extraction, Data Transformation and Data Loading.

•Post-Production support to monitor jobs in new environment.

•Responsible for working closely with the Informatica administrator to migrate Source and Target definitions, Mappings, Workflows, and Flat Files from development environment to the Production environment.

•Associated with Production Support team in various performances related issues.

•Experience reviewing Test plans, Test cases and Test case execution. Understanding business requirement documents and functional specs and then writing test cases using Quality Center. Also played an active role in User Acceptance Testing (UAT) and unit, system & integration testing.

•Involved in writing Unit Test cases (UTC) and Integration Test cases for Informatica development

•Used breakpoints and various Test conditions with Debugger tool to test the logic and the validity of the data moving through the mappings. 

•Highly motivated team player with ability to lead, manage and work in all environments to meet deadlines. 

•Quick Learner with strong problem solving skills and excellent in communication, presentation and interpersonal