SUMMARY

• 8+ years of experience in datawarehouse business intelligence solutions using Informatica power center 10.1,9.x,8.x, Informatica Data Quality 9.5.1, Informatica Power Exchange 9.5.1
• Experience in dealing with various Data sources like Oracle 11/10g/9i, SQL Server 2012/2010/2008, Teradata, Salesforce objects, Ms - Access, Flat files, web services, XML, COBOL / VSAM files etc.
• Dimensional Data Modeling experience on Data modeling, Dimensional Modeling, Data marts, OLAP, FACT & Dimensions tables, Physical & Logical data modeling, Star and Snowflake Schemas.
• Working experience in implementing large Oracle, Sql Server, Teradata DBMSs.
• Strong Knowledge in Relational Database Concepts, Entity Relation Diagrams, Normalization and De normalization Concepts.
• Expertise understanding and writing PL/SQL code, T- SQL queries.
• Expertise in working in Teradata systems and used utilities like MultiLoad, FastLoad, FastExport, BTEQ, TPump, Teradata SQL
• Experince in creating Mappings and Mapplets using various connected and unconnected transformations like Source Qualifier, Aggregator, Expression, Lookup, Filter, Joiner, Union, Router, Rank, Sequence Generator, SQL, Java, Transaction control,upated strategy transformation and more.
• Experience in scheduling workflows using both Informatica and other scheduling tools like Autosys, Control-M, Crontab, Tivoli etc.
• Experience in creating Worklets, command task, decision task, email notification task, file watcher, Resuable sessions and workflows.
• Proficient in using Informatica Mapping Designer, workflow manager, workflow monitor to create, schedule and control workflows, tasks, and sessions.
• Experience working with IDQ console to implement comcepts relating to Address validator, Key generator, Data profiling.
• Hands on experience in developing and monitoring SSIS/SSRS Packages and outstanding knowledge of highavailability SQL Server solutions, including replication.
• Sound knowledge in using the Microsoft BI Stack (SSIS, SSRS, SSAS and SQL).
• Experience working with Informatica B2B Data transformation Studio to parse file of unstructured format like HL-7, EDI-X12 format like 834, 835, 837.
• Worked exclusively in implementing the slowly changing dimensions (SCDs) - Type I and II model of loads.
• Extensive experience in developing mappings for Initial load, Incremental loads using mapping parameters, mapping variables and date dimension table.
• Experience working on performance tuning in Informatica using Informatica partitioning, Push down optimization and identifying various bottleneck techniques.
• Experience in preparing the ETL Design Documents like High Level and low level Design documents. Involved in the Unit testing, integration testing, System testing and UAT using Quality Center.
• Experience in using Informatica Power Exchange Navigator to extract data from Mainframe sources.
• Experience in using Powerexchange for Salesforce adapter in Powercenter to extract data from Salesforce objects.
• Good understaning about implementation of MDM data model.
• Good exposure to development, testing, debugging, implementation, documentation, end user training and production support.
• Experience deploying ETL code to higher environment using static and dynamic deployement groups.
• Experience working Unix Shell scripting and batch scripting to automate process outside ETL mapping like handling of files, ftp, sftp and more.
• Expeirence working in Agile and Waterfall projects. Reporting Scrums on daily basis using tools like JIRA.
• Excellent communication, interpersonal and analytical skills.
• Self-motivated, quick learner and adaptive to new and challenging technological environments.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 10.1,9.x/8.x, Informatica Power Exchange 9.5.1, Informatica Data Quality 9.x,8.x, SSRS, Informatica B2B data transformation studio

Databases: Oracle (11g/10g/9i), SQL Server (2012, 2010, 2008), DB2, Teradata 14.0. Tableau 9.2

Files: Delimited, Fixed Width, XML, HL-7, EDI-X12 ( ’s)

Scheduling Tools: Control M, TWS (Tivoli workflow scheduler), Autosys, CA7.

Programming Languages: Java, SQL, PL/SQL, HTML, XML, Batch Scripting and UNIX Shell Scripting.

Development Tools: Teradata SQL Assistant, SQL plus, Toad, SSRS, SQL Server Developer.

Operating System: UNIX, Linux, Windows 2003/2008/XP/7.

Office Applications: MS-Office, Visio, Notepad++, WinSCP, Putty

PROFESSIONAL EXPERIENCE

Confidential, Farmington Hills- MI

Sr. Informatica/ETL Developer

Responsibilities:

• Working with business analysts to gather business requirements and implementing the same into a functional data warehouse design.
• Created Unit Test Case Document, Technical Design Documents, High level document, Source to target mapping document, ETL Code run book.
• Involved in gathering business requirements for the data-warehouse as well as business-intelligence reports to be used by the business user.
• Analyzed the source system for integrity issues to the data resided in various source systems.
• Involved in implementing the Land Process of loading the customer/product Data Set from various source systems like Dealer, Provider, Insurance, Claims, Internal Source systems and more.
• Defined the Base objects, Staging tables, foreign key relationships, static lookups, dynamic lookups, queries, packages and query groups.
• Actively involved in requirements gathering and complete life cycle of the project.
• Extensively worked on Informatica client tools - Source Analyzer, Warehouse Designer, Transformation developer, Mapplet Designer, Mapping Designer, Workflow Designer, Worklet Designer and Task Developer.
• Successfully Loaded Data into different targets from various source systems like Oracle Database, Flat files, XML files...etc. into the Staging table and then to the target database.
• Involved in automation of batch processing to run Informatica Workflows using Autosys.
• Performed truncate & Load process by using stored procedure transformation and load control table to stage the data.
• Worked on Slowly Changing Dimensions i.e. Type1 & Type2 and data ware housing Change Data Capture (CDC) approach using delta/incremental loads.
• Effectively use Address validator transformation from IDQ to cleanse, validate customer address.
• Created mapplet in IDQ for Address validation and imported in Powercenter to reuse the mapplet in multiple mappings.
• Created data profiling project in IDQ to analyze the data in the source tables.
• Developed PL/SQL scripts, stored procedures, Indexes, Constraints and triggers in Oracle.
• Worked on production issues like bug fixing, bottlenecks, data validation and report errors.
• Performance tuning of Sources, Targets, Mappings and Sessions by identifying bottlenecks and used Debugger to debug the complex mappings and fix them.
• Created pass through session partitions to improve performance of reading source data.
• Extensively used Shell scripts to automate the Pre-Session and Post-Sessions processes.
• Prepared test Scenarios and Test cases in HP ALM and involved in unit testing of mappings, system testing and user acceptance testing.
• Scheduled Informatica jobs through Informatica Scheduler as per the business requirement.
• Worked with reporting team to help understand them the user requirements on the reports and the measures on them.
• Worked as Onsite Lead for the Offshore Team to communicate the Clients and deliverables.

