SUMMARY

• 7+ Years of experience in System Analysis, Design, Development Implementation, Maintenance, and Testing of Data Warehouse and Data Integration Applications using ETL tools like Informatica Power center 9.5/9.1/8.x/7.x
• Experience on Business Requirements Analysis, Application Design, Development, Testing, Implementation and maintenance of client/server Data Warehouse and Data Mart systems in the Healthcare, Finance and Pharmaceutical industries.
• Expertise in designing confirmed and traditional ETL Architecture involving Source databases Main Frame systems, Oracle(10g - 11g), Flat Files ( fixed width, delimited ), DB2, SQL server, XML and Target databases.
• Dimensional Data modeling experience using Data modeling tool Sybase Power designer. Worked closely with the Business Objects reporting team to design the data mart tables for Business Objects reports.
• Strong knowledge of Dimensional Modeling, Star and Snowflake schema. Expertise in Data Flow Diagrams, Process Models, and ER diagrams with modeling tools like ERWIN & VISIO.
• Extensive Experience in designing and developing complex mappings applying various transformations such as Lookup, Source Qualifier, Update Strategy, Router, Sequence generator, Aggregator, Rank, Stored Procedure, Filter, Normaliser, Joiner and Sorter transformations, Mapplets.
• Experience in using various Informatica Powercenter Client components Designer/ Workflow manager /Worklfow Monitor/Repository Manager.
• Extensive experience in developing the Workflows, Worklets, Sessions, Mappings, and configuring the Informatica Server using Informatica Power Center.
• Proficient in delivering the high data quality by designing, developing and automation of audit process and implementing the reconcile process accordingly.
• Performed the data profiling and analysis making use of Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ).
• Experience in implementing the best practice standards throughout the development cycle following the Informatica Velocity methodology.
• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De normalization Concepts.
• Good Knowledge on Siperian MDM.
• Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files. Hands on experience in maintaining the code versions using Visual Source Safe / Informatica Versioning.
• Strong written and oral communication skills.
• Good knowledge in writing Unix Shell & Autosys JIL scripts and PERL Scripts.
• Excellent team player and self-starter with good ability to work independently and possess good analytical, problem solving and logical skills.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x/7.x, IDE, IDQ, Siperian MDM, SSIS

OS: Unix, MS-DOS, Windows ME/2000/2003/NT/XP

Databases: Oracle (10g-11g), DB2, SQL Server 2012/2008/2005, Teradata

Programming Skills: PL/SQL

DB: TOAD, SQL* Plus, Erwin

Data Modeling: Sybase Power Designer 15.2

Scripts: UNIX Shell, PERL, Autosys JIL, JavaScript

PROFESSIONAL EXPERIENCE

Confidential - Walnut Creek, CA

Sr. ETL Developer

Responsibilities:

• Worked with Informatica Data Quality 8.6.1 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 8.6.1.
• Worked on requirements gathering, architecting the ETL lifecycle and creating design specifications, ETL design documents.
• Identified and eliminated duplicates in datasets thorough IDQ 8.6.1 components of Edit Distance, Jaro Distance and Mixed Field matcher, It enables the creation of a single view of customers, help control costs associated with mailing lists by preventing multiple pieces of mail.
• Responsible for Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Schedule the workflows to pull data from the source databases at weekly intervals, to maintain most current and consolidated data.
• Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica 9.1.0.
• Designed and developed transformation rules (business rules) to generate consolidated (fact/summary) data using Informatica ETL tool.
• Deployed reusable transformation objects such as mapplets to avoid duplication of metadata, reducing the development time.
• Developed and maintained ETL (Extract, Transformation and Loading) mappings to extract the data from multiple source systems like Oracle, XML, SQL server and Flat files and loaded into Oracle.
• Use version mapping to update the slowly changing dimensions to keep full history to the target database.
• Informatica Data Quality (IDQ 8.6.1) is the tool used here for data quality measurement.
• Extensively worked with Teradata in data Extraction, Transformation and loading from source to target system using Bteq, Fast Load, and Multi Load.
• Work on design and development of Informatica mappings, workflows to load data into staging area, data warehouse and data marts in Oracle.
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2/XML and migrated those to Teradata.
• Extracted data from different databases like Oracle and external source systems like flat files using ETL tool.
• Design the Source - Target mappings and involved in designing the Selection Criteria document.
• Wrote BTEQ scripts to transform data. Used Teradata utilities fastload, multiload, tpump to load data
• Responsible for manually start and monitor production jobs based on the business users requests.
• Responsible to look into production issues and resolved them in timely manner.
• Developed Informatica process to replace stored procedure functionalities and provide a time effective and high data quality application to the client.

Environment: Informatica Power center 9.5, IDQ, Oracle, XML, Sybase Power Designer 15.2, Teradata, Teradata SQL Assistant, Java, SQL Server and SSIS.

Confidential, Dallas, TX

ETL Informatica Developer

Responsibilities:

• Involved in translating business requirements to Technical specifications.
• Designed, developed, implemented and maintained Informatica PowerCenter and IDQ application for matching and merging process.
• Work with source system SMEs to identify the source data to be brought down to the Data mart.
• Involved in full project life cycle - from analysis to production implementation and support.
• Extensively used Informatica Client tools - Powercenter Designer, Powercenter Repository Manager, Powercenter Workflow Manager and Powercenter Workflow Monitor.
• Created pre and post session Stored procedures to drop, recreate the indexes and keys of source and target tables.
• Utilized ofInformatica IDQ to complete initial dataprofiling and matching/removing duplicate data.
• Developed the source to target mapping document for ETL development in Informatica.
• Worked Extracted/loaded data from/into diverse source/target systems like Oracle, XML and Flat Files.
• Perform system testing and enter test cases in Quality Center to ensure data is loaded and mapped correctly to Data mart tables according to the source to target mapping document.
• Designed, developed Informatica mappings using Informatica 9.1, enabling the extract, transport and loading of the data into target tables and loading into the Teradata.
• Informatica Data Explorer (IDE) and Informatica Data Quality (IDQ 8.6.1) are the tools are used here. IDE is used for data profiling over metadata and IDQ 8.6.1 for data quality measurement.
• Assist business analysts/users in identifying data gap and data variances.
• Developed ETL procedures to transform the data in the intermediate tables according to the business rules and functionality requirements.
• Create and execute unit test plans based on system and validation requirements, Troubleshoot, optimize, and tune ETL processes.
• Update the data dictionary on system data and mapping information.
• Responsible to create interactive Dash board reports as per the Business requirements.
• Documented and maintained and ensured the process and quality of the system.

Environment: Informatica Power center 9.1, IDQ, Oracle, Teradata, Sybase Power Designer 15.2, XML, SQL Server, Toad for DB2 4.5, Flat Files, Quality Center, UNIX and ESP, Business Objects.

Confidential - Houston,Tx

ETL Developer and Support Engineer

Responsibilities:

• Work closely with team of Business Analyst / Developers and testers to understand the business requirement and the existing ETL flow.
• Experience in migration of ETL and non ETL packages from lower to higher environment.
• Extensively used Informatica Client tools - Powercenter Designer, Powercenter Repository Manager, Powercenter Workflow Manager and Powercenter Workflow Monitor.
• Created users and user groups with appropriate privileges and permissions, folders and folder permissions in Repository manager.
• Designed and developed daily audit and daily/weekly reconcile process ensuring the data quality of the Data warehouse.
• Provided guidance and specifications to developers for the maintenance and enhancement of custom ETL code.
• Responsible for maintaining backups for ETL and non ETL packages in higher environment.
• Responsible for be on 24*7 on call to help various ETL and non ETL issues.
• Worked closely with Business objects team to convert the SQL’s to ETL logic.

Environment: Informatica Power Center 8.6.1, Oracle 10g, Teradata, WebFocus7, XML, Toad for Oracle, Business Objects.

Confidential - Oklahoma City, OK

ETL Developer

Responsibilities:

• Worked with business analysts for requirement gathering, business analysis, and translated the business requirements into technical specifications to build the Enterprise data warehouse.
• Worked on complete life cycle from Extraction, Transformation and Loading of data using Informatica.
• Analyzed the system for the functionality required as per the requirements and created System Requirement Specification document (Functional Requirement Document).
• Involved in the development of the conceptual, logical and physical data model of the star schema using ERWIN.
• Extensively used Informatica Client tools - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Extensive experience in Design and Developing Informatica Packages for Equity Capital Market.
• Designed and developed daily audit and daily/weekly reconcile process ensuring the data quality of the Data warehouse.
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup (connected and unconnected), Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Created and Configured Workflows, Worklets and Sessions to transport the data to target warehouse tables using Informatica Workflow Manager.
• Worked Extensively on Teradata SQL Assistant to analyze the existing data and implemented new business rules to handle various source data anomalies.
• Created users and user groups with appropriate privileges and permissions, folders and folder permissions in Repository manager.
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Involved in Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Developed UNIX shell scripts using PMCMD utility and scheduled ETL load.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Prepared Run books providing guidelines to trouble shoot the errors occurred during the run time and instructions on how to restart the loads.
• Actively involved in production support. Implemented fixes/solutions to issues/tickets raised by user community.

Environment: Informatica Power Center 8.6.1, Oracle10g, XML, Teradata, Business Objects and UNIX.

Confidential, CA

ETL Developer

Responsibilities:

• Understanding Client requirements for populating data in the target system
• Developed ETL jobs to extract information from disparate systems like SAP, DB2, Flat Files, Oracle, MS SQL and XML’s.
• Worked with mapping parameters and variables to load data from different sources to corresponding partition of the database table.
• Implemented slowly changing strategy Type II to manage the data in the dimension tables.
• Developed workflows and sessions associated with the mappings using Workflow Manager.
• Involved in performance tuning to optimize session performance by eliminating performance bottlenecks.
• Involved in creating stage tables/mappings/ setting the trust level -HDD in Siperian for Customer Master system.
• Used the mapping parameter to make the mapping more flexible
• Involved in the Code review, Peer to peer testing.

Environment: Informatica 8.1.1, Oracle, UNIX SHELL script, XML, SIPERIAN tool (MDM), Autosys.

Confidential

ETL Developer

Responsibilities:

• Analyzed specifications and identified source data needs to be moved to Data Mart, participated in the design team and user requirement gathering meetings.
• Performed major role in understanding the business requirements and designing and loading data into data warehouse. Designed star schema using Dimension modeling using the ER-win design tool.
• Extensively used ETL (Informatica) to load data from source (Flat files) to target Oracle database.
• Lookup, Aggregator, sequence, joiner and other transformations are used in populating data process.
• Created Informatica Mappings with PL/SQL procedures/functions to build business rules to load data.
• Involved in scheduling the Informatica Workflows using Autosys.
• Conducted Performance tuning of application by modifying the SQL statements and using Explain Plan and TOAD Software.
• Used the Oracle stored functions/procedure/Packages.
• Created PERL scripts for some of the target system load
• Involved in developing the requisite reports (list, grouped list, cross-tabs etc.) using Business Objects.

Environment: Informatica Power Center 7.1, Oracle 8i, PL/SQL, XML, SQL, Autosys, Windows NT, PERL Scripting, MS Access.