To work in a challenging environment with opportunities for professional growth and excel in work towards the growth of the organization.

Professional Summary:

• 8 years of IT experience in the Requirement Analysis, Data Analysis, Application Design, Application Development, Implementation and Testing of Applications in Data warehousing, OLAP with strong business knowledge of Healthcare, Pharmaceutical, Financial, Insurance, Retail and Telecommunication domains.
• Good working experience in SDLC Software Development Life Cycle methodologies like waterfall, Agile, RUP Rational Unified Process .
• Solid experience in development and design of ETL methodology for supporting data transformations and processing, in a corporate wide ETL Solution using Informatica Power Center/power mart 8.6/8.5/8.1.1/8.0 Workflow Manager, workflow Monitor, Source Analyzer, Data Warehousing Designer, Mapping Designer, Mapplet Designer, Transformation developer , Informatica Power Mart, Power Connect, Power Plug, Power Analyzer, Power Exchange.
• Experience in Data Warehousing design and Data modeling Concepts like Ralph Kimball Methodology, Bill Inmon Methodology, OLTP, OLAP, Star Schema, Snow Flake Schema, Dimension Table, Fact Table, conformed dimensions, Logical Data Modeling, Physical Modeling, Dimensional and relational Data Modeling using Erwin 4.2/4.0/3.5.5/3.5.2, ER studio.
• Experience in Interacting with Business Users to gather Business Requirement Specifications Document and Prepare System Requirement Specifications document.
• Good understanding of relational database management systems and extensively worked on Data extraction, transformation, loading with Oracle, DB2, Teradata and SQL Server 2008 using Informatica.
• Experienced with Data Extraction, Transformation and Loading ETL from disparate Data Source databases like Oracle, SQL Server, MS Access, flat files, CSV files, SAP and XML files and loaded into target warehouse by using various transformations in Informatica.
• Experience in Production Support, extensively worked on production support issues and resolved them using session logs, workflow logs, and used e-mail task for capturing issues via e-mail along with the Session logs.
• Experienced in Debugging and Performance tuning of targets, sources, mappings and sessions and experience in optimizing the Mappings and implementing the complex business rules by creating re-usable transformations and Mapplet.
• Experience in Data analysis, source system analysis, data transformation, data mapping from source to target database schemas and data cleansing, data migration, data domain procedures.
• Excellent knowledge and experience in creating source to target mapping, edit rules and validation, transformations, and business rules.
• Self starter, Multi Tasking, Attention to detail, ability to work with minimal supervision and manage time and task efficiently.
• Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.

Tools and Technologies:

• ETL tools: Informatica Power Mart/Power Center 9.5/9.1/8.6/8.5/8.1.1/8.0/7.1/7.0 , SSIS,
• Datastage.
• Databases: Oracle 11g/10g /9i/8i, SQL Server 2000/2005/2008, Teradata, Sybase 12/11,
• IBM DB2 UDB 8.x/7.x,DB2 Z/OS 8.2, MS SQL,MS-Access, Flat Files, SAP, XML,
• JAVA files, Netezza
• Data modeling tools: Erwin7x/6x/5x, ER studio, Toad data modler
• Operating systems: Windows NT/2000/XP/Vista, Windows Server 2003, UNIX, Linux, IBM AIX
• 5.3/4.2, MS-DOS, Sun Solaris
• Languages: SQL, PL/ SQL, T-SQL, C, C , JAVA, VB.Net, HTML, PERL scripting, Unix Shell scripting.
• Reporting Tools: Business Objects, SSRS, Cognos, OBIEE
• Other Tools: TOAD, SQL Query Analyzer, Microsoft Office, Visio, Rational Rose, and UML.

Professional Experience:

Confidential

Senior ETL Developer.

Customer Billing