Environment: Informatica Power Center 10.1, 9.6.1, Informatica data quality (Informatica Developer tool) 9.x, Oracle 11g, DB2, Sql Server 2012, UNIX scripting, Autosys, Microstratery, Informatica Scheduler, XML Files, Jira, HP ALM.

Confidential, Baltimore, MD

Sr. Informatica/ETL Developer

Project Responsibilities:

• Interacted with business analysts to analyze the user requirements, functional specifications and system specifications.
• Used 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.
• Experience working with unstructured data transformation in Informatica powercenter once the file is parsed in Informatica DT and load them into different relational tables.
• Validating file with respect to HIPAA validation using Informatica DT.
• Created profile library project in IDQ to validate, analyze data in source tables.
• Identified and tracked the slowly changing dimensions/mini dimensions, heterogeneous Sources and determined the hierarchies in dimensions.
• Created application-specific Data Marts so that users can access personalized dashboards of information that is specific to their department and business unit.
• Worked on Query optimization & Performance tuning using Execution Plan, Performance Monitor.
• Identified ETL specification based on Business Requirements/Mapping Document and formulate process design.
• Scheduled Informatica Workflows using Autosys Scheduler
• Implemented ETL standards and Best Practices while naming Maps and processes.
• Worked closely with all team members to resolve the technical issues and business related questions.

Environment: Oracle 11g, Flat Files, XML, EDI-X12, HL-7, Teradata, Erwin r7.3.3, Informatica Power Center 8.6.1, Data Profiling / IDQ8.6.1, Informatica B2B Data transformation studio, Toad 9.7.2,SQL,PL/SQL, WIN SCP 4.3.4, Autosys, Unix Shell Scripts, Quality Center 9.0,Sun Solaris 10.

Confidential, Rolling Meadows, IL

Sr. Informatica/ETL Developer

Responsibilities:

• Created data extractions, transformations and load processes for enterprise data warehouse, data marts and enterprise applications using Informatica and SQL scripts.
• Developed complex Informatica mappings and workflows.
• Profiled clinical data and modeled database tables to generate reports on them.
• Performed Informatica administrator activities.
• Worked on Informatica PowerExchange for Change Data Capture (CDC).
• Experience with Master Data Management.
• Migrated code to Informatica QA and production environments.
• Mentored junior programmers in SQL Server 2005/2000 and Informatica.
• Extensively used T-SQL DML, DDL, DCL, TCL statements.
• Created and implemented stored procedures, user-defined functions and transactions.
• Liaison between development team, test team and project managers.
• Generated reports in MS SQL Server environment (using SSRS, T-SQL, stored procedures and views).
• Provided support for development and deployment of database models based on business requirements and mapped entities to existing data sources.

Environment: Informatica Power Center 9.1.1, Informatica Power Exchange, SQL Server, Linux, Hyperion, SQL Server Developer, Notepad ++, Beyond Compare, SSRS, Unix shell Scripting, XML Files, COBOL Files.

Confidential, Irving, TX

ETL Informatica Developer

Responsibilities:

• Study and analyze mapping document, the required source tables, data types, required transformations based on Business requirements and Technical specifications.
• Using Informatica Power Center, extracting data from SQL Server, XML files and Flat Files.
• Used SQL server reporting Services (SSRS) and created various reports such as Parameterized, Cascading, Tabular, Matrix, Chart and Drill down reports.
• Expertise in Developing Mappings, Define Workflows &Tasks, Monitoring Sessions, Export & Import Mappings and Workflows and Backup, Recovery.
• Used SQL over rides in Source Qualifier and Lookups to improve mapping performance.
• Developing Reusable Transformations, Aggregations and created Target Mappings that contain business rules.
• Extensively worked with various Passive transformations in Informatica Power Center like Expression Transformation, Sequence Generator, and Lookup Transformation.
• Created and Configured Workflows, Work lets and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Created Connected and Unconnected lookup transformation for better performance of the mappings and sessions.
• Developed simple & complex mappings using Informatica to load Dimension & Fact tables as per STAR Schema techniques.
• Optimized the performance of the mappings by various tests on sources, targets and transformations.
• Created Materialized views for summary tables for better query performance.
• Developed PL/SQL stored procedures and UNIX shell scripts for pre and post session commands, batch jobs.
• Developed UNIX Shell Scripts and SQLs to get data from Oracle tables before executing Informatica workflows.

Environment: Informatica 8.6.1, ORACLE, TOAD, SQL SERVER 2008, Control-M, Quality Center.