Data Manager

Sr ETL/Informatica Developer

Dear Hiring manager

I am PRAHARSHIN Having Around 8+ years of Experince In Extensive experience in using ETL methodologies for

supporting Data Extraction, Data Migration, Data Transformation and developing Master Data using Informatica PowerCenter, Teradata

Excellent Knowledge on Slowly Changing Dimensions (SCD Type1, SCD Type 2, SCD Type 3), Change Data Capture, Dimensional Data Modelling, Ralph Kimball Approach, Star/Snowflake Modelling, Data Marts, OLAP and FACT and Dimensions tables, Physical and Logical data modelling . Involved in the Analysis, Design, Development, Testing and Implementation of business application systems for Health care, Pharmaceutical, Financial, Telecom and Manufacturing Sectors. Strong understanding of OLAP and OLTP Concepts. Excellent in designing ETL procedures and strategies to extract data from different heterogeneous source systems like oracle 11g/10g, SQL Server 2008/2005, DB2 10, Flat files, XML, SAP R/3 etc.

Experience in SQL, PL/SQL and UNIX shell scripting. Hands on experience working in LINUX, UNIX and Windows environments. Excellent Verbal and Written Communication Skills. Have proven to be highly effective in interfacing across business and technical groups. Good knowledge on data quality measurement using IDE.

Extensive ETL experience using Informatica PowerCenter (Designer, Workflow Manager, Workflow Monitor and Server Manager) Teradata and Business Objects. Strong experience in Dimensional Modelling using Star and Snowflake Schema, Identifying Facts and Dimensions, Physical and logical data modelling using Erwin and ER-Studio.

Experience in designing and Developing complex Mappings using Informatica PowerCenter with Transformations such as Lookup, Filter, Expression, Router, Joiner, Update Strategy, Aggregator, XML generator, XML parser, Stored Procedure, Sorter and Sequence Generator. Working experience using Informatica Workflow Manager to create Sessions, Batches, and schedule workflows and Worklets, Re-usable Tasks, Monitoring Sessions.

Experienced in Performance tuning of Informatica and tuning the SQL queries.

Hands-on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration, and user acceptance testing. Experience in handling initial/full and incremental loads Expertise in scheduling workflows Windows scheduler, Unix, and scheduling tools like CRTL-M &Autosys Designed, Installed, Configured core Informatica components such as Informatica Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter, IDD & Data Modelling.

Experience in support and knowledge transfer to the production team. Worked with Business Managers, Analysts, Development, and end users to correlate Business Logic and Specifications for ETL Development .Experienced in Quality Assurance, Manual and Automated Testing Procedures with active involvement in Database/ Session/ Mapping Level Performance Tuning and Debugging.

Technical Skills

Operating Systems

Unix, Linux, and Windows.

Programming and Scripting

C, C++, Java, .Net, Perl Scripting, Shell Scripting, VBA, PL/SQL, T-SQL.

ETL Tools

Informatica PowerCenter 10.2.0/10.1.1/9.5/9.1/8.6/8.1/7.1, Informatica Power Exchange, Metadata Manager, Informatica Data Quality (IDQ), Informatica Data Explorer (IDE), SSIS, Salesforce, DataStage, etc.

Database Tools

SQL Server Management Studio (2008), Oracle SQL Developer (3.0), Toad 11.6 (Oracle), Teradata, AQT v10 (Advanced query tool) (Oracle/Netezza), DB Artisan 9.0 (Sybase), SQL Browser (Oracle Sybase), Visio, ERWIN

Scheduling Tools

Informatica Scheduler, CA Scheduler (Autosys), ESP, Maestro, Control-M.

Conversation/Transformation Tools

Informatica Data Transformation, Oxygen XML Editor (ver.9, ver.10)

Software Development Methodology

Agile, Waterfall

Domain Expertise

Insurance/Finance

RDBMS

SQL, SQL*Plus, SQL*Loader, Oracle11g/10g/9i/8i, Teradata, IBM DB2, UDB 8.1/7.0, Sybase 12.5, Netezza v9, MS SQL Server 2000/2005/2008, MS Access 7.0/2000.

Thanks’& Regards

PRAHARSHIN. D

Email : ******.*@******************.*** Contact no: 469-***-****

Contact this candidate