SUMMARY:

• Having 7+ years of IT experience with expertise in Analysis Design Development Testing and implementation of Data warehouse, Data marts with ETL OLAP Tools using Informatica Power Center v10.x, 9.x, 8.x, Power Exchange, Data Quality, Oracle 11g/10g/9i, SQL Server.
• Expertise knowledge in domains likeHealthcare, Retail, Telecom and Insurancesystems.
• Extensive ETL experience using Informatica PowerCenter10.x/9.x/8.x (Designer, Workflow Manager, Workflow Monitor and Server Manager).
• Extensively worked on transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, Update Strategy, Sequence Generator and Stored Procedures etc.
• Extensively worked on IDQ Mapping Designer, Mapplet Designer, Transformation developer Designer, Workflow Manager and Repository.
• Experienced to Profile, Analysis, Standardize, Clean, Integrate, Score Carding, and Reference Data from various source systems using Informatica Data Quality (IDQ).
• Designed and developed Reference Integrity, Technical and Business Data Quality rules using IDQ and involved in cleaning the data using IDQ in Informatica Data Quality environment.
• Hands on experience in identifying and resolving performance bottlenecks in various levels like sources, mappings and sessions.
• Hands on experience in optimizing SQL scripts and improving performance and loading into warehouse.
• Deployed workflows as an application to run them and tuned the mappings for better performance.
• Experience in Extraction, Transformation and Loading of data from different heterogeneous source systems like Flat files (Fixed width & Delimited), XML Files, UDB, Excel, Oracle, Sybase, and MS SQL Server.
• Worked with Dimensional Data warehouses in Star and Snowflake Schemas, created slowly changing (SCD) Type1/2/3 dimension mappings using Ralph Kimball methodology.
• Experience in coding using Oracle 11g/10g/9i/8i, SQL Server 2000/2005/2008 , SQL, PL/SQL procedures, functions, triggers and exceptions.
• Experience in creation and maintenance of entity objects, hierarchies, entity types and relationship objects in MDM.
• Good knowledge on estimates and planning of development work using Agile methodology.
• Worked on Agile methodology for quick responses to change and continuous development.
• Involved in Agile process for continuous attention to technical excellence and good design.
• Performed Informatica server administration work Installations and upgrades.
• Expertise in using Informatica Web services, HTTP and XML transformations.
• Usage of Informatica mapping variables/parameters and session variables where necessary.
• Experience in implementing update strategies, incremental loads.
• Good experience in Relational Database Concepts, Entity relational Diagrams.
• Experience in scheduling the batch jobs using workflow designer, Autosys, control - M, Zena, Cron Tab.
• Expertise in building Enterprise Data Warehouses (EDW), Operational Data Store (ODS), Data Marts and Decision Support Systems (DSS) using Multidimensional and Dimensional modeling (Star and Snowflake schema) Concepts.
• Developed Batch Jobs using UNIX Shell scriptsto automate the process of loading, pushing and pulling data from different servers.
• Developed UNIX scripts using PMCMD utility and scheduled ETL load using utilities like Autosys, CRON tab, etc.
• Expertise in OLAP/OLTP System Study, Analysis and E-R Modeling, developing database Schemas like Star Schema, Snowflake Schema, Conforming Dimensions and Slowly Changing Dimensions used in relational, dimensional and multi-dimensional modeling.
• Expertise in end to end software development life cycle execution including Requirement Gathering, Requirement Analysis, Cost Estimation, Project Management, Design, Development, Implementation and Testing.
• Excellent communication and interpersonal skills, ability to work effectively as a team member as well as an individual.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter10.x/9.x/8.x, Informatica Data Quality, Power Exchange, Informatica Analyst.

RDBMS: Oracle11g/10g/9i, SQL Server 2000/2005/2008 , Teradata

Operating System: Windows, Linux

Job Scheduling Tools: Autosys, Control M, Cron Tab, Tivoli

Languages: SQL, PL/SQL, Unix Shell Scripting

Database frontend tools: Oracle, PLSQL Developer, SQL Assistant, Oracle TOAD.

PROFESSIONAL EXPERIENCE:

Confidential, Tampa

