SUMMARY

• 7 years of experience in ETL methodology for data transformation using Informatica Power Center 9.x/8.x.
• I have experience in Data Warehousing teamed with Business Requirements Analysis, Data Modeling, Development, Testing and Documentation.
• Hands on experience in all aspects of Software Development Life Cycle (SDLC).
• I have experience in designing and developing ETL solutions using Informatica Power Center and performing Extract Transform and Load process.
• Energetic, composed, motivated ETL developer with a passion for innovation, learning and technology.
• Varied experience in Designing and developing the complex mappings by using various Transformations like Source Qualifier, Joiners, Aggregator, Routers, Filters, Expressions, Lookups, Sequence Generators, Update Strategy etc.
• Experience in Performance tuning of targets, sources, mappings and sessions.
• Experienced in writing SQL queries and SQL stored procedures, understanding requirements, writing functional specs, writing test specs and plans.
• Experience in Extraction, Transformation and Loading of data from different heterogeneous source systems like Flat files (Fixed width & Delimited), XML Files, IBM DB2, Excel, Oracle, Sybase, MS SQL Server and Teradata.
• Good knowledge in documentation and test plans, unit testing.
• Good understanding of Star and Snowflake Schema, Dimensional Modeling, Relational Data Modeling, Slowly Changing Dimensions and data ware housing concepts.
• Experience in creating Sessions and Workflows by using the Workflow Manager tools like Task Developer, Worklet and Workflow Designer.
• Experience in Scheduling the Scripts using Autosys Scheduler.
• Developed Low Level Design at mapping level Architecture as per Business requirement.
• Good Knowledge of DW & DB concepts, Logical/ Physical Dimensional Models.
• Self - motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements. Excellent communication skills, management and leadership qualities.
• Good knowledge in interacting with Informatica Data Explorer (IDE), and Informatica Data Quality (IDQ).
• Knowledge in designing Dimensional models for Landing, Cleansing and Staging areas
• Used Informatica Power Center for migrating data from various OLTP databases to the data mart.
• Expertise in OLTP/OLAP System Study, Analysis and E-R modeling, developing Database Schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Good understandings of OLTP and OLAP data structures.
• Experience in Oracle 11g/10g/9i, SQL Server, PL/SQL, SQL Developer, TOAD, Stored Procedures, Triggers.

TECHNICAL SKILLS

ETL tools: Informatica Power Center 8x/9x, (Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformation Developer, Work flow Manager, Workflow Monitor)

Database: Oracle 11g/10g/9i/8i, SQL Server, MS Access

Working Knowledge: C, C++, Java, JavaScript, Mat lab, HTML

Outstanding Knowledge: SQL, UNIX, PL/SQL

Modeling Tools: Rational Rose, Toad, SQL Developer

Operating Systems: Windows 98/2000/XP/NT, DOS, UNIX

PROFESSIONAL EXPERIENCE

Confidential, Dunedin, FL

Sr. Informatica developer

Responsibilities:

• Worked with business owners, analysts, solution engineers, development teams and infrastructure services to communicate application and data architectures.
• Actively Involved with System analysts and business in creating Software Design Specification (SDS).
• Identified necessary elements according to the business requirements and created a Road map and Technical specification document (TSD).
• Produce detail design document, low level design document and involved in code/document review.
• Participated in the maintenance and enhancement of the application and perform bug fixing.
• Designed and developed ETL mappings to load, transform data from source to Target using Informatica Power Center 9.5.1.
• Worked with Power Center Designer tools in developing mappings and mapplets to extract and load the data from various sources.
• Developed various Informatica mappings using various transformations like Sorter transformation, expression, source qualifier, lookups, Aggregator transformation, Normalizer Transformation and Joiner transformation.
• Created mappings using Informatica Designer to build business rules to load data and tuned them to enhance the performance.
• Extensively used ETL to Extract and Load data from Oracle, Flat Files.
• Tested all the business application rules with test & live data and automated, monitored the sessions using Work Flow Manager and Workflow Monitor.
• Performed Unit Testing and Involved in tuning Session and Workflows for better Performance.
• Created UNIX scripts to dynamically create data interface files and SFTP files to target Axway servers.
• Created UNIX scripts to Archive and purge Data Files and log files.
• Scheduled Informatica jobs using Control-M Scheduler and generate e-mail to notify Success/Failure to the support Team.
• Created Production Install Plan and involved in Production support.

Environment: Informatica-Power Center 9.5.1, (Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Workflow Manager, Workflow monitor, Repository Manager), Oracle 11g, SQL Developer 3.2, SQL Server 2012, SQL Server Management Studio, UNIX, Flat files, Windows.

Confidential, Providence, RI

Sr. Informatica developer

Responsibilities:

• Involved in business requirement gathering, which includes conducting Workshop sessions and translating the business inputs from workshop sessions into ETL design/technical documents.
• Involved in End to End Data flow design in ETL Informatica mappings.
• Extensively worked on Informatica Designer, Work Flow Manager, Work Flow Monitor and Repository Manager.
• Created several complex Informatica mappings, Mapplets depending on client requirements. Extensively worked on Connected & Unconnected Lookups, Router, Expression, Source Qualifier, Aggregator, Filter, and Sequence Generator.
• Developed SQL Scripts and PL/SQL Scripts to extract data from different sources.
• Performed Data cleansing, standardizing incorrect data formats, misspellings, redundant, missing data values and performed de-duplication of customer data.
• Involved in the optimization of SQL queries which resulted in substantial performance improvement for the conversion processes.
• To get optimal performance, used parameter files and mapping parameter, Variables in mappings and session variables in workflows.
• Reading the data from the FACETS and HpXr data model then written ETL Functional Design documents and ETL technical Specification documents for program development, logic, coding, changes and corrections.
• Used Workflow Manager to schedule and run batches, sessions, as well as to check session logs and other session related activities.
• Responsible for Error handling, bug fixing, Session monitoring and log analysis.
• Involved in unit testing, UAT testing and integrated testing of entire process flow.

Environment: Informatica- Informatica-Power Center 9.5.1, (Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer, Transformations Developer, Workflow Manager, Workflow monitor, Repository Manager), Oracle 11g, Toad, Flat Files, Java, Net beans, Facets, Autosys.