Summary:

• Seven and half years of total IT experience in Software Development Life Cycle SDLC with strong background in Database Development and ETL Data Warehousing using Informatica Power Center 9.1,8.6.1, 8.6, 8.1, 7.1, 6.2.
• Extensive experience with Data Extraction, Transformation, and Loading ETL from Multiple Sources. Worked on data integration from various source files such as flat files, CSV files, Relational Databases etc. into a common analytical Data Model.
• Extensive working experience in Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Extraction, Data Transformation and Data Loading ETL methodologies.
• Extensively worked on development of complex mappings using various transformations like Expression, Connected/Unconnected Lookup, Filter, Router, Joiner, Union, Aggregator, Update Strategy, SQLT, Transaction control etc.
• Worked on Stored Procedure concept to truncate tables and delete rows from error logs.
• Expertise in using various Informatica Designer Tools such as Source Analyzer, Transformation Developer, Mapping Designer, Mapplet Designer, Workflow Manager and Workflow Monitor.
• Strong understanding of RDBMS and proficient in writing PL/SQL Procedures.
• Expertise in OLTP/OLAP System Study, Analysis and database schemas like Star Schema and Snowflake Schema used in relational, dimensional and multidimensional modeling.
• Extensively worked on Performance Tuning techniques at various levels to increase the performance and minimize the time for work.
• Experience in integration of various data sources like Oracle, SQL server and sequential files into staging area.
• Conducted System, UAT and Functionality testing and investigated software bugs.
• Experience in UNIX Shell Scripting.
• Two years of experience in Informatica Power Exchange.
• Worked with Oracle and SQL Server Stored Procedures, Triggers, Cursors and Indexes and experienced in loading data into Data Warehouse/Data Marts.
• Strong business analysis skills to find business problem, process, management and possesses.
• Ability to work individually as well as Team.
• Excellent communication and interpersonal skills. Good team player with excellent analytical and presentation skills with strong aptitude towards learning new technologies.

Technical Skill:

• ETL Tool: Informatica Power Center 9.1/8.x/7.x/6.x, Power Exchange 8.6
• Data Modeling: ERwin r7.3/4.0/3.5, Star schema Modeling, Snow Flake modeling.
• Languages: PL/SQL, SQL Plus, C, C , SQL.
• Databases: Oracle 11g/10g/9i/8i, MS SQL Server 7.0/2000, DB2, Teradata 12.
• OLAP Tools: BusinessObjectsXIR2, OBIEE.
• SQL Tools: SQL Developer, TOAD, SQL PLUS, SQL Loader, CDC.
• Office Tools: MSOffice, MS Project, Auto CAD.
• Other Tools: SAS, Proficient in Reinsurance System TAI, LynchVal Defined Benefit Valuation Software , ESP, Tivoli.
• O/S: Windows 95/ 98/NT/2000, XP, UNIX, Sun Solaris, Linux, AIX

Professional Experience:

Confidential

Sr. ETL Developer/ Data Analyst

Responsibilities:

• Involved during gathering information from the Hospitals, Laboratory, Employers and Doctors from different departments.
• Worked with analysts, using work sessions, to translating business requirements into technical user specifications, including data, process and interface specifications.
• Involved during the Source to Target Design documents, Technical Design documents.
• Followed carefully the International Classification of Diseases while designing the Diagnosis Dimension.
• Developed Logical and physical Data model using Erwin.
• Developed the methods and procedures for data warehouse staff.
• Developed mappings Mapplets to load data from various sources using standard ETL transformations to store the data in the staging area and target tables
• Developed Reusable Transformations, and Reusable Mapplets.
• Created Power Exchange Registration for CDC on oracle tables.
• Involved in discussion of late arrival records. Used surrogate key whenever the business need to make it easier access to Data Warehouse.
• Involved during the design of granularity of the fact and dimension table.
• Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
• Created and reviewed Test case, Migration doc and release plan doc.
• Coordinated SIT, UAT and Prod release.

Environment: Informatica Power Center 9.1, Power Exchange 9.0, SQL Server 2008, UNIX, Toad, Erwin, Oracle 11g, Linux, Windows XP.

Confidential

ETL Informatica Developer

Responsibilities:

• Requirement gathering and Business Analysis.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Develop logical and physical data models that capture current state/future state data elements and data flows using Erwin.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database.
• Defined various facts and Dimensions in the data mart including Fact less Facts, Aggregate and Summary facts.
• Reviewed source systems and proposed data acquisition strategy.
• Designed and Customized data models for Data Mart supporting data from multiple sources on real time.
• Designed the Data Mart defining Entities, Attributes and relationships between them.
• Extensively used Erwin tool in Forward and reverse engineering, following the Corporate Standards in Naming Conventions, using Conformed dimensions whenever possible.
• Designed and developed Informatica Mappings to load data from Source systems to ODS and then to Data Mart.
• Extensively used PowerCenter to design multiple mappings with embedded business logic.
• Created database objects like Stored procedures, function, packages and triggers.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations, Mapplet for populating target table in efficient manner.
• Created restart token configured workflows and sessions for real time Informatica objects.
• Created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.

Environment: Informatica PowerCenter 8.1, Informatica Exchange 8.1, Oracle 10g/9i, SQL Server 2000, PL/SQL, DB2, Erwin, TOAD, SQL Plus, SQL Loader, Windows, UNIX.

Confidential

ETL Developer

Responsibilities:

• Understand the business needs and implement the same into a functional database design.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• End-to-end ETL development of the Premium Module Data Mart.
• Responsible for the Dimensional Data Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Parsing high-level design spec to simple ETL coding and mapping standards.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping Mapplet Designer and Transformation Designer.
• Maintain Development, Test and Production mapping migration Using Repository Manager, also used Repository Manager to maintain the metadata, Security and Reporting.
• Worked on Informatica utilities like pmcmd, pmrep to start, stop and get status of workflows.
• Designed and developed UNIX scripts for ESP Scheduler to scheduling the jobs.
• Data Quality Analysis to determine cleansing requirements.
• Extensively used Erwin for data modeling and Dimensional Data Modeling.
• Extracted data from various departments to flat files and load the data to the target database.
• Tuning Informatica Mappings and Sessions for optimum performance.
• Created and maintained several custom reports for the client using Business Objects.
• Generated reports using BO tools querying database.
• Created List Reports and Cross Tab Reports and Drill Through reports.
• Created standard and Ad hoc reports using Business Objects.

Environment: Informatica PowerCenter 7.2, Teradata V2R5, Business Objects XI/6.5, Erwin 3.5, PL/SQL, Oracle 10g, DB2, Windows 2000, HP-UX, AIX 4.3.3, Shell Scripting.

Confidential

ETL Developer

Responsibilities:

• Developed and maintained complex Informatica mappings.
• Perform data validation tests using complex SQL statements.
• Function as backup on-call programmer for nightly ETL load.
• Analyzed, designed, created and manipulated MS Access and Oracle 9i tables.
• Researched manual and automated systems, developed recommendations and prepared documentation. The recommendations identified unnecessary steps.
• Worked with data warehouse staff to incorporate best practices from Informatica.
• Developed implementation plans and schedules for Informatica enhancements.
• Developed reports based on issues related to the data warehouse.
• Worked with finance staff to document their business rules, data needs and requirements in order to create data warehouse systems.
• Assessing and documenting existing business processes and identifying where improvements can be made or where new processes can be installed.
• Developed data marts using sources such as: agency's HRM data, personnel files and payroll and financial files.

Environment: Power Center 6.2/7.1, Oracle 9i, Flat files, XML, PL/SQL, Windows XP, UNIX, Toad.