SUMMARY:

• Over 6 plus years of experience in IT industry with in - depth understanding of SDLC with Agile methodologies.
• Data Warehousing: strong Data warehousing experience using Informatica Power Center 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: Data modeling knowledge in Dimensional Data modeling, Star Schema, Snowflake Schema, FACT and Dimensions tables, Physical and logical data modeling and Denormalization techniques.
• Have good knowledge in migrating data from oracle warehouse builder to Informatica power center.
• Database: 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 (Tool for Oracle Application Developers).
• Hands on experience using query tools like SQL Developer, TOAD.
• 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.
• Very strong in the Analysis, Design, Development, testing and Implementation of Data Warehouse Applications. Well versed with Star-Schema & Snowflake schemas for designing the Data Marts.
• Extensive experience in implementation of transformations, Stored Procedures and execution of test plans for loading the data successfully into the targets.
• 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/PowerMart (Designer, Workflow Manager, Workflow Monitor, Repository Manager)
• SCD Management including Type 1, 2, De-normalization, Cleansing, Conversion, Aggregation, and Performance Optimization.
• Hands on experience in writing, testing and implementation of stored procedures, Functions using PL/SQL.
• Experience handling large sets of data using Informatica.
• Strong experience in Performance Tuning of sources, targets, transformations and sessions.
• Quick learner and adaptive to new and challenging technological environments.
• There is never an exact right tool/technology to use and I am always open to learning new tool/technology.

TECHNICAL SKILLS:

Data Warehousing/ETL: Informatica Power Center 10.X,9.5/9.1, Informatica Data Quality

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

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

Scripting languages: Working knowledge on Shell Scripting

PROFESSIONAL EXPERIENCE:

Confidential, Tempe, AZ

ETL/Informatica Developer

Responsibilities:

• Prepare TDD document according to the High-level requirements.
• Leading off shore team and splitting work between onsite and offshore.
• Participate in requirement gathering session.
• Use existing PL-SQL procedures to aggregate the GL amounts.
• Extract the final data to a .csv file and then place them in the landing zone using shell script.
• Assisting business users if they see a mismatch in the GL numbers.
• Developing Health Checks between source and target tables for the amount comparison between the elements.
• Initiating CFT process between two servers to transfer the files securely.
• Participate in QA triage calls and discuss on the open defects.
• Performance tuning of SQL queries using oracle hints, creating indexes on the tables etc.

Environment: Informatica Power center 9.x,Informatica Data quality, Oracle 11i, Tidal, UNIX, and HP ALM Quality center, Winscp.

Confidential, SanFrancisco, CA

ETL/Informatica Developer

Responsibilities:

• Develop reports on Einstein analytics tool according to the business user requirement.
• Working on the production failure tickets, finding the root cause and then assigning back to the development team for the fixture.
• Scheduling Einstein analytics reports.
• Checking for the failure batches using TIDAL and metadata scripts which runs on the back end of tidal to see for the latest failures.
• Performance tuning of ETL jobs.

Environment: Informatica Power center 9.x, Oracle 11i, Tidal, UNIX, Einstein Analytics, Winscp.

Confidential, San Ramon, CA

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.
• 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.

Confidential, Dallas, TX

ETL/Informatica 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.
• 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.
• 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.
• 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.
• 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, IDQ 9.1, Oracle 11i, UNIX, Windows XP, Flat Files, Autosys, Sql Server 2005/2008R2, TOAD.

Confidential, Irving, Texas

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 Oracle 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 Teradata 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, Oracle 10g/9i, PL/SQL, Flat files, XML, MS Access, SQL Server 2008.