• Customer Billing is another project the main purpose of this project is to generate bills to the customers
• Using informatica B2B Data transformation.
• Gathering requirements from functional teams for ETL jobs, requirement analysis.
• Participation in Database Design and Database Architecture.
• Developed complex mappings using Informatica Power Center Designer to transform and load the data from various source systems like DB2, SQL Server, flat files and loading to SQL server target database.
• Collect business requirements from the users/Business Analysts Converted the Business logic into functional specs with enhancements to get better performance of the system.
• Created and Worked technical requirements and detail level documents.
• Using B2B Data Transformation, parse XSD to Generate Xml's and send them to end users.
• EDI 810, 820 library files for integration using B2B data transformation.

Environment: Informatica Power Center 9.1/9.5, Power center Developer, B2B Data Transformation , Oracle 10g/11g, DB2,SQL server 2008 R2 , Toad, Sql server management studio ,IPSwitch, Textpad, Linux, UNIX Shell Scripting, Visio, Excel, object-oriented design, T/SQL, DW architectures, web services.

Confidential

Senior ETL Developer

Payment Data Store.

• The scope of the project was to move Payment data from source system OLTP to Operational data stores in near real time. Data loaded by our team is used by Operational or downstream system reporting OLAP
• Used Oracle Golden Gate to replicate the change data from the source system to staging area.
• Developed complex mappings to Parse the XML string by using XML parser, Java Transformation and load the parsed data into Netezza Target tables.
• Analysis of source system tables to build the Logical and physical data models.
• Gathering the ETL requirements and working closely with DBA to generate the DDL in the target system Netezza for the ETL loads.
• Optimization of ETL Codes, if the loads are huge by creating Index's on the tables.
• Created technical support documentation for the team for production support.
• Unit tested the developed ETL scripts, created test SQLs and handled SIT and UAT issues.
• Implemented and extensively worked on Slowly Changing Dimensions Type 1 Type2
• Responsible for Business Analysis and Requirements Collection. Involved in creating the technical requirements and detail level documents.

Environment: Informatica Power Center 9.1/8.6, Erwin data modler, Oracle 10g/11g, Netezza, Toad, Jmeter PL/SQL, Linux, UNIX Shell Scripting, Visio, Excel, object-oriented design, T/SQL, DW architectures, bus architecture.

Confidential

Senior ETL Developer

Responsibilities:

• Collect business requirements from the users/Business Analysts Converted the Business logic into functional specs with enhancements to get better performance of the system.
• Created and Worked technical requirements and detail level documents.
• Involve in the entire SDLC Software Development Life Cycle process that includes implementation, testing, deployment and maintenance.
• Analyzed different data sources like Oracle and Flat files, XML files, Cobol, Text Files, SAP from which movies, sales data, contract and billing data is coming and understand the relationships by analyzing the OLTP Sources and loaded into Oracle data warehouse.
• Performed Oracle Data Warehousing development including data modeling and backend processes, specifically, Extraction, Transformation and Loading ETL of data into staging tables and then into Data Marts/Warehouses for presentation.
• Extensively worked on developing Informatica Mappings, Mapplets, Sessions, Workflows and Worklets for the data to target warehouse using Informatica Workflow Manager.
• Mapplets and Reusable Transformations were used to prevent redundancy of transformation usage and maintainability.
• Implemented and extensively worked on Slowly Changing Dimensions SCDs, Both Type 1 Type2 Type3 .
• Configured the sessions using Workflow Manager to have multiple partitions on Source data and to improve performance.
• Used Informatica Debugger, session logs and Toad to resolve problems in a timely manner.
• Experienced in tuning informatica Mappings to identify and remove processing bottlenecks and developed deployed and monitored Informatica mappings into production.
• Coordinate and develop all documentation related to ETL design and development.

Environment: Informatica Power Center 9.1/8.6, Toad Data Modeler, Oracle 10g/11g, Toad, PL/SQL, Linux, UNIX Shell Scripting, Visio, Excel, object-oriented design, T/SQL, DW architectures, bus architecture.

Confidential

Senior ETL Developer

Responsibilities:

