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 oracle warehouse builder to Informatica power center.
• Using Oracle 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 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 Oracle, 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: Oracle 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 Oracle, 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, Snow Flake 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, 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 Oracle 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 JSON 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, Oracle and SQL Server.
• Rewriting the code from PL/SQL to T-Sql.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Gained good experience working with SAP source tables.
• Testing the Informatica Mappings after migrating to the SQL Server database against the Oracle 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 Oracle 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, Oracle 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’s 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 Teradata 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, Oracle 11i, UNIX, Windows XP, Flat Files, Autosys, Sql Server 2005/2008R2, TOAD.

Confidential, Redmond, Washington

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, Oracle 11i, Tidal, OBIEE, Informatica Data Quality, UNIX, and HP ALM Quality center, WinSCP.