PROFESSIONAL SUMMARY:

• Having 8 years of IT experience in the implementation of Data Warehousing applications using Informatica .
• Well versed with Data warehousing Architecture on the Design, Development, Extraction, Transformation and Loading of data using Informatica Power Center as an ETL tool.
• Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment .
• Expertise in design and implementation of Slowly Changing Dimensions (SCD) type1, type2, type3.
• Experienced in loading data, troubleshooting, debugging mappings, performance tuning of Informatica (Sources, Targets, Mappings and Sessions) and fine - tuned transformations to make them more efficient in terms of session performance.
• Database experience using Oracle 11g/10g/9i/8.x, MS SQL Server 2000/2008
• Strong experience using SQL, PL/SQL Procedures/Functions, Triggers and Packages.
• Experience in UNIX Operating System and Shell scripting.
• Experienced with Integration of data from heterogeneous sources such as Relational tables, flat files, MS Excel, and XML files.
• Good understanding of Views, Synonyms, Indexes, Joins, and Sub-Queries.
• Experienced in all data processing phases, from the Enterprise Model, Data Model (Logical and Physical Model), Data Warehousing (ETL).
• Experience in building the Data warehouse using Ralph-Kimball methodology.
• Proficient in writing documents , preparing presentations and presenting them .
• Excellent skills in tuning the ETL mappings in Informatica.
• Experience in implementing update strategies, incremental loads and Change Data capture.
• Extensive experience using database tool such as SQL *Plus, SQL Developer and TOAD
• Excellent communication, presentation, project management skills, a very good team player and self-starter with ability to work independently.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.6.1 . 9.5.1/9.1.0/8.6.1/8.5/8.1, Informatica Power Exchange, DIAL (HP s ETL tool)

Databases: Oracle 7i/8i/9i/10g/11g, DB2, MS SQL Server 2000/2005/2008, Teradata V11/V12, Netezza

Modeling Tools: ERwin, Visio, IBM Rational Rose

Scheduling Tools: Autosys, Tidal

Languages: SQL, PL/SQL, Unix Shell Scripting, C, C++, XML

Development Tools: Visual Studio .net/2005

Operating System: Windows 9x/NT/2000/XP/7, UNIX

Office Applications: MS-Office 97/2000/XP/ 2007/2010/2013

Other Tools: SQL *Loader, TOAD, HP Database Manager, DB Visualizer, Aginity Work Bench

PROFESSIONAL EXPERIENCE:

Confidential, Chicago, IL

ETL Developer

Responsibilities:

• Part of Scrum team where we were assigned multiple tickets (tasks) pertaining to ETL and ELT developments.
• Migrated big batch of legacy data to new the new Data Warehouse which was part of Big Data Project.
• Built multiple queries and complex SQL's on Netezza environment.
• Creation of ETL and ELT code in Informatica to manage data integration tasks within the project team.
• Created Autosys scripts to run ETL Informatica and other shell jobs.
• Solutions need to be highly efficient and functional to deal with high volumes of data.
• Scheduling jobs using Autosys, jobs execute multiple environment tools like Informatica and DB Scripts.
• Communicate with the DA's for new solutions in implementing robust ETL's and ELT platforms.
• Assist in the continuing evolution of solutions ensuring we are on the vanguard of technologies.

Environment: Netezza, Informatica 9.6.1, Autosys, Aginity work bench, Archipelago testing tool.

Confidential, Chicago, IL

ETL Developer

Responsibilities:

• Review business requirements and design technical solution as per the requirements.
• Responsible for the operational support of Dial environment including creating the Mater ID aka MID, triggering the files by Dial cataloger, analyzing dependencies and monitoring the jobs
• Supports and enhances existing Dial environment and develops new, complex ETL processes to support additional design, development of the Enterprise Data Warehouse
• As per written functional specifications creating database tables, SQL queries
• Designs, develops and implements complex ETL processes in DIAL (HP’s ETL tool)
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.
• Performed Unit testing and System Integration testing in Sandbox and in DEV environments
• Involved in peer code review for better performance
• Optimize SQL queries for better performance
• Create mapping in Informatica using various transformations
• Create ETL technical specifications document
• Create Performance review document
• Using workflow manager for creating, validating, testing and running the Sequential and Concurrent batches and sessions and scheduling them to run at specified time with required frequency
• Working on DIAL. Creating different scripts as needed to load data from landing zone to reporting zone
• Involved in the production work

Environment: Informatica Power Center 9.5.1, DIAL(HP’s ETL tool), Oracle 11g, Neoview, Seaquest, SQL Server 2008, HP Database Manager, DbVisualizer

Confidential, Columbia, MD

Informatica Developer

Responsibilities:

• Involved with Business Analysts in gathering requirements.
• Became aware of various HIPAA functionalities.
• Involved in designing Logical/Physical Data Models.
• Used forward engineering to create a Physical Data Model with DDL, based on the requirements from the Logical Data Model.
• Developed PowerCenter mappings to extract data from various databases, Flat files and load into Data Mart using the Designer tool.
• Created complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Union, Expression and Aggregator transformations to pipeline data to DataMart. Also, made use of variables and parameters.
• Used Informatica Workflow Manager for Creating, Running Sessions and scheduling them to run at specified time.
• Created reusable transformations called mapplets and used them in mappings in case of reuse of the transformations in different mappings.
• Created PL-SQL procedures to detect CDC methodologies and developed Slowly Changing Dimension for Type 1 and Type 2.
• Created Indexes, primary keys and checked other performance tuning at data base level.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Worked with Change data captupe option to enhance business agility
• Developed Oracle PL/SQL Stored Procedures. Performance and fine Tuning of SQL & PL/SQL stored procedures and Testing.
• Performed Unit testing by comparing the source and target data

Environment: Informatica PowerCenter 9.1, Oracle 10g, Teradata V11, TOAD, PL/SQL Developer, SQL * Loader, Erwin r7.1, SQL, PL/SQL, UNIX Shell Scripts

Confidential, Austin, TX

ETL Developer

Responsibilities:

• Interacts with client and onsite coordinator to evaluate technology options/ requirements analysis and day-to-day work progression.
• Involved in data transfer from OLTP systems forming the extracted sources.
• Understanding the business process, data collection and analysis various source systems and using TERADATA.
• Performed change data capture (CDC) process using SCD-I and SCD-II implementations.
• Distributed data residing in heterogeneous data source is consolidated into target enterprise Oracle data warehouse and database.
• Maintained the existing mappings and workflows as per business requirements.
• Designed, developed, and maintained number of mappings and also tuned for better performance.
• Created UNIX shell Scripts for editing data in the flat files and to FTP data from remote server.
• Created Source-To-Target mapping documents and Data Migration Documents.
• Used Qlikview to integrate back-end analytic calculations with front end user interface.
• Developed Scorecard report using oracle analytical functions based on the Marketing Data Mart.
• Used Informatca Power Exchange for Installation of SAP
• Wrote stored procedures for doing CDC in the fastest way possible on huge tables - was reused throughout the organization.
• Advocated partitioning of tables and wrote partition exchange stored procedures and package.
• Was instrumental in creating materialized views as summary tables

Environment: Informatica PowerCenter 8.1, LINUX, Oracle 10g, SQL Server 2005, DB2, Netezza, PL/SQL, Autosys

Confidential, Chicago, IL

Informatica/ ETL Developer

Responsibilities:

• Fast paced project involving understanding the business, current processes and requirements.
• Gathered Requirements from users, translated user inputs into ETL design documents.
• Performed Business Analysis, Designed, Developed, Tested and Implemented Informatica transformations and Workflows for extracting the data from the multiple legacy systems.
• Developed complex mappings using multiple sources and targets in different databases, flat files.
• Used various transformations like unconnected lookup, connected lookup, aggregator, rank, joiner, stored procedure, etc.
• Applied performance tuning on targets, sources, mappings, sessions and database to improve system performance.
• Created and Executed UNIX shell scripts and PL/SQL procedures, Pre-session and Post- Session Scripts to ensure timely, accurate processing and ensure balancing of job runs.
• Performed Unit testing of Informatica Mappings, Workflows, Mapplets and tuned them to improve performance.
• Worked with the team to create reusable ETL solutions to achieve enormous improvements.
• Assisted in the process of preparation of documenting Informatica transformation Development Standards.
• Generated Cognos reports to help QA team achieve quick and efficient turnarounds.
• Restructured older processes to allow for changes to newly implemented data model and worked on SAP Interface

Environment: Informatica Power Center 8.6.1/8.1.1, PL/SQL, Oracle 10g, DB2, Windows 2000, SQL Server, Tidal, Linux

Confidential, New York, NY

ETL Developer

Responsibilities:

• Involved in identifying business requirements and help decide the architecture.
• Involved in developing mapping to populate data from various systems such as flat files, Oracle, etc. to the data warehouse.
• Developed various ETL processes for different business units/product streams.
• Debugging and solving issues with the exiting mappings.
• Restructured existing code for better performance.
• Involved in parameter files creation for all the staging mapping being developed for the different ETL objects.
• Was involved in writing basic queries against the repository to extract run information.
• Involved in peer code reviews and discuss opportunities for betterment.
• Performed Data Reconciliation.
• Coordinate extensively with the on-site ETL lead (of outsource model) for design, deployment and testing activities.
• Optimize SQL queries for better performance

Environment: Informatica Power Exchange, UNIX, Oracle 9i, TOAD, PL/SQL, Autosys, MS Office

Confidential, Pittsburgh, PA

ETL Developer

Responsibilities:

• Design and Unit test different Modules and Applications.
• Review and approve the Master test plan and test cases.
• Approve completion of integration testing.
• Physical and logical data modeling using ERWIN.
• Wrote triggers and stored procedures in PL/SQL.
• Involved in the requirement gathering and analysis in support of data warehousing efforts.
• Involved in Designing the Data warehouse using Informatica ETL tool.
• Performing unit testing on the data and reports validation.
• Wrote re-usable mapplets to create Error handling routines.
• Performance tune ETL code

Environment: Informatica Power Exchange, UNIX, Oracle 8i, TOAD, SQL*plus, SQL* Loader, MS Office.