• Involved in the entire SDLC System Development Life Cycle process that includes Design, implementation, testing, deployment and maintenance.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Responsible for developing, executing and maintaining appropriate ETL administration best practices and procedures.
• Responsible for Business Analysis and Requirements Collection. Involved in creating the technical requirements and detail level documents.
• Provided support for the deployed ETL processes and performing code migration.
• Developed complex mappings using Informatica Power Center Designer to transform and load the data from various source systems like Oracle, SQL Server, flat files and loading to Oracle target database.
• Unit tested the developed ETL scripts, created test SQLs and handled SIT and UAT issues.
• Worked as production support developer to identify and fix data problems.
• Created technical support documentation for the team for production support.
• Used Shell Scripts for better handling of incoming source files such as moving files from one directory to another directory and extracting information from the log files on Linux server.

Environment: Informatica Power Center 8.6.1 , Erwin, Oracle 10g/11g, Clear Case, PL/SQL, Linux, UNIX Shell Scripting, VASM, Java /J2EE, Visio, SQL Server 2008, DW architectures ,object-oriented design, T/SQL, bus architecture, Core FTP Windows XP/Windows Vista Enterprise Edition.

Confidential

Senior ETL Developer.

Responsibilities:

• Interacted with the data modeler and business users on a regular basis to understand the functional requirements. Was Involved and created technical requirements and detail level documents.
• Source data from relational tables and flat files is transformed in the stage layer by applying the business logic.
• Used Informatica features to implement Type 1, Type 2 changes in slowly changing dimensions.
• Prepared user requirement documentation for mapping and additional functionality.
• Involved in creating Repositories, Folders, Versions, and Repository Objects using Repository Manager under the Informatica Power Center.
• Used the mapping operators like sorter, Lookup, aggregator, expression, joiner, filter in the creation of mappings.
• Worked with various Informatica Power Center objects like Mappings, transformations, Mapplet, Workflows and Session Tasks.
• Cleansed the source data, extracted and transformed data with business rules, and built reusable mappings, using Informatica Designer.
• Extensively written SQL and /PLSQL scripts while testing, using update strategy and Expression.
• Tested the target data against source system tables by writing the PL/SQL Procedures.
• Responsible for the performance tuning of the ETL process at source level, target level, mapping level and session level.
• Extensively worked with performance tuning at mapping levels like implementing active transformation like filter as early as possible in the mapping.
• Written scripts while migrating to testing and production.
• Written UNIX shell scripts to load the data in testing environment.
• Deployed the mappings into testing and production environments.

Environment: Informatica Power Center 8.6.1 , Erwin, Teradata, Fast load, Multiload, parallel transporter, SQL assistant, PL/SQL, Linux, UNIX Shell Scripting, VASM, Solaris, Java /J2EE, Visio, UML,VSAM, MVS, Informatica Power Exchange, Excel, Oracle 10g/11g, DW architectures, MDM, object-oriented design, T/SQL, Core FTP Windows XP/Windows Vista Enterprise Edition.

Confidential

Senior ETL Developer.

Responsibilities:

• Gathering requirements from functional teams for ETL jobs, requirement analysis and
• project planning
• Interacted with business analysts, data architects, application developers to develop a data model.
• Production Support in general program and commercial ratings.
• Monitoring Daily and monthly loads.
• Was involved in Testing, debugging and Production move.
• Used Microsoft visual source safe for the backup of the mappings, sessions and store procedures.
• Participation in Database Design and Database Architecture
• Design Informatica mappings, sessions and workflows to implement the business rules during the data extraction, transformation and loading
• Data cleansing and cleaning
• Build complex logics using different transformations viz., Filter, Router, Expression, Lookup Static and Dynamic , Aggregator, External stored procedure, Update Strategy, etc. in Informatica mappings
• Writing PL/SQL stored procedures and call them through Informatica mappings
• Code development, prepare unit and integration test plans, code review, testing, debugging, deployment of Informatica Jobs into production environment.
• Deployment of Informatica jobs into testing, Validation and production environments
• Preparing deployment documents, user guides, coding standards, and other technical documents
• Performance tuning of the Informatica
• Co-coordinating with India based team in the onsite-offshore team model

Environment: Informatica PowerCenter designer, Workflow Manager, Workflow Monitor SQL Server 2000, Business Objects, UNIX, Erwin, SQL, PL/SQL, VB Script, Microsoft Visual source safe.