Informatica Developer

Responsibilities:

• Worked with ETL Developers in creating External Batches to execute mappings, Mapplets using Informatica workflow designer to integrate data from varied sources like Oracle, flat files and SQL databases.
• Document the process that resolves the issue which involves analysis, design, construction and testing.
• Used Autosys Scheduler to Create, Schedule and control the batch jobs.
• Worked on Hl7 files from different labs.
• Worked on visual studio TFS to check in informatica workflows, source and targets to production.
• Migration of ETL code from Development to QA and from QA to Production environments.

Confidential, Westchester, Philadelphia

Informatica IDQ Developer

Responsibilities:

• Designed and developed Informatica Mappings from OLTP to Stage and Stage to DWH and effectively used Informatica Transformations like Source Qualifier, Joiner, Expression, Router, Aggregator, Connected and Unconnected Lookup, Normalizer, Update Strategy etc.
• Developed complex mappings, mapplets using Informatica workflow designer to integrate data from varied sources like Oracle, SQL Server, Flat files and loaded into target.
• Worked on performance tuning by identifying the bottlenecks in Sources, Targets, and Mapping enhanced Performance for Informatica sessions using large data files by using partitions.
• Design and developing ETL process using Informatica Data Quality 10.1.1, Teradata, Oracle, UC4 job Scheduler, WinSCP, Hadoop, Putty.
• Designed and developed star schema, snowflake schema and created fact tables and dimension tables for the warehouse and data marts using Erwin.
• Automated/Scheduled the cloud jobs to run daily with email notifications for any failures.
• Developed data Mappings between source systems and warehouse components using Mapping Designer
• Worked extensively on different types of transformations like source qualifier, expression, Aggregator, Router, filter, update strategy, lookup, sorter, Union, Stored Procedure and sequence generator.
• Data modeling and design of for data warehouse and data marts in star schema methodology with Dimensions and Fact tables.
• Configured custom landing tables and performed proof of concept integrating hub state indicator as required by the business requirements.
• Created Unix Shell Scripts for ETL jobs, session log cleanup, dynamic parameter and maintained shell scripts for data conversion.
• Testing the application using test cases and building the code release packages to test and moving to production environments.
• Working closely with Data Quality Analysts, understanding the client application and requirements.
• Worked on production issue analysis.

Confidential, Atlanta, Georgia

Informatica Developer/ Data Analyst

Responsibilities:

• Worked with ETL Developers in creating External Batches to execute mappings, Mapplets using Informatica workflow designer to integrate data from varied sources like Oracle, DB2, flat files and SQL databases.
• Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, Connected and Un-connected lookup, sorter, Normalizer, SQL transformation and sequence generator.
• Worked with Business Analysts to analyze the Data Quality issue and find the root cause for the problem with the proper solution to fix the issue.
• Document the process that resolves the issue which involves analysis, design, construction and testing for Data quality issues.
• Worked as Data analyst to analyze the source systems data.
• Profile source data using IDQ tool, understand source system data representation, formats & data gaps.
• Created Exception handling process and worked on the best practices and standards for exception handling routines.
• Manage the planning and development of design and procedures for metric reports.
• Presented data and conclusion to team in order to improve strategies and operations.
• Proposed solutions to improve system efficiencies and reduce total expenses.
• Involved in checking Data accuracy standards for NULLS, Comparison, key generator and labeler using reference table manager in PWH and rolled based on statistics through Threshold value and Score Cards applied the Data cleansing process.
• Proficient in creating Column and Rule Based Profiling with PDQ and LDO's for deep dive into Master tables.
• Experienced in creating Scorecard to Project the different checks like Consistency, Completeness, Accuracy and Conformity.
• Written shell scripts to execute the workflows, cleanup the files, execute Scripts and for other batch processing’s.
• Integrated data from external sources like swift, xml using B2B Data exchange tool of Informatica.
• Used Autosys Scheduler to Create, Schedule and control the batch jobs.
• Used Network Data Mover to receive/transfer files across multiple source systems.
• Involved with Data Steward Team for designing, documenting and configuring IDD.
• Utilized Informatica IDQ to complete initial data profiling and matching/removing duplicate data.
• Developing the Mappings to move the data loaded from Landing to Stage by using various cleanse functions.
• Good at Data Warehouse techniques -Dimensional data Modeling, Star Schema and Snowflake Schema
• Involved in creating IDD tasks and assigning roles to the tasks in ActiveVos to trigger the workflows.
• Registered the Data maps for Real-time CDC Changed Data Capture data in Power Exchange.
• Worked on Extraction maps Row Test in Power Exchange Navigator.
• Designed developed, implemented ETL process to extract, transform, and load (ETL) data from inbound flat files and various source systems and loaded into Data Mart using the Informatica PowerCenter.
• Designed and created BO, staging tables, mappings, transformations as per business requirements.
• Created mappings to perform the tasks such as cleansing the data and populate that into staging tables.
• Used Metadata manager for validating, promoting, importing and exporting repositories from development environment to testing environment.
• Migration of ETL code from Development to QA and from QA to Production environments.
• Created Web services in IDQ developer tool and generated WSDL file for real time services.
• Worked on Infrastructure setup for building new applications.
• Developing SAP HANA information models such as Procedure and Hana Views (Attribute, Analytics and Calculation views) with graphical and SQL Scripting, SDA (Smart Data Access)
• Used metadata driven ETL framework to generate XML’s and for batch execution control.
• Assisted and worked on performance testing, data quality assessment & production deployments.
• Involved in jobs scheduling, monitoring and production support in a 24/7 environment.

