View Bench List Portal

Similar candidates

• No Matching Candidates Found

Having 9.5 years of IT consulting experience in development, testing, analysis, and design implementation of applications using data warehousing ETL tools and Web based tools. Hands on experience in Data Warehouse ETL experience Informatica Power Center, Informatica IDQ, AbInitio Co>OS 2.15.1, GDE 1.15.7 and SSIS and having knowledge on IBM Data Stage and SAS in Banking & Finance, Securities, Manufacturing and Telecommunication Sectors.

ü  Nine years of IT experiences in the Analysis, Design, Development, Testing and Implementation of Data Warehouse applications with in-depth knowledge using Informatica Power Center, Abinitio, SSIS and Informatica Data Quality Tool.

ü  Strong experience in the analysis, design, development, testing and implementation of Business Intelligence solutions using Data Warehouse

ü  Strong Data Warehousing ETL experience of using Informatica 9.6/8.6.1/8.5/8.1/7.1 PowerCenter Client tools - Mapping Designer, Repository Manager, Workflow Manager/Monitor and Server tools – Informatica Server, Repository Server Manager.

ü  Strong Data Management ETL experience of using AbInitio Co>OS 2.15.1, GDE 1.15.7

ü  Expertise in Data Warehouse/Data Mart, ODS, OLTP and OLAP implementations teamed with project scope, analysis, requirements gathering, data modeling, effort estimation, ETL design, development, system testing, implementation and production support.

ü  Extensive testing ETL experience using Informatica IDQ Tool for developing Data Quality techniques and standardization of Data.

ü  Used transformations like Address Validator, Parser, Key Generator, Joiner, Expression, Connected and Unconnected Lookups, Filter, Aggregator, Stored Procedure, Rank, Update Strategy, Router and Sequence generator.

ü  Strong experience in Dimensional Modeling using Star and Snowflake Schema, Identifying Facts and Dimensions, Physical and Logical data modeling.

ü  Expertise in working with relational databases such as Oracle 11g/10g/9i/8x, SQL Server 2008/2005, and DB2  8.0/7.0.

ü  Extensive experience in developing Stored Procedures, Functions, Views and Triggers, Complex SQL queries using SQL Server and Oracle PL/SQL.

ü  Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.

ü  Experience in all phases of Data Warehouse development from requirements gathering for the Data Warehouse to develop the code, unit testing and documenting.

ü  Extensive experience in writing UNIX shell scripts and Automations of the ETL processes using UNIX shell scripting.

ü  Having good knowledge in Data Profiling techniques using Informatica Analyst Tool.

ü  Experience in using Automation Scheduling tools like Autosys and Control-M.

ü  Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build,  unit testing, system integration and user acceptance testing.

ü  Excellent skills in written, oral and interpersonal communication.