PROFESSIONAL SUMMARY

• Around 7+ years of IT experience with extensive knowledge on complete SDLC Analysis, Design, Development, Implementation, Modeling, Testing, and support for Data warehousing applications.
• Strong Hands on experience on Informatica Power center and Informatica Analyst tool and Informatica Data Quality (IDQ).
• Good knowledge on working in Hadoop environment of Informatica.
• Extensively worked on Informatica Big Data Edition, Extensively using HUE to work with various Hive tables in hive environment.
• Extensive experience in using Informatica tool for implementation of ETL methodology in Data Extraction, Transformation and Loading.
• Extensively worked on Dimensional modeling, Data migration, Data cleansing and Data Validation of operational sources using ETL processes and providing data mining features for data warehouses. And involved in Full Life Cycle Development of building a Data Warehouse.
• Drawing on Experience in all aspects of analytics/data warehousing solutions (Database issues, Data modeling, Data mapping, ETL Development, metadata management, data migration and reporting solutions).
• I have been key in delivering innovative database /data warehousing solutions to the Retail, Pharma and Finance Industries.
• Have good skills on understanding and development of business rules for its Standardization, Cleanse and Validation of data in various formats.
• Have clear understanding of Data warehousing and Business Intelligence concepts with emphasis on ETL and life cycle development Using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Metadata Manager and Workflow Monitor).
• Worked on Slowly Changing Dimensions (SCD’s) and its implementation to keep track of historical data.
• Actively involved in Performance Tuning, Error handling Product support on various Platforms.
• Experience in coding using SQL, SQL*plus, PL/SQL procedures/functions, triggers and exceptions.
• Good experience in Relational Database concepts, Entity relation Worked with File Transfer Protocol (FTP) and Secure file transfer protocol(SFTP) to pull or send the files from one server to another server
• Experience working with Informatica Data Quality tool IDQ end - to-end workflows from profiling to loading it as golden record.
• Developed several complex mappings in Informatica a variety of Power Center transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using both the Informatica Power Center and IDQ.
• Experience working with Informatica Analyst and Informatica Developer tools.
• Experience on creating profile, rules and mappings with IDQ.
• Experience working with IDQ transformations like Labeller, Parser, Standardizer, Match, Exception, Merge and Association etc..
• Creating the column level profiling, Join analysis and Profile models.
• Experience in Data validations and Unit Testing.
• Experience in UNIX working environment, writing UNIX shell scripts for Informatica pre & post session operations.
• Exceptional analytical and problem solving skills. Team player with the ability to communicate effectively at all levels of the development process.
• Having ability to train developers and advising technical groups on ETL best practices using Informatica.
• Experience in scheduling of ETL jobs using Informatica Scheduler, Control-M and Autosys scheduling tool, UC4 and Tidal.
• Overall expertized in working with all transformations like expression, Router, Filter, Joiner, Aggregator, Sorter, Look up etc.,

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x, Informatica Data Quality 9.x, Informatica Analyst tool 9.x,Big Data edition

ETL Sources: SAP BW, Oracle, Flat Files, SQL Server, Teradata

DB Tools: SQL*Plus, TOAD 9.7

Development Languages: SQL, PL/SQL, UNIX, Shell Scripting

Data Bases: Oracle 11g/10g, My SQL

Operating Systems: Windows XP/7, UNIX, Sun OS

BI Tools: Crystal Reports, Micro strategy.

Scheduling: Informatica Scheduler, Control M, Autosys, UC4 and Tidal

Others: Toad, PL/SQL Developer, WinSCP, Putty, MS Office, Remedy

PROFESSIONAL EXPERIENCE

Confidential, West Des Moines, IA

Sr. Informatica/IDQ Developer

Responsibilities:

• Interacted with Business analysts to collect the Business requirements and understand the Usage of the project.
• Working extensively on Informatica Big Data Edition.
• Working on Hadoop files and Tables as Target definitions.
• Resolving user queries before the SLA with accurate solutions.
• Coordinating with various source teams regarding any data issues in production.
• Developed Mappings/Workflows/Scheduling ETL process.
• Implementing CDC using Set max variable approach.
• Used most of the transformations such as the Source qualifier, Aggregator, Router, Filter, Sequence Generator, Stored Procedure, Expression and Lookup as per the business requirement.
• Worked on enhancements like developing new mapping or changes to the existing code.
• Implemented performance tuning and optimization techniques.
• Create clear concise documentation of requirements to review between the technical and business group.
• Production implementation coordination between the users and technology area Analyzed defined and managed Business needs.
• Experience working with Informatica Analyst and Informatica Developer tools.
• Worked on creating profiles, profile models, rules and mappings with IDQ.
• Created Profiles using IDQ rules and filters.
• Applying cleansing rules using developer.
• Developed several complex mappings in Informatica a variety of Power Center transformations, Mapping Parameters, Mapping Variables, Mapplets & Parameter files in Mapping Designer using both the Informatica Power Center and IDQ.
• Analyzing the queries in case of any long running jobs and collecting the stats for the tables involved in it.
• Implemented Join conditions between tables at the Database level.
• Created ETL (Extract Transform and Load) specification documents based on the business Requirements.
• Handling the monthly release activities on time to cope up the work.
• Worked extensively on developer client in Hadoop environment in order to maintain files and tables in Hive environment.
• Using TIDAL as scheduler for all the jobs and working with relevant UNIX scripts
• Developed Source to Target data mapping documents, inclusive of all the transformation and business rules, logical and physical column names, data types, data flow diagrams used for ETL Design and development.
• Created Source to Target (ETL) mapping documents which included the fields, data type, definitions from both source and target systems. A business/transformation rule was also documented based on the business requirement or formatting needs of data.
• Worked on Netezza database for loading data into data warehouse.
• Provided strategic support in development of detailed project plans, work assignments, target dates etc.

Environment: Informatica Analyst tool/IDE 9.6.1, Informatica Data Quality 9.6.1, Informatica Power center 9.6.1, Informatica Big Data Edition, Netezza, Oracle, Tidal Scheduler.

Confidential, San Francisco, CA

Sr. Informatica/IDQ developer

Responsibilities:

• Analyzed source systems, business requirements and identified business rules for building the data warehouse.
• Developed Technical Specifications of the ETL process flow.
• Extensively used Change Data Capture for production issues analysis, troubleshooting of the problem tickets, and to keep production data efficient, and to improve the performance of the ETL mappings. Check the data quality using IDQ.
• Designed and developed Informatica mappings in Informatica 9.5.1 environment, workflows to load data into Oracle ODS.
• Extensively used Informatica to load data from Oracle, XML and Flat Files to Oracle.
• Used Informatica workflow manager, monitor, and repository manager to execute and monitor workflows and assign user privileges.
• Extensively worked with Aggregator, Sorter, Router, Filter, Join, Expression, Lookup and Update Strategy, Sequence generator transformations.
• Set up Metadata driven utility design for the ETL processes using Informatica.
• Involved in tuning the performance of sessions and mappings.
• Used the Workflow manager to create workflows and tasks, and also created Worklets.
• Involved in Production Support in resolving issues and bugs.
• Worked on SQL stored procedures, functions and packages in Oracle.
• Created and maintained UNIX shell scripts for pre/post session operations and various day-to-day operations.
• Developed unit and system test cases, using System Procedures to check data consistency with adherence to the data model defined. Check the data quality using IDQ.

Environment: Informatica Analyst tool/IDE 9.5.1, Informatica Data Quality 9.5.1, Informatica Power center 9.5.1, SQL server, Oracle, UC4 Scheduler.

Confidential, Plano, Texas

Sr. Informatica Developer

Responsibilities:

• Design, Development and Documentation of the ETL (Extract, Transformation & Load) strategy to populate the Data Warehouse from various source systems.
• Extensively used Informatica Power Center to create and manipulate source definitions, target definitions, mappings, Mapplets, transformations, re-usable transformations, etc.
• Used Erwin for logical and Physical database modeling of the staging tables, worked with the Data Modeler and contributed to the Data Warehouse and Data Mart design and specifications.
• Developed technical design specifications to load the data into the data mart tables confirming to the business rules.
• Worked with Repository Manager for managing of repositories, creation of users, creation of user groups and folders.
• Involved in design and development of complex ETL mappings and stored procedures in an optimized manner.
• Created Stored Procedures, Packages in PL/SQL with Oracle in order to create, update several tables like Order processing Information table and Audit Log tables.
• Based on the requirements, used various transformation like Source Qualifier, Normalizer, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner, Stored procedure transformations in the mapping.
• Developed Informatica SCD Type-I, Type-II mappings. Extensively used almost all of the transformations of Informatica including complex lookups, Stored Procedures, Update Strategy, Mapplets and others.
• Developed Mapplets and Worklets for reusability.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command, Decision.
• Implemented partitioning and bulk loads for loading large volumes of data.
• Involved in performance tuning of mappings, transformations and (workflow) sessions to optimize session performance.
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX SHELL PERL scripts to automate the process.
• Created UNIX Shell scripts and called as pre session and post session commands.
• Developed Documentation for all the routines (Mappings, Sessions and Workflows).
• Involved in scheduling the workflows through Autosys using UNIX scripts.
• Creating Test cases and detailed documentation for Unit Test, System, Integration Test and UAT to check the data quality.