Environment: Power Center 11.1,IDD, Data Quality, power Exchange,Data Exchange, IDQ, Oracle 11g, SQL assistant, SAP HANA, Autosys, DTS, SQL, UNIX Shell Scripts and Linux, JIRA, Confidential Visio, SharePoint.

Confidential -Orville, Ohio

Informatica Developer/ Data Analyst

Responsibilities:

• Designed developed, implemented ETL process to extract, transform, and load (ETL) data from inbound flat files and various source systems and loaded into Data Mart using the Informatica PowerCenter.
• Worked extensively on different types of transformations like Source qualifier, expression, Aggregator, Router, filter, update strategy, Connected and Un-connected lookup, sorter, Normalizer, SQL transformation and sequence generator.
• Strong Data modeling experience using ER diagram, Dimensional data modeling, Conceptual/Logical/Physical Modeling using 3NormalForm (3NF), Star Schema modeling, Snowflake modeling using tools like Erwin, ER-Studio, SAP Power Designer.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets.
• Understanding the OLAP processing for changing and maintaining the Warehousing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Optimized data collection procedures and generate reports on a weekly, monthly and quarterly basis.
• Presented data and conclusion to team in order to improve strategies and operations.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
• Created DDL scripts for implementing Data Modeling changes. Created ERWIN crystal reports in HTML, RTF format depending upon the requirement, Published Data model in model mart, created naming convention files, coordinated with DBA’s to apply the data model changes.
• Extensively used ERWIN for REVERSE Engineering, FORWARD Engineering, SUBJECT AREA, DOMAIN, Naming Standards Document etc.
• Profile source data using IDQ tool, understand source system data representation, formats & data gaps.
• Created Exception handling process and worked on the best practices and standards for exception handling routines.
• Worked on data cleansing using the cleanse functions in Informatica MDM.
• Involved in SIF integration to develop xml code for external applications to perform search match API calls against MDM Hub Data.
• Utilized Informatica IDQ to complete initial data profiling and matching/removing duplicate data.
• Developing the Mappings to move the data loaded from Landing to Stage by using various cleanse functions.
• Design, develop, test and review & optimize Informatica MDM and Informatica IDD Applications.
• Registered the Data maps for Real-time CDC Changed Data Capture data in Power Exchange.
• Worked on Extraction maps Row Test in Power Exchange Navigator.
• Created Web services in IDQ developer tool and generated WSDL file for real time services.
• Worked on Infrastructure setup for building new applications.
• Used metadata driven ETL framework to generate XML’s and for batch executioncontrol.
• Written shell scripts to execute the workflows, cleanup the files, execute Scripts and for other batch processing’s.
• Good at Data Warehouse techniques -Dimensional data Modeling, Star Schema and Snowflake Schema
• Designed and developed star schema, snowflake schema and created fact tables and dimension tables for the warehouse and data marts using Erwin.
• Data modeling and design of for data warehouse and data marts in star schema methodology with Dimensions and Fact tables.
• Helped in viewing records and explained manual merge/unmerge process in IDD to data stewards.
• Used Autosys Scheduler to Create, Schedule and control the batch jobs.
• Used Network Data Mover to receive/transfer files across multiple source systems.
• Assisted and worked on performance testing, data quality assessment & production deployments.
• Involved in jobs scheduling, monitoring and production support in a 24/7 environment.

