PROFESSIONAL SUMMARY:

• Over 5+ years of extensive experience in Data migration and expertise in use of Informatica Power Centre.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center.
• Hands - on experience across all stages of Software Development Life Cycle (SDLC) including business requirement analysis, data mapping, build, unit testing, systems integration and user acceptance testing.
• Solid experience in Informatica Power Center (Versions 10.x/9.x/7.x) including Designer, Workflow Manager, Workflow Monitor, Repository Manager, Repository Server Admin console.
• Experience with dimensional modeling using star schema and snowflake models.
• Experience in identifying bottlenecks inETLProcesses and Performance tuning of applications using Database Tuning, Partitioning, Index Usage, and Aggregate Tables, Session partitioning, Load strategies, commit intervals and transformation tuning.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger), Power Connect as ETL tool on Oracle, DB2 and SQL Server Databases.
• Sound knowledge of database architecture for OLAP and OLTP applications, Data analysis, Data Cleansing and ETL processes.
• Expertise in OLAP/OLTP System Study, Analysis and ER Modeling, developing database Schemas like Star Schema, Snowflake Schema, Conforming Dimensions and Slowly Changing Dimensions used in relational, dimensional and multi-dimensional modeling.
• Experience in performance tuning of Sources, Targets, Mappings, Sessions and Workflows.
• Working experience with business SMEs on developing teh business rules for cleansing. Applied business rules using Informatica Data Quality (IDQ) tool to cleanse data.
• Generated Business Requirement documents (BRD), Functional Specification design documents (FSD) and Functional Requirement Documents (FRD).
• Experience in SQL Tuning and creation of indexes for faster database access, better query performance in Informatica by creating Explain Plan, SQL hints for query and indexing teh required columns
• Experienced in Designing and developing complex mappings to extract data from diverse sources including Oracle, SQL server, MS access, flat files, RDBMS tables, XML files, legacy system files.
• Experience working in AGILE METHODOLOGY and ability to manage change TEMPeffectively.
• Excellent analytical and communicational skills, team player, quick learner, organized, resilient and self-motivated.

TECHNICAL SKILLS:

ETL Tools: Informatica 10.x/9.x/8.x, OLAP, OLTP, SSIS, SSRS, Informatica IDQ, MDM

Data Reporting Tools: Tableau, Power BI, Erwin, TeradataOracle, Teradata, MS SQL Server 2012/2014

Languages: SQL, PL/SQL, UNIX JSON

DB Tools: TOAD, SQL Developer

Operating Systems: Windows 7 2003/XP/2000, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

ETL Developer

Responsibilities:

• Involved in system study, analyze teh requirements by meeting teh client and designing teh complete system.
• Worked with business team to gather requirements.
• Developed mappings/Reusable Objects/Transformation by using mapping designer, transformationdeveloperand mapplet designer in Informatica Power Center.
• Created reusable transformations and mapplets and used them in mappings.
• Used Informatica Power Center for extraction, loading and transformation (ETL) of data in teh data warehouse.
• Created Mapplets, Reusable Transformations, Reusable Session/Email/Command Tasks to increase teh code reusability and maintenance
• Responsible for developing and maintaining ETL jobs, including ETL implementation and enhancements, testing and quality assurance, troubleshooting issues and ETL/Query performance tuning.
• Writing technical documentation and routine production ETL process support.
• Worked on Informatica Power Center tools - Repository Manager, Designer, Workflow Manager & Workflow Monitor.
• Used Informatica Power Center for extraction, loading and transformation (ETL) of data in teh data warehouse
• Utilization of Informatica IDQ to complete initial data profiling and matching/removing duplicate data.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, SQL, Union, Lookup, Joiner, XML Source Qualifier, Unconnected lookup transformations.
• Created E-mail notifications tasks using post-session scripts.
• Identifying performance issues in teh code and tuning it to complete teh jobs within teh given SLA time.
• Performance tuning at Informatica and database levels depending on teh bottlenecks identified with teh jobs.
• TEMPEffectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Designing, developing, maintaining and supporting Data Warehouse or OLTP processes via Extract, Transform and Load (ETL) software using Informatica, Shell Scripts.
• Used Informatica PowerCenter 10.x,9x/8.6.1/8.5 and its all features extensively in migrating data from OLTP to Enterprise Data warehouse.
• Maintained ETL release document for every release and migrated teh code into higher environments through deployment groups.
• Defined and designed teh Data Acquisition, Transformation, and Data Cleansing approach for teh MDM implementation
• Executed Autosys command/box to run teh Informatica workflows
• Created Complex ETL Packages using SSIS/SSRS to extract data from staging tables to partitioned tables with incremental load.
• Created change request before code deployment into production to get required approvals from business.
• Created weekly project status reports, tracking teh progress of tasks according to schedule and reported any risks and contingency plan to management and business users.
• Managed post production issues and delivered all assignments/projects within specified time lines.

Environment: Informatica Power Center 10.x, Informarica IDQ, MDM, Autosys, Oracle, MS SQL Server, SSIS, SSRS, Data Cleansing, Shell Scripts, Windows, UNIX.

Confidential, FL

ETL Developer

