PROFESSIONAL SUMMARY

• Over 8 years of experience in Analysis, Development and Maintenance of Business Intelligence solutions using Informatica Power Center 9X/8X/7X.
• Data processing experience in designing and implementing date mart applications, mainly extract transform and load using Informatica power center.
• Proficient database experience using MS SQL server 2008/2012/2014, oracle 11g/10g/8i/7i, DB2 and Teradata.
• In - depth understanding of data warehousing basics, relational database management system and dimensional modeling (Star Schema, Snow Flake Schema, fact & Dimension tables).
• Experience on business Requirements Analysis, Application Design, Development, testing, implementation and maintenance of client/server Data Warehouse and Data Mart systems in teh Food Chain, Retail, Banking, and Pharmaceutical industries.
• Experience in installing, updating and configuring Informatica power center.
• Proficiency in using Informatica Power Center tool to design data conversions from wide variety of sources.
• Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplets, reusable transformation and Mapping Designer.
• Experience in Data Warehouse/Data Mart Development Life Cycle and performed ETL procedure to load data from different sources into data warehouse using Informatica Power Center (Repository Manager, Designer, Workflow Manager and Workflow Monitor).
• Developed various mappings using different Informatica transformations like Source Qualifier, Expression, Filter, Joiner, Router, Union, Stored procedure, Sequence Generator, Unconnected / Connected Lookups and Aggregator.
• Designed and developed teh logic for handling slowly changing dimension table’s loaded by flagging teh record using update strategy for populating teh desired.
• Experience in developing Sessions/tasks, Worklets, and Workflows using Workflow Manager Tools - Task Developer, Workflow and Worklets Designer.
• Extensively used Informatica Repository Manager and Workflow Monitor.
• Experience in SQL coding using TOAD, SQL Navigator, SQL*Loader, MS SQL Server management studios, PL/SQL procedures/functions, cursors triggers and exceptions to implement teh business logics.
• Used Change Data Capture (CDC) to capture changes in source database and applied to target database.
• Actively involved in Performance Tuning, Error handling, Product support on various Platforms.
• Experience in using Data Modeling Tools like Erwin and Microsoft Visio.
• Good noledge in OLAP and OLTP process.
• Experience in writing UNIX shell scripts for Informatica pre & post session operations.
• Involved in various stages of testing (Unit, System, Integration, User Acceptance Test).
• Good noledge in Normalizing and De-normalizing teh tables and maintaining Referential Integrity by using primary and Foreign Keys.
• Strong experience in documenting process, analyzing business requirements, working with requirements traceability matrix, re-engineering business processes and designing.
• Highly experienced in User and Developer interface procedures and requirements solution for end user needs.
• Ability to solve complex technical problems and has unique ability to understand long-term project development issues at all levels and interpersonal skills with strong desire to achieve specified goals within teh given time frame.
• Excellent analytical, problem solving, communication and interpersonal skills with ability to interact with individuals at all levels.
• Highly motivated to take independent responsibility as well as ability to contribute and be a productive team member with excellent Verbal and Communication Skills and clear understanding of Business procedures.
• Most of teh career worked under Agile Methodology Environment and participated in daily scrum meetings and worked with Business.

TECHNICAL SKILLS

ETL TOOL: Informatica Power Center 9.5/9.1/9.0/8.6.1/8.1.1/8.0/7.1, Power exchange 8.x, Data Mart, OLAP, OLTP

DATABASES: Oracle 11g/10/9i/8.x, MS SQL Server 2000/2005/2012,MS Access.

LANGUAGES: C, C++, SQL, PL/SQL, Unix Shell Script, Batch Script.

Data Modeling: Erwin 4.0

ENVIRONMENT: Windows NT/2000/Windows XP/Windows Vista/ Windows 7, UNIX, Sun Solaris, MS Visio, MS-DOS.

SCHEDULER: Autosys, Tivoli, Control-M

RDMS Load Tools: TOAD for Oracle, SQL management studio 2012 for SQL Server

Business Intelligence Tools: Tableau 8.1, PROS Pricing Suite, Oracle Essbase

PROFESSIONAL EXPERIENCE:

Confidential, Oklahoma City, OK

Informatica Developer

Responsibilities:

• Understanding business needs and implement teh same into a functional database design.
• Participated in requirements gathering along with teh Technical lead to understand teh business requirements.
• Involved in all teh phases of SDLC from requirement gathering to production implementation.
• Developed new Informatica mappings, sessions and workflows based on specifications.
• Developed Batch Processing, Source and Target Reconciliation process.
• Designed and developed various Informatica mappings using transformations like Expression, Aggregator, External Procedure, Stored Procedure, Lookup, Filter, Joiner, Rank, Router, and Update Strategy. Developed various Ad-hoc mappings for various business needs.
• Performed extraction, transformation and loading of data from RDBMS tables, Flat Files into SQL server tables in accordance with requirements and specifications.
• Writing Stored Programs (Procedures & Functions) to do Data Transformations and integrate them with Informatica programs and existing applications.
• Created, scheduled, and monitored workflow sessions on teh basis of run on demand, run on time, using Informatica Power Center workflow manager.
• Used Informatica Version Control for checking in all versions of teh objects used in creating teh mappings, workflows to keep track of teh changes in teh development, test and production environment.
• Used Erwin data modeling tool to do conceptual/logical/physical data models.
• Developed batch scripts to transfer flat files between servers.
• Created test cases for each requirement and validate teh code against all test case scenarios.
• Prepare sample data for test scenarios and simulate teh load process.
• Participated in User Acceptance Testing along with business users and get teh approvals
• Worked with teh SQL admin team to promote teh code between Dev, QA and Production environments.
• Migrated ETL components between Dev, QA and Production environments.
• Updated teh audit table to control load process, i.e, daily, weekly, monthly or history loads.
• Worked with production issues like bottlenecks, data validation and report errors.

Environment: Informatica Power Center 9.5, SQL Server 2012, MS Access, XML Files, Excel files, JSON, Java Shell scripting, Windows.

Confidential, Wayne, PA

Informatica Developer

Responsibilities:

• Working closely with business users in gathering requirements.
• Worked with source system IT team and business owners to identify data sources for defining data extraction methodologies.
• Performed gap analysis and data profiling on teh source systems to estimate data quality and decide on appropriate extraction, transformation, and loading strategies
• Worked with application architecture team to convert business requirements into technical specifications and to estimate effort for each requirement.
• Design ETL mappings as per Assurant standards, reviewing it with design review board.
• Develop mappings/Reusable Objects/Transformations/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica Power Center 9.5.
• Created mappings to perform teh tasks such as cleaning teh data and populate dat into staging tables, Populating teh Enterprise Data Warehouse by transforming teh data into business needs
• Used transformations such as Expressions, Filters, Joiners, aggregators, Lookups, Update strategy, Sequence Generator, TCL, Router and XML to load data into data warehouse.
• Involved in writing SQL Stored procedures and Shell Scripts.
• Extracted data from Oracle database and created XML files.
• Created and Executed workflows and Worklets using Workflow Manager to load teh data into teh Oracle Database.
• Generated XML out files on UNIX box and transferred teh files to PROS server using SFTP mechanism.
• Validated teh fact data with teh data in reports and dashboards.
• Maintained Versions of SQL Scripts, Documentation using Clear case.
• Worked with Informatica Admin team to migrate code during deployment form dev to stage and tan to production.
• Involved in creation of various Unix Scripts, which halp teh ETL scheduling jobs, and to push data files between Informatica and essbase application servers.
• Performed and scheduled Business/ETL Jobs using Informatica scheduler.
• Used Informatica Version Control for checking in all versions of teh objects used in creating teh mappings, workflows to keep track of teh changes in teh development, test and production environment.
• Supported teh application during infant care period and performed data validation after production implementation.

Environment: Informatica Power Center 9.5, Oracle 8i, SQL Server2000, MS Access, SQL, PL/SQL, Windows NT.

Confidential, Pittsburg, PA

Informatica ETL Developer

Responsibilities:

• Involved in design and development of data warehouse environment, liaison to business users and technical teams gathering requirement specification documents and presenting and identifying data sources, targets and report generation.
• Worked on Informatica Power Center tool - Source Analyzer, warehouse designer, Mapping Designer, Workflow Manager, Mapplets, and Reusable Transformations.
• Using Informatica Designer designed Mappings, which populated teh Data into teh Target Star Schema on Oracle Instance.
• Optimized Query Performance, Session Performance and Reliability.
• Extensively used Router, Lookup (Connected/Unconnected), Aggregator, Expression and Update Strategy Transformations.
• Tuning teh Mappings for Optimum Performance, Dependencies and Batch design.
• Schedule and Run Extraction and Load process and monitor sessions using Informatica Workflow Manager.
• Involved in identifying bugs in existing mappings by analyzing teh data flow, evaluating transformations and fixing teh bugs so dat they conform to teh business needs.
• Used Agile Methodology throughout teh project and participated in daily Scrum meetings and worked with Business.
• Involved in writing UNIX shell scripts for Informatica ETL tool to run teh sessions.

Environment: Informatica Power Center 9.1, Oracle 9g, PL/SQL, UNIX, Erwin, TOAD, SQL server, Cognos, Agile.

Confidential, Tampa, FL

ETL Developer

Responsibilities:

• Involved in Data modeling and design of data warehouse in star schema methodology with confirmed and granular dimensions and FACT tables.
• Responsible for designing and developing of mappings, mapplets, sessions and work flows for load teh data from source to target database using Informatica Power Center and tuned mappings for improving performance.
• Involved in ETL process from development to testing and production environments.
• Developed mappings using various transformations like update strategy, lookup, stored procedure, router, joiner, sequence generator and expression transformation.
• Used Informatica Power Center Workflow Manager to create sessions, batches to run with teh logic embedded in teh mappings.
• Tuned mappings and SQL queries for better performance and efficiency.
• Created & Ran shell scripts in UNIX environment and written stored procedures in Oracle.
• Modified all teh existing Informatica Mappings by applying performance tuning techniques for better performance.
• Checking teh data flow and extensively using SQL Queries to extract teh data from teh Database and conducted data quality profiling and Oracle explain plan. Writing PL/SQL procedures for processing business logic in teh database.
• Performance tuning of teh Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
• Performed Unit testing to validate mappings and populate teh databases.
• Scheduling of sessions and workflow and loaded data into data marts on a daily basis.

Environment: Informatica Power Center 8.1.1, Informatica Power Connect, Power Analyzer, Power Exchange, Oracle 9i, SQL, PL/SQL, MS Visio, DB2, Windows XP, TOAD, UNIX.

Confidential, CA

Informatica Developer

Responsibilities:

• Managing and Monitoring production data loads to ensure data has been loaded into teh warehouse properly and teh data is ready for reporting.
• Analyzing business requirements and preparing technical documentation and application process and writing test cases.
• Working on Designing and creating tables for new setup database, writing sub routines as per teh business requirement.
• Denormalize legacy system to normalized New Setup database. Developed mappings to load teh date from different sources like oracle, flat files.
• Designed and developed teh logic for handling slowly changing dimension table’s load by flagging teh record using update strategy for populating teh desired.
• Gather and/or clarify requirements directly from teh users or PM and developing new Informatica process for automating various new activity.
• Extensively used ETL to load data from flat files (excel/access),Teradata database.
• Writing UNIX scripts to ftp files, cleaning teh data, other required functionalities and place them in teh proper source/target directories for processing.
• Re-designed multiple existing Power Center mappings to implement change requests (CR) representing teh updated business logic.
• Enhancement of existing complex processes to support additional design, development and deployment of new and enhanced processes to production and support new load strategy.
• Improving teh SQL query performance, and updating teh technical documents.

Environment: Informatica Power Center v 8.6, Oracle 9i/10g,XML Files, Excel files, SQL, PL/SQL, Unix Shell scripting, Windows XP and, SQ Developer, Toad.

Confidential

ETL Informatica Developer

Responsibilities:

• Integration of various data sources like Oracle, SQL Server, Fixed Width and Delimited Flat Files, DB2, COBOL files & XML Files.
• Developing several complex mappings in Informatica a variety of Power Centre transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using Informatica Power Centre.
• Developed slowly changed dimensions (SCD) Type 2 for loading data into Dimensions and Facts.
• Performed operational support and maintenance of ETL bug fixes and defects.
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files.
• Migration of code between teh Environments and maintaining teh code backups.
• Created teh Test cases and Captured Unit test Results.
• Designed mappings from teh scratch and also did performance tuning of teh mappings dat were previously implemented.
• Migrating mappings, workflows and parameter files from development to production.
• Responsible for implementing Incremental Loading mappings using Mapping Variables and Parameter Files.
• Maintained teh target database in teh production and testing environments.
• Implemented Logical /Physical design of database schemas and business processes though Erwin.
• Developing information systems through investigation, analysis, design, implementation and maintenance with SDLC.
• Implemented complex views, procedures, functions, packages and triggers in PL/SQL.
• 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 teh loading of teh data.
• Developed PL/SQL code at teh database level for teh new objects.

Environment: Informatica Power Centre 9.5.1, Oracle 11g/9i,PL/SQL, Flat files, XML, MS AccessWeb services, UNIX, Toad for Oracle

Confidential

Informatica Developer

Responsibilities:

• Complete understanding of Data in various sources, so as to support Business Intelligence (BI) Team in creating SDLC.
• Supported BI team to create Logical and Physical Data Models for Data Warehousing.
• Created Incremental Iterative ETL releases using an Agile Process.
• Supported and Created Source to Target Documentations, along with Business Analysts.
• Supported and Fixed ETL bugs, Reporting bugs identified by QA Team using Agile Methodology.
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in
• Back end testing and worked with data quality issues.
• Performed all aspects of Verification, Validation including Functional, Structural, Regression, Load and System Testing.
• Created ETL Codes based on Source to Target Documentations, so as to serve teh need of EDW
• Data to create various reports and dashboards using Micro strategy.
• Created ETL code to support data flow from Source to Staging and Staging to EDW, so as to standardize ETL coding for various SDLC.
• Created ETL code with various Incremental Logics (Slowly Changing Dimensions - 1, 2) based on requirements.
• Created Stored Procedures, Cursors and Triggers, to load, test and validate data in EDW Database.
• Verified teh data load in critical and non-critical columns based on teh ETL updates or inserts.
• Created various Parameters in Informatica Server, to support connections for Source, Target and Look up Tables.

Environment:Oracle 11g, INFORMATICA 9.0.1,XML,FlatFiles,SQL DEVELOPER, SQL*Plus, Windows, UNIX, HP Quality Center, Longview Khalix, People Soft, VM Ware, DAC.