Environment: Informatica Power center 9.5.1, SQL server, Oracle, Autosys scheduling.

Confidential, Malvern, PA

Sr. Informatica Developer

Responsibilities:

• Involved in requirements gathering and analysis to define functional specifications.
• Extensively worked on Process Design, Development, Testing and Implementation of the Project.
• Analyzing existing database schemas and designing star schema models to support the users reporting needs and requirements.
• Developed ETL processes to load data from different source systems such as Oracle and Flat Files into target systems i.e. Oracle and Flat files.
• Extracted the data from Oracle10g, Netezza, XML, Flat files, DB2 load the data in to Oracle warehouse.
• Extensively worked on Informatica Power Center - Source Analyzer, Data warehousing designer, Mapping Designer, Mapplet & Transformations to import source and target definitions into the repository and to build mappings.
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, Source Qualifier.
• Used Informatica’s features to implement Type II changes in slowly changing dimension tables.
• Created tables, views, primary keys, indexes, constraints and sequences.
• Involved in developing optimized code using PL/SQL for Server related Packages to centralize the application through procedures, functions and packages.
• Created and configured workflows, Worklets & Sessions to transport the data to target systems using Informatica Workflow Manager.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
• Involved in the architecture and management of data governance with Business Intelligence team.
• Used Control-M Tool to schedule shell scripts and Informatica jobs.
• Performed Unit, Grid Integration, and Testing and validate results with end users.

Environment: Informatica Power center 9.1, Teradata, Oracle, Control -M.

Confidential

Informatica Developer

Responsibilities:

• Reviewed the Business Requirement Documents and the Functional Specification.
• Written Test Cases for ETL to compare Source and Target database systems.
• Worked on Informatica Power Center tool - Source Analyzer, Data warehousing designer, Mapping & Mapplet designer and Transformation.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Tested the ETL process for both before data validation and after data validation process.
• Performed Data Analysis during the requirements gathering phase by reviewing the source data model and running SQL queries.
• Responsible for different Data mapping activities from Source systems to database.
• Performed Data validity testing for reports and feeds based on client's requirement.
• Created reports that included a general overview, open bugs, new bugs and enhancement requests. Entered new bugs and maintained the current status of those bugs.

Environment: Informatica Power center 9.0, SQL server, Oracle, UC4 Scheduler.

Confidential

Informatica Developer

Responsibilities:

• Analyzed business requirements and worked closely with various application teams and business teams to develop ETL procedures that are consistent across all applications and system.
• Interacted with Business Users and Managers in gathering business requirements.
• Wrote Informatica ETL design documents, establish ETL coding standards and perform Informatica mapping reviews.
• Extensively worked on Power Center Client Tools like Power center Designer, Workflow Manager, and Workflow Monitor.
• Create mapping usingInformaticapower center to cleanness data and feed into tables again.
• Extensively worked on Power Center 8.5.1 Designer client tools like Source Analyzer, Target Designer, Mapping Designer, Mapplet Designer and Transformation Developer.
• Extensively used various transformations like Source Qualifier, Joiner, Aggregation, Update Strategy, lookup, Rank and Filter.
• Created Reusable and Non-Reusable command task in Workflow Manager.
• Created Sessions, command task, reusable Worklets and workflows in Workflow Manager.
• Responsible for the Performance tuning at the Source Level, Target Level, Mapping Level and Session Level.
• Performed Unit testing and Data validation testing using Validation scripts.
• Created Data Validation document, Unit Test Case Document, Technical Design Document, Informatica Migration Request Document and Knowledge Transfer Document.
• Responsible for developing data ingestion routines, creating standards and reusable code and performing Informatica Data Transformation (B2B) development.
• Converting unstructured data into target database with B2B tool of Informatica.

Environment: Informatica Power center 8.5.1, SQL server, Oracle.