SUMMARY

• Informatica Admin/Developer with 7+ years of IT experience in the Analysis, Design, Development, Testing and Implementation of business application systems.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.
• Strong Data WarehousingETL/MDMexperience of using Informatica MDM/IDQ, PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor and Server tools - Informatica Server, Repository Server manager.
• Experienced in using ETL tools including Informatica PowerCenter, Power Mart, Power Exchange, Workflow Manager, Repository Manager, Administration console and Informatica Data Quality (IDQ).
• Installing and configuring components on Informatica MDM in Windows/Linux.
• Experience in upgrading the Informatica MDM from 9.7 version to 10.2 and 10.2 to 10.4.
• Performing all the Informatica Admin activities on a day-to-day basis, creating users, assigning roles, providing the required permissions, creating connection, running the jobs, managing the loads, patching activities on the server.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
• Experience with dimensional modeling using star schema and snowflake models.
• Vast experience in Designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc.
• 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 asETL tool on Oracle, DB2 and SQL Server Databases.
• Experience in Data Extraction, Transforming and Loading (ETL) from multiple sources like Excel, MS Access, XML, Oracle and DB2 to MS SQL Server using SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
• Good experience in using Multidimensional Expressions (MDX) for querying and manipulating the multidimensional data stored in OLAP.
• Experience in creating UNIX shell scripts to run the Informatica workflows and controlling theETLflow.
• Experienced in writing SQL, PL/SQL programming, Stored Procedures, Functions, Triggers, Views and Materialized Views.
• Experience with scheduling tools (eg: Control M, ESP).
• Highly motivated team player with analytical, organizational, and technical skills, unique ability to adapt quickly to challenges and changing environment.
• Excellent communication and presentation skills works well as an integral part of a team, as well as independently, intellectually flexible, and adaptive to change.
• Good Understanding of technical trends, architectures and highly motivated to know more

TECHNICAL SKILLS

Package & ETL Tools: Informatica Power Center, IDQ, OBIEE, Siebel, TOAD, OLAP, OLTP.

Monitoring Tools: Informatica Admin, Control-M

Databases: SQL, Oracle, DB2, Sybase, Teradata, Siebel.

Languages: SQL, PL/SQL, TSQL, UNIX Shell Scripting.

Data Modeling: Erwin, Star-Schema Modeling, Snowflakes Modeling.

Methodologies: Agile, Waterfall.

Operating System: Unix, Win NT, MS-DOS, Solaris.

PROFESSIONAL EXPERIENCE

Confidential, TX

Informatica/MDM Admin

Responsibilities:

• Experience in 24/7 Support related to Administration tasks (Emergency Deployments, FATAL ERRORS on the Informatica Server, unexpected Informatica services failures, Repository issues etc.).
• Day to day monitoring/administration of Control-M, Informatica and MDM and its components, production batch schedules and ensure continuity of business services.
• Processing cycles and utilize Control-M utilities to forecast and plan customer requests and take appropriate action to add, delete, or modify production, test, system, user applications.
• All Control-M run control calendars to ensure run date accuracy.
• Creating run books in confluence for the scheduled jobs to support.
• Creating cases to Informatica Inc. related to any MDM/Informatica product usability and install issues.
• Participate in exit review meetings before the change request approval.
• Created weekly project status reports, tracking the progress of tasks according to schedule and reported any risks and contingency plan to management and business users.
• Configured Informatica Data Quality services like Model Repository service, Data Integration Service, Analyst service and Content Management Service.
• Monitoring the Jobs and sever space availability and CPU Process, troubleshoot problems, and in corporate techniques for data auditing and quality. worked with tools like JIRA and Incident/Change request process.

Environment: Informatica 10.5.2, MS SQL Server, Control-M, MDM RHEL, Windows, UNIX.

Confidential, Denver CO

Responsibilities:

• Participate in design and analysis sessions with business analysts, source-system technical teams, and end users.
• Responsible for developing and maintainingETLjobs, includingETLimplementation and enhancements, testing and quality assurance, troubleshooting issues andETL/Query performance tuning
• Designing, developing, maintaining, and supporting Data Warehouse or OLTP processes via Extract, Transform and Load (ETL) software using Informatica.
• Manage and expand currentETLframework for enhanced functionality and expanded sourcing.
• Translate business requirements intoETLand report specifications. Performed error handling using session logs.
• Worked on Power Center Tools like designer, workflow manager, and workflow monitor and repository manager.
• Done Code reviews ofInformatica MDM/ETLand SQL processes. Worked on upgrading Informatica from version 9.x to 10.x.
• Identifying performance issues in the code and tuning it to complete the jobs within the given SLA time.
• Performance tuning at Informatica and database levels depending on the bottlenecks identified with the jobs.
• Developed mappings using Informatica Power Center Transformations - Lookup (Unconnected, Connected), Filter, Expression, Router, Joiner, Update Strategy, Aggregator, Stored Procedure, Sorter, and Sequence Generator.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Worked with Informatica Data Quality (IDQ) toolkit, analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ.
• Experienced in analyzing the BI needs, Interpreting Business user requirements and translating them into reports.
• Performed Relational Data Modeling, ER Diagrams (forward & reverse engineering), dimensional modeling, OLAP multidimensional Cube design & analysis, define slowly changing dimensions and surrogate key management.
• Worked with the testing team to resolve bugs related to day one ETL mappings before production.
• Maintained ETL release document for every release and migrated the code into higher environments through deployment groups.
• Worked with Pre-Session and Post-Session UNIX scripts for automation of ETL jobs using CONTROL-M schedulers and involved in migration deployment of ETL codes from development to production environment.
• Created change request before code deployment into production to get required approvals from business.
• Created weekly project status reports, tracking the progress of tasks according to schedule and reported any risks and contingency plan to management and business users.