Responsibilities:

• Involved in Business Analysis, requirements gathering and logical & physical data modeling.
• Involved in analysis, design and development ofETLprocess.
• CreatedETLhigh level design documents and Informatica mapping specifications. Supported Informatica workflows to extract data from Callidus On-premise to Callidus cloud environment and vice versa for monthly pipeline and report generation process.
• Developed ETL processes detailing teh various extraction patterns to handle interfaces such as Queues, database pulls, flat files.
• Used workflow monitor to monitor teh jobs, reviewed session/workflow logs dat were generated during each session to resolve issues and used Informatica debugger to identify issues in mapping execution.
• Different sessions were run in teh Workflow Manager and teh log was studied to modify teh mappings to obtain correct result from teh transformation.
• Extracted data from Oracle and SQL Server then used Teradata for data warehousing. Involved in extraction, Transformation and Loading of teh data Using Informatica Power Center.
• Developed ETL processes to load various ODS tables, Dimensions and Facts.
• Worked on Informatica tools Source Analyzer, Warehouse designer, Mapping Designer and Transformation developer.
• Supported monthly data load activity using SSIS for Account Assignment System.
• Maintained ETL release document for every release and migrated teh code into higher environments through deployment groups.
• Performed data analysis based on teh source systems and existing OLTP database systems
• Developed OLAP models for analysis of facts, measures, dimensions and hierarchies.
• Involved in writing SQL Stored procedures and Shell Scripts to access data from various sources.
• Scheduled and performed data transfers using SSIS including filtering to teh appropriate data mart for data analysis.
• Developed and edited many complex reports with SSRS.
• Performed System, Integration testing and supported User Acceptance Testing.
• Managed stakeholder communication and validated teh fixed issues in order to ensure support availability as per agreed SLAs.
• Extracted data from Oracle and SQL Server then used Teradata for data warehousing.
• Created weekly project status reports, tracking teh progress of tasks according to schedule and reported any risks and contingency plan to management and business users.

Environment: Informatica Power Center 10.x/9.x, IDQ, OLAP, MS SQL Server, Business Objects, MS Access, Teradata, SSIS, SSRS, Oracle and Windows.

Confidential, Overland Park, KS

ETL Developer

Responsibilities:

• Involved in Business Requirements analysis and design, prepared and technical design documents.
• Developed complex Informatica mappings to load teh data from various sources using different transformations like source qualifier, connected and unconnected look up, update Strategy, expression, aggregator, joiner, filter, normalizer, rank and router
• Developed mapplets and worklets for reusability.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command, Decision.
• Maintained and updated legacy data importing and exporting applications. Tuned and streamlined existing ETL applications.
• Interacted with business analysts, data architects, application developers to develop a data model.
• Involved in teh warehouse design using a Star Schema.
• Designed and created ETL packaging, deployment, and automation processes from teh ground up to getthe team past running things by hand.
• Involved in building teh ETL architecture and Source to Target mapping to load data into Data warehouse.
• Carried out changes into Architecture and Design of Oracle Schemas for both OLAP and OLTP systems.
• Designed tables required for teh execution of teh ETL processes using ERwin.
• Involved in creating ETL objects and automation teh process to run daily and monthly Jobs.
• Joined relational tables existing in separate database using Joiner Transformation.
• Involved in Performance Tuning of sources, targets, mappings and sessions.
• Documentation of Technical specification, business requirements, functional specifications for teh development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into various tables.
• Performed data analysis based on teh source systems and existing OLTP database systems.
• Performed unit testing to validate mappings and populate teh database. Responsible for halping Production Support team for failures dat cannot be handled by them.

Environnent: Informatica Power Center, OLAP, OLTP, Star Schema, Erwin, Oracle, UNIX, TOAD, SQL Server, Windows.

Confidential, San Francisco, CA

ETL Developer

Responsabilités:

• Prepared technical design/specifications for data Extraction, Transformation and Loading.
• Worked on Informatica Utilities Source Analyzer, warehouse Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Analyzing teh sources, transforming data, mapping teh data and loading teh data into targets using Informatica Power Center Designer.
• Created reusable transformations to load data from operational data source to Data Warehouse and involved in capacity planning and storage of data.
• Developed complex mappings such as Slowly Changing Dimensions Type II-Time stamping in teh Mapping Designer.
• Used various transformations like Stored Procedure, Connected and Unconnected lookups, Update Strategy, Filter transformation, Joiner transformations to implement complex business logic.
• Used Variables and Parameters in teh mappings to pass teh values between mappings and sessions.
• Created Stored Procedures, Functions, Packages and Triggers using PL/SQL.
• Implemented restart strategy and error handling techniques to recover failed sessions.
• Used Unix Shell Scripts to automate pre-session and post-session processes.
• Did performance tuning to improve Data Extraction, Data process and Load time.
• Wrote complex SQL Queries involving multiple tables with joins.
• Implemented best practices as per teh standards while designing technical documents and developing Informatica ETL process.
• Involved in building teh data mapping exercise between Source system & Target databases.

Environment: Informatica Power center, Oracle, Unix Shell Scripts, SQL, PL/SQL, Flat files, Windows XP.