SUMMARY:

• Overall 8 years of Software Life Cycle experience in System Analysis, Design, Development, Implementation, Maintenance, and Production support of Data Warehouse Applications.
• Extensive experience in ETL/Informatica Power Center and data integration experience in developing ETL mappings and scripts using Informatica Power Center 10.x/9.x/8.x/7.x, IDQ.
• Have clear understanding of Data Warehousing and BI concepts with emphasis on ETL and life cycle development using Power Center, Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Experience in creating High Level Design and Detailed Design in the Design phase.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges with large data sets.
• Strong experience in designing and developing complex mappings from varied transformation logic like Unconnected and Connected, Static and Dynamic lookups, Java, SQL, Stored Procedure, Router, Filter, Expression, Aggregator, Joiner, Update Strategy.
• Strong knowledge of Entity - Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).
• Extensively worked on Dimensional Modeling, Data Migration, Data Cleansing, and Data staging for operational sources using ETL and data mining features for data warehouses.
• Good understanding of relational database management systems like Oracle, DB2, SQL Server and worked on Data Integration using Informatica for the Extraction transformation and loading of data from various database source systems.
• Worked on IDQ/IDE tools for data profiling, data enrichment and standardization.
• Experience in development of mappings in IDQ to load the cleansed data into the target table using various IDQ transformations. Experience in data profiling and analyzing the scorecards to design the data model.
• Worked on Real Time Integration between MDM Hub and External Applications using Power Center.
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Time Series, Cache Management.
• Extensively created Mapplets, common functions, reusable transformations, look-ups for better usability.
• Extensively used SQL, PL/SQL in writing Stored Procedures, Functions, Packages and Triggers.
• Experience in UNIX shell scripting, job scheduling and server communication.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate.
• Experienced in working both Waterfall & Agile Methodologies.
• Extensive database experience and highly skilled in SQL Server, Oracle, DB2, Sybase, XML Files, Flat Files, MS Access.
• Excellent communication skills and result-oriented with minimum supervision, problem solving skills and team player.

TECHNICAL SKILLS:

ETL Tools: Informatica 10.1/9.6/9.1/8.6.1/8.1 , Informatica Power Exchange 9.5.1, 10.1, IDQ, MDM, SQL Server SSIS.

Data modeling tools: Erwin

Databases: Oracle 11g/10g/9i/8i, IBM-DB2, MSSQL Server

Other Tools: Toad, SQL Developer, Crystal Reports, SQL Assistant

Programming Languages: SQL, Java, PL/SQL, T-SQL, UNIX Shell Scripting

Job scheduling: Autosys, Tidal, Control-M

PROFESSIONAL EXPERIENCE:

Confidential, New Jersey

Sr. Informatica 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.
• Created Mappings and used transformations like Source Qualifier, Filter, Update Strategy, Lookup, Expression, Joiner.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Responsibilities include creating the sessions and scheduling the sessions.
• Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
• Prepared SQL Queries to validate the data in both source and target databases.
• Worked on TOAD and Oracle SQL Developer to develop queries and create procedures and packages in Oracle.
• Created different Informatica services like Repository, Integration, Model Repository, Data Integration, Analyst, Web service, Content Management and Metadata Manager Services.
• Developed shell scripts, PL/SQL procedures, for creating/dropping table and indexes of performance for pre and post session management.
• Actively participated in Scrum Meetings.
• Created Test cases and Test Plans for unit testing with screenshots.
• Attended daily meeting with offshore developer team and weekly project status meetings whole team.
• Supported during QA/UAT deployments and bug fixes.
• Documented and presented the production/support documents for the components developed, when handling over the application to the product support team.

Environment: Informatica Power Center 9.6, Oracle 11g, UNIX, SQL, TOAD, MS Excel.

Confidential, Grand Rapids, Michigan

Sr. IDQ/Informatica Developer

Responsibilities:

• Design and developed end-to-end ETL process from various source systems to Staging area, from staging to Data Marts.
• Worked on Informatica Power Center tools- Mapping Designer, Repository Manager, Workflow Manager and Workflow Monitor.
• Involved in creating data models using Erwin.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Worked with Designer tools like Source Analyzer, Target designer, Mapping designer, Mapplet designer, Transformation Developer.
• Created Mappings and used transformations like Source Qualifier, Filter, Update Strategy, Lookup, Java, Expression, Router, Joiner, Normalizer, Aggregator Sequence Generator and Address validator.
• Developed mappings to load Fact and Dimension tables, SCD Type 1 and SCD Type 2 dimensions and Incremental loading and unit tested the mappings.
• Created PL/SQL programs like procedures, function, packages, and cursors to extract data from Multiple Source Systems.
• Responsibilities include creating the sessions and scheduling the sessions.
• Translated Business specifications into PL/SQL code. Extensively used Explain Plan. Designed, Developed and fine-tuned Oracle Stored Procedures and triggers.
• Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
• Used the PL/SQL procedures for Informatica mappings for truncating the data in target tables at run time. By using NCPDP formats we create and promote standards for electronic data exchange of health care information related to pharmacy services.
• Extracted the multiple vendors data to load into NCPDP format for pharmacy benefit management.
• Prepared SQL Queries to validate the data in both source and target databases.
• Leveraged workflow manager for session management, database connection management and scheduling of jobs.
• Developed various mapping and tuning using Oracle and SQL*Plus in the ETL process.
• Involved in testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Involved in daily Scrum meetings to keep track of the ongoing project status and issues.
• Created control-M jobs and scheduled them.
• Created Test cases and Test Plans for unit testing.
• Involved in Migrating Data from Legacy systems to Oracle database using SQL*Loader
• Worked with Reporting team to Generate reports using Cognos.
• Supported during QA/UAT/PROD deployments and bug fixes.
• Documented and presented the production/support documents for the components developed, when handling over the application to the product support team.

Environment: Informatica Power Center 10.1 , MDM, Oracle 11g, UNIX, PL/SQL, Metadata Manager, SQL* PLUS, TOAD, MS Excel, control-M, Cognos .

Confidential, Ann Arbor, Michigan

Sr. Informatica/IDQ Developer

Responsibilities:

• With the users and making changes to Informatica mappings according to the Business requirements.
• Developed the Informatica mappings using various transformations, Sessions and Workflows. SQL Server was the target database, Source database is a combination of Flat files, Oracle tables, People Soft, Excel files, CSV files etc.
• Worked with IDQ toolkit, Analysis, data cleansing, data matching, data conversion, reporting and monitoring capabilities.
• Handled technical and functional call across the teams.
• Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers and data flow management into multiple targets using Router.
• Optimizing the Mappings and implementing the complex business rules by creating re-usable transformations and Mapplets.
• Worked with Informatica Developer (IDQ) tool to ensure data quality to the consumers.
• Used the Address Doctor Geo-coding table to validate the address and performed exception handling reporting and monitoring the data.
• Created Reference/Master data for profiling using IDQ Analyst tools.
• Experience in Data Quality Analysis, Data Profiling, Data cleansing and Master data management.
• Involved in massive data profiling using IDQ (Analyst tool) prior to data staging.
• Worked with Informatica and other consultants to develop IDQ plans to identify possible data issues.
• Involved in deployment of IDQ mappings to application and to different environments.
• Worked on Data Quality checks for data feeds and performance tuning.
• Data if validated from third party before providing to the internal transformations should be checked for its accuracy (DQ).
• Used Address validator transformation for validating various customers address from various countries by using SOAP interface
• Leveraged workflow manager for session management, database connection management and scheduling of jobs.
• Developed various mapping and tuning using Oracle and SQL*Plus in the ETL process.
• Involved in testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Created Unix Shell Scripts for Informatica ETL tool to automate sessions and cleansing the source data.
• Experience in scheduling of ETL jobs using Autosys, Tidal, Control-M.
• Created Test cases and Test Plans for unit testing.
• Supported during QA/UAT/PROD deployments and bug fixes.
• Created Unix Shell Scripts for Informatica ETL tool to automate sessions and cleansing the source data.

Environment: Informatica Power Center 9.5.1, IDQ, Oracle 11g, UNIX, PL/SQL, SQL* PLUS, TOAD, MS Excel.

Confidential, Dallas, Texas

Senior Informatica Developer

Responsibilities:

• With the users and making changes to Informatica mappings according to the Business requirements.
• Developed the Informatica mappings using various transformations, Sessions and Workflows. SQL Server was the target database, Source database is a combination of Flat files, Oracle tables, People Soft, Excel files, CSV files etc.
• Worked with IDQ toolkit, Analysis, data cleansing, data matching, data conversion, reporting and monitoring capabilities.
• Handled technical and functional call across the teams.
• Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers and data flow management into multiple targets using Router.
• Optimizing the Mappings and implementing the complex business rules by creating re-usable transformations and Mapplets.
• Worked with Informatica Developer (IDQ) tool to ensure data quality to the consumers.
• Used the Address Doctor Geo-coding table to validate the address and performed exception handling reporting and monitoring the data.
• Created Reference/Master data for profiling using IDQ Analyst tools.
• Experience in Data Quality Analysis, Data Profiling, Data cleansing and Master data management.
• Involved in massive data profiling using IDQ (Analyst tool) prior to data staging.
• Worked with Informatica and other consultants to develop IDQ plans to identify possible data issues.
• Involved in deployment of IDQ mappings to application and to different environments.
• Worked on Data Quality checks for data feeds and performance tuning.
• Worked on data analysis to find the data duplication and existed data pattern using a data profiling tool, IDE.
• Data if validated from third party before providing to the internal transformations should be checked for its accuracy (DQ).
• Used Address validator transformation for validating various customers address from various countries by using SOAP interface
• Leveraged workflow manager for session management, database connection management and scheduling of jobs.
• Developed various mapping and tuning using Oracle and SQL*Plus in the ETL process.
• Involved in testing of Stored Procedures and Functions, Unit and Integrating testing of Informatica Sessions, Batches and the Target Data.
• Created Unix Shell Scripts for Informatica ETL tool to automate sessions and cleansing the source data.
• Experience in scheduling of ETL jobs using Autosys, Tidal, Control-M.
• Created Test cases and Test Plans for unit testing.
• Supported during QA/UAT/PROD deployments and bug fixes.
• Created Unix Shell Scripts for Informatica ETL tool to automate sessions and cleansing the source data.

Environment: Informatica Power Center 9.5.1, IDQ, Oracle 11g, UNIX, PL/SQL, SQL* PLUS, TOAD, MS Excel.

Confidential, Phoenix, AZ

Sr. ETL/Informatica Developer

Responsibilities:

• Analyzed the business requirements and functional specifications.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica Power Center 9.1 by using various transformations like Expression, Source Qualifier, Filter, Router, Sorter, Aggregator, Update Strategy, Connected and unconnected look up etc.
• Interacted with the users and making changes to Informatica mappings according to the Business requirements.
• Extensively created Re-usable Transformations and Mapplets to standardized Business logic.
• Mappings, Mapplets and Sessions for data loads and data cleansing. Enhancing the existing mappings where changes are made to the existing mappings using Informatica Power center.
• Used various active and passive transformations like Filter, Router, Expression, Source Qualifier, Java, Joiner, Look up, Update Strategy, Sequence Generator, Rank and Aggregator Transformation.
• Involved in massive data cleansing prior to data staging from flat files.
• Created Use-Case Documents to explain and outline data behavior.
• Implemented slowly changing dimensions Type 2 using ETL Informatica tool.
• Created mapping documents to outline source-to-target mappings and explain business-driven transformation rules.
• Involved in designing and developing logical and physical data models to best suit the requirements.
• Worked with different Caches such as Index cache, Data cache, Lookup cache (Static, Dynamic and Persistence) and Join cache while developing the Mappings.
• Created partitions for parallel processing of data and also worked with DBAs to enhance the data load during production.
• Overall responsibility for the day-to-day operations and oversight of the Metadata Repository.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys.
• Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
• Performed Unit testing on the Informatica code by running in the debugger and writing simple test scripts in the database thereby tuning it by identifying and eliminating the bottlenecks for the optimum performance.
• Involved in fixing invalid Mappings, Testing of Informatica Sessions, Worklets and Workflows.
• Knowledge in working with Informatica Power Exchange.
• Converted business requirements into highly efficient, reusable and scalable Informatica ETL processes.
• Involved, Conducted and participated in process improvement discussions and recommending possible outcomes and focused on production application stability and enhancements.

Environment: Informatica Power Center 9.6/9.5, Oracle 11g, Oracle 12c, Business Objects, DB2, SQL, Hadoop, Erwin 4.0, PL/SQL, Web Services, UNIX shell programming.

Confidential, Pleasanton, CA

Sr. ETL Developer

Responsibilities:

• Used Informatica as ETL tool, and stored procedures to pull data from source systems/ files, cleanse, transform and load data into databases.
• Worked with different Caches such as Index cache, Data cache, Lookup cache (Static, Dynamic and Persistence) and Join cache while developing the Mappings.
• Assisted the team in the development of design standards and codes for effective ETL procedure development and implementation.
• Performed ILIT (Irrevocable Life Insurance Trust) implementation and replacement activities.
• Created detailed Technical specifications for the ETL processes.
• Involved in the mirroring of the staging environment to production.
• Developed the Informatica mappings using various transformations, Sessions and Workflows. SQL Server was the target database, Source database is a combination of Flat files, Oracle tables, Excel files, CSV files etc.
• Extensively used Transformations like Source Qualifier, Expression, Filter, Aggregator, joiner, lookup, Sequence Generator, Router, Sorter and Stored Procedures. And used debugger to test the mappings and fixed the bugs.
• Optimizing the Mappings and implementing the complex business rules by creating re-usable transformations and Mapplets.
• Fixing and tracking mapping defects and implementing with enhancements.
• Developed and tested Stored Procedures for initial bulk loads and batch processing
• Extensively involved in implementing Normal Loads, Bulk Loads, Initial Loads, Incremental Loads, Daily loads and Monthly loads.
• Worked on Modification of Actuate report to upload and run reports on servers.
• Worked on Perl for writing scripts handling flat files such as validating file formats, encryption/decryption, SFTP/FTP etc.
• Used Informatica command task to transfer the files to bridge server to send the file to third party vendor.
• Took part in migration of jobs from UIT to SIT and to UAT
• Involved in writing UNIX shell scripts for Informatics ETL tool to run the Sessions.
• Used mapping parameters and variables for pulling incremental loads from source
• Identified and fixed the Bottle Necks and tuned the Mappings and Sessions for improving performance. Tuned both ETL process as well as Databases.
• Defined the program specifications for the data migration programs, as well as the necessary test plans used to ensure the successful execution of the data loading processes.
• Worked on all phases of multiple projects from initial concept through research and development, implementation, QA, to live production, by strict adherence to project timelines.
• Managed production issues and delivered all assignments/projects within specified time lines.

Environment: Informatica Power Center 8.6, SQL server 2008, SQL, Autosys, UNIX.

Confidential, Bloomington, IL

ETL Informatica Developer

Responsibilities:

• Coordinated with Business Users for requirement gathering, business analysis to understand the business requirement and to prepare Technical Specification documents (TSD) to code ETL Mappings for new requirement changes.
• Designed the ETL processes using Informatica to load data from Oracle, Flat Files, XML Files to target Oracle Data Warehouse database.
• Extensively used Informatica Power Center 8.6.1 to create and manipulate source definitions, target definitions, mappings, mapplets, transformations, re-usable transformations, etc.
• Created sessions and workflow for designed mappings.
• Performed data manipulations using various Informatica Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, and Sequence Generator etc.
• Involved in loading the data from Source Tables to ODS (Operational Data Store) Tables using Transformation and Cleansing Logic using Informatica.
• Designed and developed various mappings focusing on SCD2 and SCD1 implementation.
• Developed PL/SQL procedures for processing business logic in the database.
• Performed Code review to ensure that ETL development was done according to the company’s ETL standard and that ETL best practices were followed.
• Used Update Strategies for cleansing, updating and adding data to the existing processes in the warehouse.
• Migrated the mapping to the testing and production department and introduced the concepts of Informatica to the people in testing department.
• Worked on ETL strategy to store data validation rules, error handling methods to handle both expected and non-expected errors and documented it carefully.
• Designed and developed UNIX shell scripts as part of the ETL process to compare control.
• Involved in Performance Tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.

Environment: Informatica 8.6.1, ORACLE 9i, XML, Windows NT, UNIX Shell Programming.

Confidential

ETL Developer

Responsibilities:

• Involved in creating Technical Specification Document (TSD) for the project.
• Used Informatica for loading the historical data from various tables for different departments.
• Involved in the development of Data Mart and populating the data marts using Informatica.
• Created and maintained metadata and ETL documentation that supported business rules and detailed source to target data mappings.
• Involved in the process design documentation of the Data Warehouse Dimensional Upgrades.
• Developed sessions using Server Manager and improved the performance details.
• Created reusable transformations called mapplets and used them in mappings in case of reuse of the transformations in different mappings.
• Created mapplets and reusable transformations to use across different mappings.
• Created transformations like Aggregate, Expression, Filter, Sequence Generator, Joiner, and Stored procedure transformations.
• Created and managed the global and local repositories and permissions using Repository Manager in Oracle Database.
• Designed and coded maps, which extracted data from existing, source systems into the data warehouse.
• Scheduled Sessions and Batch Process based on demand, run on time, run only once using Informatica Server Manager.
• Managed migration in a multi-vendor supported Server and Database environments.

Environment: Oracle RDBMS 9i, Informatica, JAVA, SQL*Plus Reports, SQL*Loader, XML, Toad.