Environment: Informatica Power Center 8.6,9.0,9.1,9.5, Informatica Cloud, IDQ, OLAP, Oracle 11g, MS SQL Server, PL/SQL, SSIS, SSRS, SSAS, SQL*Plus, SQL*Loader, Control-M, Windows, UNIX.

Confidential, Minneapolis, MN

Informatica Consultant

Responsibilities:

• Extensively Working on Informatica tools such as Source Analyzer, Warehouse Designer, Transformation Designer, Mapplet Designer and Mapping Designer
• Using Informatica Admin console and Informatica Hub console to perform all the admin related activities
• Using Informatica Power center to make the changes to the existingETL Wrote PL/SQL procedures which are called from Stored Procedure transformation to perform database actions such as truncate the target before load, delete records based on a condition and re-name the tables.
• CreateETLmappings with complex business logic for high volume data loads using various transformations such as Aggregator, Sorter, Filter, Normalizer, SQL Transformation, Lookup, Joiner, Router, Update Strategy, Union, Sequence Generator, transformation language likes transformation expression, constants, system variables, data format strings etc.
• Developed Mapplets, Reusable Transformations, Source and Target definitions, mappings using Informatica.
• Extensively worked on building workflows, worklets, sessions, command tasks etc.
• Designed and developed Informatica mappings including Type-I, Type-II and Type-III slowly changing dimensions (SCD).
• Created mappings using different IDQ transformations like Parser, Standardizer, Match, Labeler and Address Validator.
• Extensively worked onETLperformance tuning for tune the data load, worked with DBAs for SQL query tuning etc.
• Supported monthly data load activity using SSIS for Account Assignment System.
• Involved in writing SQL Stored procedures and Shell Scripts to access data from various sources.
• Assisted other ETL developers in solving complex scenarios and coordinated with source systems owners with day-to-day ETL progress monitoring.
• Performed System, Integration testing and supported User Acceptance Testing.
• Managed stakeholder communication and validated the fixed issues to ensure support availability as per agreed SLAs.

Environment: Informatica MDM, Informatica Data Quality Informatica Power Center 8.6, IDQ, Oracle, MS SQL Server 2014,Control-M, Business Objects, MS Access, Windows.

Confidential, San Antonio, TX

ETL Admin/Developer

Responsibilities:

• Interacted with business analysts, data architects, application developers to develop a data model.
• Involved in the warehouse design using a Star Schema.
• Joined relational tables existing in separate database using Joiner Transformation.
• Used the Router Transformation to load user-defined groups for the business units based on group filter conditions.
• Involved in Performance Tuning of sources, targets, mappings and sessions.
• Performed unit testing to validate mappings and populate the database.
• Documentation of Technical specification, business requirements, functional specifications for the development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into various tables.
• Performed data analysis based on the source systems and existing OLTP database systems.
• Involved in production support working with various mitigation tickets created while the users working to retrieve the database.
• Created Stored Procedures to transform the Data and worked extensively in PL/SQL for various needs of the transformations while loading the data.
• Tested data and data integrity among various sources and targets.

Environment: Informatica Power Center, Oracle, DB2, SQL, PL/SQL, UNIX, TOAD, SQL Server, Windows.

Confidential, Charlotte, NC

ETL Developer

Responsibilities:

• Extracted Data from Different Sources by using Informatica.
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping designer and Mapplets Designer.
• Extracted data from different sources of databases. Created staging area to cleanse the data and validated the data.
• Designed and developed complex Aggregate, expression, filter, join, and Router, Lookup and Update Transformation rules.
• Developed schedules to automate the update processes and Informatica sessions and batches.
• Analyze, design, construct and implement theETLjobs using Informatica.
• Developed mappings/Transformations/mapplets by using mapping designer, transformationdeveloperand mapplets designer in Informatica Power Center.
• Developed Shell scripts to setup runtime environment, and to run stored procedures, packages to populate the data in staging tables.
• Created Users, user groups, database connections and managed user privileges using supervisor.

Environment: Informatica Power Center, Oracle, MS SQL SERVER, SQL, PL/SQL, SQL*Loader, UNIX Shell Script.