SUMMARY

• Highly inspired software professional around 7+ years of hands - on experience in analysis, design, development, and deployment of enterprise level data warehouse and integrating ETL.
• Exposure of end-to-end SDLC and Agile methodology using JIRA and Rally Applications.
• Strong Data warehousing experience using Informatica Power Center 10.2/10.1/9.5/9.0.1/8.6 (Source Analyzer, Repository Manager, Mapping Designer, Mapplets, Transformations, Workflow Manager, Task Developer), Power Connect for ETL, OLTP, OLAP, Data Mining, scheduling tool. Worked with heterogeneous source systems like flat files, RDBMS, DWH, parameterizing variables.
• Data modeling knowledge in Dimensional Data modeling, Star Schema, Snowflake Schema, FACT and Dimensions tables, Physical and logical data modeling and DE normalization techniques. Well versed with Star-Schema & Snowflake schemas for designing the Data Marts.
• Have good knowledge in migrating data from Confidential warehouse builder to Informatica power center.
• Using Confidential 11g/10g, SQL, PL/SQL, SQL*Plus, SQL Server 2008/2005. Proficient in working with PL/SQL to write Stored Procedures and triggers, expertise in WinSQL, TOAD. Extensive experience in implementation of transformations, Stored Procedures, and execution of test plans for loading the data successfully into the targets.
• Worked on Informatica Data Quality (IDQ) and Informatica Power Center tool installation and configuring the all the repository services.
• Experience in dimensional data modeling technics such as Star Schema/Snowflake schemas, FACT & Dimensions tables, Physical & Logical Data Modeling.
• Experience in working with UNIX Shell Scripts for automatically running sessions, aborting sessions and creating parameter files.
• Have well versed knowledge in data integration to ETL tools with various subsystems. Experience in working with high volume of data in ELT environments.
• Experience with Healthcare Domain, Financial and Retail sectors.
• Experience in creating various transformations using Aggregator, Look Up, Update Strategy, Joiner, Filter, Sequence Generator, Normalizer, Sorter, Router, and Stored Procedure in Informatica Power Center Designer.
• Experience with high volume datasets from various sources like Confidential, Flat files, SQL Server and XML.
• Excellence in the implementation of Data Warehouse and Business Intelligence using ETL tools like Informatica Power center/Power Mart (Designer, Workflow Manager, Workflow Monitor, and Repository Manager).
• SCD Management including Type 1, 2, De-normalization, Cleansing, Conversion, Aggregation, and Performance Optimization.
• Strong experience in Performance Tuning of sources, targets, transformations and sessions.
• Quick learner and adaptive to new and challenging technological environments.
• Excellent analytical, problem solving, technical, documentation, user training and presentation skills. I am always open to learning new tool/technology.

TECHNICAL SKILLS

Data Warehousing/ETL: Informatica Power Center 10.2/10.1/9.5/9.1, Redpoint

Databases: Confidential 11g/10g/9i, MS SQL Server 7.0/2008, MySQL.

Programming: SQL, PL/SQL, MS SQL, Working Knowledge on UNIX

Environment: Win 2000/2003, Win XP, UNIX, LINUX, Workday

Other tools & Utilities: SQL*Plus, Toad for Confidential, SQL tools, Tidal, MS-Office, XML Spy, Einstein analytics by Salesforce

Scripting languages: Working knowledge on Shell Scripting

DQ Tools: Informatica Data Quality (IDQ)10.2/ 10.1.1/9.6.

Data Modeling: Star Schema Modeling, Snowflake Modeling

Scheduling Tools: Autosys (JILL & GUI), Control-M and Informatica Scheduler

Other Tools: Jira, Rally, Remedy, HP ALM

MDM Packages: Informatica MDM Multi Domain Edition 10.0, 9.7.1, 9.5, 9.1.

PROFESSIONAL EXPERIENCE

Confidential, San Diego, CA

Informatica /IDQ Developer

Responsibilities:

• Create mappings, workflows, mapping specifications, rule specification, mapplets, rules, reference data, LDO, CDO in IDQ.
• Worked on Informatica Developer tools - Informatica Data QualityAnalyst, Informatica Developer tool.
• Create data profiles and scorecards to analyze the data with different measures.
• Assisted in building the ETL source to Target specification documents by understanding the business requirements.
• Coordinate with vendors to troubleshoot and resolve issues.
• Deploying and validating objects to different environments for Scheduled, Batch environment. Used Control-M Tool to Schedule Jobs.
• Hands-on SAP HANA modeling and Analytics (including advanced analytics) experience to deliver new solutions/ improve existing solutions for SAP customers.
• Parsing high-level design specification to simple ETL coding along with mapping standards.
• Document every aspect of the application as a reference for future maintenance and upgrades.
• Experience in resolving on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Formulated the Development standards / Checklists to develop the best ETLs.
• Design and development of UNIX Shell Scripts to handle pre- and post-session processes and also for validating the incoming files.
• Performed Unit testing and maintained test logs and test cases for all the mappings.
• Ensure that the application continues to function normal during software maintenance and Testing.
• Worked with Parameter file for ease of use in connections across Dev/QA/Prod environments
• Testing of ETL jobs that are scheduled for file transfers from Operational Data Stores to designated file systems/directories.

Environment: Informatica Data Quality 10X, Informatica Data Analyst, Control-M Confidential, Autosys, SQL Assistance, SQL Management Studio, Data Governance Tool, DB2, XML, SAP HANA, Confidential 11g, MQ Series, Toad and UNIX Shell Scripts.

Confidential, Louisville, Kentucky

Informatica /IDQ Developer

Responsibilities:

• Worked in Agile methodology, actively participated in all stages of the Workday project lifecycle.
• Created/modified Informatica ETL mappings that map the source data from the various sources to the target database and the data warehouse based on requirement.
• Involved in Migration of Informatica mappings from Confidential to SQL Server.
• Experience working on Informatica MDM to design, develop, test and review & optimize Informatica MDM (Siperian).
• Configured match rule set property by enabling search by rules in MDM according to Business Rules.
• Worked extensively on HTTP Transformation to extract data from API. Parsing Confidential and XML format API from source REST API.
• Write and Optimize complex SQL queries for better performance of ETL jobs.
• Worked on various sources ranging from Flat files, SAP, Confidential and SQL Server.
• Rewriting the code from PL/SQL to T-Sql.
• Gained good experience working with SAP source tables.
• Testing the Informatica Mappings after migrating to the SQL Server database against the Confidential Production Data warehouse.
• Create mappings, workflows, mapping specifications, rule specification, mapplets, rules, reference data, LDO, CDO in IDQ.
• Work with different Data Governance teams for IDQ code promotion to across all the environments
• Documenting Data Quality metrics/dimensions like Completeness, Conformity, Accuracy, & Consistency.
• Worked on various transformations such as expression, Look Up, Joiner, Filter, Router and Update Strategy Transformations.
• Deployed new MDM Hub for portals in conjunction with user interface on IDD application.
• Improved the performance of Mappings by replacing the Confidential sequences with Informatica sequences.
• Designed, Installed, Configured core Informatica/Siperian MDM Hub components such as Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter, Data Modeling.
• Extensively working on the performance tuning of the programs, ETL Procedures and processes.
• Designed basic UNIX scripts and automated it to run the workflows daily, weekly and monthly.
• 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.

Environment: Informatica Power Center 10.2s, Hotfix 4, Informatica Power Exchange, Confidential 10g, SQL Server, Flat files, PL/SQL, SQL, T-Sql, SQL*Plus, TOAD, SAP R/3, Windows XP Professional, UNIX, MDM Packages Informatica MDM Multi Domain Edition 10.0.

Confidential, Irvine, CA

Informatica/IDQ Developer

Responsibilities:

• Set priorities and monitor quality and SLAs.
• Created Joins, Macros and Secondary indexes for faster retrieval of data.
• Owns and manages the Production support services engagement.
• Worked closely with the Workday testing team to understand the business requirement, design document, test scenarios, and test scripts.
• Analyze, design, develop, implement and enhance Data warehousing applications to meet user changing needs and train users in the application, as necessary.
• Performance Optimization of Data Integration routines.
• Interact with Client process owners/end users to seek clarifications on the open cases/tickets.
• Establish, evaluate policies, methodologies and procedures.
• Worked on data cleansing using the cleanse functions in Informatica MDM.
• Extensively used ETL Processes to load data from various source systems such as DB2, SQL Server, Flat Files and XML Files into target system Confidential by applying business logic on transformation mapping for inserting and updating records when loaded.
• Profoundly worked with testing team in identifying the 'code defects' raised from SIT/UAT resources.
• Used IDQ transformation like labeler, standardizer, parser, address doctor, Match, Exception transformations for cleanse and standardization.
• Involved on Installation and Configuration of IDQ environment.
• Performed IDQ code deployment and Code integration with Informatica power center.
• Responsible for release planning and coordination.
• Worked on REMEDY and HP service managers for updating and maintain the daily defects and the track of status of the defects.
• Wrote UNIX Shell scripts for Informatica Pre-sessions, Post-sessions and Autosys scripts for scheduling the jobs (workflows).
• Publishing Data using Message Queues to notify external applications on data change in MDM Hub Base Objects.
• Review work done by peers before delivering to Client.
• Ensure System / Integration tests of various objects before delivery Responsible for identifying and presenting opportunities for service improvement.
• Closely worked with the database developer to ensure the database changes are implemented as per the requirement.