Environment: Informatica Power Center10.1,IDD, Data Quality,power Exchange, Oracle 11g, SQL assistant, Autosys, DTS, SQL,IDQ, UNIX Shell Scripts, Linux.

Confidential -Seattle, Washington

ETL/Informatica IDQ Developer

Responsibilities:

• Developed Data Flow diagrams to create Mappings and Test plans. Specifically these data flow diagrams ranged from OLTP systems to staging to Data warehouse.
• Designed and developed Informatica Mappings from OLTP to Stage and Stage to DWH and effectively used Informatica Transformations like Source Qualifier, Joiner, Expression, Router, Aggregator, Connected and Unconnected Lookup, Normalizer, Update Strategy etc.
• Developed complex mappings, mapplets using Informatica workflow designer to integrate data from varied sources like Oracle, SQL Server, Flat files and loaded into target.
• Worked on performance tuning by identifying the bottlenecks in Sources, Targets, and Mapping enhanced Performance for Informatica sessions using large data files by using partitions.
• Worked extensively on IDQ Analyst for Profiling, Creating rules on Profiling and Scorecards.
• Extensively worked on Address Validator transformation in Informatica developer (IDQ).
• Utilized Informatica IDQ 9.6.1 to complete initial data profiling and matching/removing duplicate data.
• Integrated IDQ mappings through IDQ web service applications as cleanse functions in Informatica
• Worked with Static cache, Persistent, Dynamic cache, Index cache, Data cache and target based commit interval in order to improve the performance at session level.
• Developed Unix Shell Scripts to ensure successful execution of the ETL processes
• Responsible for using different types of Stages such as ODBC Connector, Oracle Connector, Transformer, Join, Sequential File to develop different jobs.
• Applied the concept of Change Data Capture (CDC) and imported the source from Legacy systems using Informatica Power Exchange (PWX).
• Used Power Exchange to extract data from the ERP systems.
• Developed strategies for Incremental data extractions as well data migration to load into the Oracle and also assisted in designing Logical/Physical Data Models.
• Extensively performed Data Masking for preserving the referential integrity of the user data.
• Build several Unix Shell scripts for PL/SQL programs to schedule them on Control M.
• Assisted the team in the development of design standards and codes for effective ETL procedure development and implementation.
• Worked with SQL Override in the Source Qualifier and Lookup transformation.
• Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.
• Created Unix Shell Scripts for ETL jobs, session log cleanup, dynamic parameter and maintained shell scripts for data conversion.
• Built UNIX script and Autosys scheduler jobs to perform PNE batch jobs, File and Data Archival jobs
• Prepared Unit Test plan and efficient unit test documentation was created along with Unit test cases for the developed code.
• Involved in the process design documentation of the DW Dimensional Upgrades.
• Coordinate with offshore team and client, update daily status report to client.
• Validate the data in source and target systems using PL/SQL queries.
• Involved in migration of mappings and sessions from development repository to production repository.
• Installed and Documented the Informatica Power Center setup on multiple environments.

Environment: Informatica PowerCenter 9.5.1,Data Quality, PowerExchange 9.5.1, Oracle 11g, SQL/PL SQL, SQL Server, Windows XP,LINUX, UNIX,Control M.

Confidential -Redmond, Washington

ETL/Informatica Developer

Responsibilities:

• Involved in design & development of operational data source and data marts in Oracle.
• Involved in analyzing source systems and designing the processes for Extracting, Transforming and Loading the data.
• Involved in Data Model Design and used best approaches to configure Physical and Logical model.
• Used various transformations such as Source Qualifier, Expression, Lookup, Sequence Generator, aggregator, Update Strategy and Joiner while migrating data from various heterogeneous sources like Oracle, SQL Server, and Flat files to target data base.
• Made changes in mappings with data changing capture capability for sources which have data added rapidly.
• Worked extensively on bug fixing of the existing mappings, performance tuning for better performance with best performance techniques and making existing objects to adhere to standards set up for the project.
• Created mappings in Informatica Developer (IDQ) using Parser, Standardizer and Address Validator Transformations.
• Worked with Informatica Data Quality toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ.
• Integrated IDQ mappings through IDQ web service applications as cleanse functions in Informatica
• Extracted Mainframe files using Informatica Power Exchange and transformed them to be loaded in Operation Data Store (ODS) tables.
• Implemented Real time Chang Data Capture (CDC) using Informatica Power Exchange.
• Written and used UNIX shell scripts for scheduling and pre/post session management.
• Involved in performance tuning of the Informatica ETL mappings by using TPTconnections, pushdown optimization, and partitioning, resizing caches.
• Created mapping variables and parameters for incremental loading.
• Handled Slowly Changing Dimensions (Type I, Type II, Type III) based on the business requirements.
• Reviewed source data and recommend data acquisition and transformation strategy.
• Wrote SQL stored procedures to implement business logic.
• Involved in conceptual, logical and physical data modeling and used star schema in designing the data mart.
• Used Informatica Power center workflow manager to design sessions, assignment, e-mail and command to execute mappings.
• Developed and coded applications in PL/SQL.
• Created mapplets to reuse the transformation logic in several mappings.
• Designed and setup Autosys batch jobs by Setting up Autosys profile, built JIL script, UNIX script, dependency set up with other existing jobs
• Used power center workflow monitor to monitor the workflows.
• Optimized mappings using transformation features like aggregator, filter, joiner, expression and lookups.
• Created daily and weekly workflows and scheduled to run based on business needs.
• Involved in creating complex and custom reports using SSRS with drilldown features, sub reports, charts.
• Worked closely with Production Control team to schedule shell scripts, Informatica workflows and PL/SQL code in Autosys.
• Involved in developing test automation scripts using Perl/Python.

Environment: Informatica PowerCenter Designer 9.1, Informatica Power Exchange 9.1,Data Quality, Oracle11g, MS Visio, TOAD, UNIX, PL/SQL, SQL Developer, SSRS, Autosys.

Confidential

Informatica Developer

Responsibilities:

• Developed ETL jobs to extract information from Enterprise Data Warehouse.
• Extensively used ETL to load data from different relational databases, XML and flat files.
• Used ETL, Informatica Repository Manager to create repositories and users and to give permissions to users.
• Debugged the mappings extensively, hard coding the test data ids to test the logics going instance by instance.
• Performed various transformations, aggregations and ranking routines on the data to be stored in the application reporting mart.
• Handle the Migration process from Development, Test and Production Environments.
• Implemented Type 2 slowly changing dimensions to maintain dimension history and Tuned the Mappings for Optimum Performance.
• Developed PL/SQL Procedures at the database level that were used in the mappings through Stored Procedure Transformation.
• Used ETL, Informatica Designer to design mappings and coded it using reusable mapplets.
• Developed workflow sequences to control the execution sequence of various jobs and to email support personnel.
• Involved in unit testing and documenting the jobs and work flows.
• Set Standards for Naming Conventions and Best Practices for Informatica Mapping Development.
• Used database objects like Sequence generators and Stored Procedures for accomplishing the Complex logical situations.
• Created various UNIX shell scripts for Job automation of data loads.
• Created mappings which include the Error Handling Logic being implemented to create an error, ok flags and an error message depending on the source data and the lookup outputs.
• Extensively involved in the analysis and tuning of the application code (SQL).

Environment: Informatica PowerCenter 8.6, Oracle, Oracle Data Integrator, SQL, PL/SQL,SQL Developer, ER-win, Oracle Designer, MS VISIO, Autosys, Korn Shell, Quality Centre 10, LINUX, UNIX.