Environment: Informatica Power Center 9.1.1, Informatica Multi Domain MDM 9.5, IDQ 9.1, Confidential 11i, UNIX, Windows XP, Flat Files, Autosys, Sql Server 2005/2008R2, TOAD.

Confidential, Redmond

ETL/Informatica Developer

Responsibilities:

• Design ETL flows according to the business requirements.
• Generate XML files using the XSD definition and then copy the files into local UNIX server.
• Writing PL-SQL procedures and SQL queries and run them using the ETL batch framework used extensively in this project.
• Creating Health checks between source and target tables to match the record counts.
• Tuning long running SQL queries by creating profiles with the help of DBA, use of WITH clause and HINTS in the Sql overrides and scripts.
• Use of TIDAL tool for scheduling the ETL batches.
• Worked closely with the Business Analysts for requirements gathering, Data analysis etc.
• Implemented SCD type 2 dimensions to represent historical data.
• Partitioning, creating unique index on tables to increase the performance.
• ETL mappings to source FLAT FILES and load them into relational tables.
• Generated and Validated Workday report created analysis report and dashboard for Management review.
• Creating Impact analysis, Technical specification and Design Documentations.
• Worked on ALM quality center tool to update/ track defects raised by QA/UAT resources.
• Review the data model, DDL changes performed by data modelers and propose any additional required changes.
• Guiding offshore team from requirements gathering till the QA phase.
• Creating Informatica deployment groups to migrate the code to higher environments.

Environment: Informatica Power center 9.x, Confidential 11i, Tidal, OBIEE, Informatica Data Quality, UNIX, and HP ALM Quality center, WinSCP.

Confidential

ETL/Informatica Developer

Responsibilities:

• Gathered user Requirements and designed Source to Target data load specifications based on Business rules.
• Used Informatica power center 8.6.1 to migrate the data from OLTP to data warehouse.
• Used Informatica Power Center 8.6 for extraction, loading and transformation (ETL) of data in the DataMart.
• Used Informatica workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Implemented “Slowly changing dimension type 2” to represent historical data correctly.
• Designed and developed ETL Mappings to extract data from flat files, MS Excel and Confidential to load the data into the target database.
• Developing several complex mappings in Informatica a variety of Power Center transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using Informatica Power Center.
• Extensively used ETL processes to load data from various source systems such as DB2, SQL Server and Flat Files, XML files into target system applying business logic on transformation mapping for inserting and updating records when loaded.
• Responsible for design and developing Confidential BTEQ scripts, MLOAD based on the given business rules and design documents.
• Experience in migration Informatica objects from 8.6 to 9.x.
• Experience in Informatica upgrade testing, troubleshoot and resolve issues.
• Created complex mappings in the designer and monitored them. The mappings involved extensive use of Aggregator, Filter, Router, Expression, Joiner, Union, Normalizer and Sequence generator transformations.
• Ran the workflows on a daily and weekly basis using Active Batch Scheduling tool.
• Examined the workflow log files and assigning the ticket to the Informatica support based on the error.
• Experience in developing Unix Shell Scripts for automation of ETL process.
• Performed operational support and maintenance of ETL bug fixes and defects.
• Maintained the target database in the production and testing environments.
• Supported migration of ETL code from development to QA and QA to production environments.
• Migration of code between the Environments and maintaining the code backups.
• Designed and developed Unix Shell Scripts, FTP, sending files to source directory & managing session files.
• Done extensive testing and wrote queries in SQL to ensure the loading of the data.
• Developed PL/SQL code at the database level for the new objects.

Environment: Informatica Power Center 8.6, Confidential 10g/9i, PL/SQL, Flat files, XML, MS Access, SQL Server 2008.