PROFESSIONAL SUMMARY:

• 7 years of IT experience in Design, Development and Implementation of Data warehouses as an ETL Developer.
• Expertise in Designing & Developing complex Extract, Transform and Load (ETL) applications using Informatica Power Center 10/9.6/9.5/9.1/8.6
• Experienced in the Analysis, Design, Development, Testing of Data warehouses and Data marts. Extensive Knowledge of Dimensional Data Modeling of Star Schema/Snowflake and Relational database concepts.
• Databases of experience using Oracle, DB2, MS SQL Server, Teradata, Teradata SQL Assistant, and MYSQL
• Experienced in using various Transformations such as Expressions, Filters, Aggregators, Lookups, Routers, Joiner and Sequence Generator etc. to load consistent data in to Oracle, SQL Server databases.
• Worked on multiple Data warehousing projects with complete Software Development Life Cycle process starting with Requirements Analysis, Technical Analysis, Design, Build, Test, Deploy and Production support.
• Experienced in Data Warehouse/Datamart, OLTP and OLAP implementations teamed with project scope, Analysis, requirements gathering, data modeling, Effort Estimation, ETL Design, development, System testing, Implementation and production support.
• Excellent experience using Teradata SQL Assistant, data load/export utilities like BTEQ, FastLoad, Multi Load, Fast Export using Mainframes and UNIX
• Excellent experience in writing SQL queries using SQL, SQL*Plus, PL/SQL, Procedures/Functions, and Triggers
• Experienced in ETL processes. Worked extensively on data extraction, data integration, and loading from different data sources using SSIS
• Analyzed, Designed and Implemented different stages of Data Warehouse.
• Experience in integration of various data sources like Oracle, DB2, SQL Server, My SQL, MS Access, MS Excel and Flat Files into staging area. Also experience in Optimizing Database querying, data manipulation using SQL and PL/SQL in Oracle, flat files and SQL Server databases
• Implemented complex business rules in Informatica by creating re - usable transformations, and robust mappings/mapplets. Experience in loading data, troubleshooting, Debugging mappings, tuning mappings, etc.
• Developed data Mappings between source systems and warehouse components using Mapping Designer
• Experienced in Agile development.
• Keen on learning new technologies and grasping them quickly

TECHNICAL SKILLS:

Operating Systems: Windows 7/ XP/ NT/95/98/2000, DOS, and LINUX

Database: Oracle 11g, MS SQL Server 2005, MS Access.

Programming languages: SQL, PL/SQL, UNIX Shell Script, ANSI C, C++, XML, HTML.

Tools: Oracle SQL Developer, PLSQL, SQL, Informatica PowerCenter10/9.5, Informatica Power Exchange 8.X

Reporting: Business Objects, Cognos, Erwin Data Modeler, MS Visio, SSRS, Power BI, Tableau.

Others: Data Structures, RDBMS Concepts

WORK EXPERIENCE:

Confidential, Minneapolis, MN

Sr Informatica developer

Responsibilities:

• Worked with Business Analyst and application users to finalize Data Model, functional and detailed technical requirements.
• Prepared mapping specifications documents, unit testing documents for developed Informatica mappings.
• Responsible for the debugging, creating mapping, running maps etc. by using Informatica Power Center.
• Designed, Installed, Configured core Informatica/Siperian MDM Hub components such as Informatica MDM Hub Console, Hub Store, Hub Server, Cleanse Match Server, Cleanse Adapter, Data Modeling.
• Involved with Data Steward Team for designing, documenting and configuring Informatica Data Director for supporting management of MDM data.
• Configured and running test session, workflow using Workflow Manager.
• Prepared mapping documents for loading the data from legacy system, flat files to staging area.
• Responsible for Data Warehouse Architecture, ETL and coding standards.
• Designed SSIS package for automatic data loading from FTP site to SQL server and scheduling the SSIS packages to run in specified manner by using the SQL Server Agent Service.
• Worked with web services. Created SSIS Packages to migrate slowly changing dimensions.
• Configured match rule set property by enabling search by rules in MDM according to Business Rules.
• Used the Data Transformation Studio to create scripts that convert complex data formats (i.e. HL7, EDI File Formats), into standard ones and then integrate to Informatics’ Power Center platform, using the UDT transformation.
• Deployed new MDM Hub for portals in conjunction with user interface on IDD application.
• Extensively involved in performance tuning of the Informatica ETL mappings by using the caches and overriding the SQL queries and also by using Mapping Parameter files.
• Effectively made use of Hints, Table Functions, Indexes, Table Partitioning, Collections, Analytical functions, Materialized Views, SQL Loader, Dynamic SQL and Ref Cursor.
• Extensively involved in both ETL Informatica & Database performance tuning.
• Analyzed session log files in session failures to resolve errors in mapping or session configuration.
• Used major components like Serializes, Parsers, Mappers and Streamers in Data Transformation Studio for conversion of XML files to other formats.
• Used various transformations like Source Qualifier, Joiner, Lookup, SQL, router, filter, Expression and Update Strategy.
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools.
• Assisted DBA to Create tables and views in Teradata, Oracle database.
• Extensive experience in integration of Informatica Data Quality (IDQ) with Informatica Power Center
• Created the DB tables, Views and involved in taking backup of Production tables.
• Developed complex mappings & mapplets in Informatica to load the data using different transformations.
• Prepared ETL standards, Naming conventions and wrote ETL flow documentation for Stage, ODS and Mart.
• Creating and maintaining the entity objects, hierarchies, entity types, relationship objects and relationship types using Hierarchy tool to enable Hierarchy Manager (HM) in MDM HUB implementation and Informatica Data Director (IDD).
• Participated in the development and implementation of the MDM decommissioning project using Informatica Power Center that reduced the cost and time of implementation and development.
• Created PL/SQL packages, Stored Procedures and Triggers for data transformation on the data warehouse.
• Involved in Dimensional modeling to Design and develop STAR Schemas, used ERWIN, identifying Fact and Dimension Tables.
• Rebuilding the Reports in Cognos Environment.
• Involved in Migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
• Worked with the third party scheduler Autosys for scheduling Informatica Power Center Workflows Involved with Scheduling team in creating and scheduling jobs in Autosys Workload Scheduler.
• Involved in identifying bugs in existing mappings by analyzing the data flow, evaluating transformations and fixing the bugs so that they conform to the business needs.

Environment: Informatica Power Center 10/9.6.1/9.5.1/9.1.1 , Teradata 14, 12, Oracle 11g, My SQL, XML, Flat Files, SQL Assistant, Share point PL/SQL, Cognos, Unix, Windows.

Confidential, Phoenix, AZ

Informatica Developer

Responsibilities:

• Worked on Informatica Power Center 9.1 tool - Source Analyzer, Data Warehousing designer, Mapping & Mapplets Designer and Transformation Designer.
• Developed Informatica mappings and also in tuning of mappings for better performance.
• Participated in deployment planning and in deployment of the system to production.
• Facilitated business user smoke testing of the production system by setting up test data.
• Involved in production support duties including monitoring of nightly batches.
• Responsible for updating business stakeholders and OLTP/OLAP application support teams about the status of various ETL sessions and the impact of failed sessions on data availability.
• Responsible for debugging failed ETL sessions and taking steps to mitigate impact to business users.
• Extensively used Informatica Informatica Data Quality tool (IDQ Developer) to create rule based data validations for profiling.
• Utilized Informatica IDQ to complete the initial data profiling and matching/removing duplicate data for the process of data migration from the legacy systems to the Confidential Oracle Database.
• Created dictionary tables using IDQ analyst tool for data validations.
• Implemented B2B Informatica parsers to convert PDF documents to XMLs through Informatica.
• Involved in code review sessions to bring the team's attention to best practices and to identify areas of improvement.
• Responsible for implementing action items identified during code review sessions focused towards improving data quality and performance.
• Involved in performance tuning of sessions that work with large sets of data by tweaking block size, data cache size, sequence buffer length and Confidential based commit intervals.
• Developed sessions and batches to move data Confidential specific intervals and on demand using workflow manager.
• Worked on different modules of the project for successful execution.
• Created / developed different types of profiles like Column level profiling, Summary profiles, drill down profiles, Score cards, reports etc. using IDE.
• Have created Match, and Merge rules, developed address validations etc. and developed address validations to countries like US, and also developed reusable error handling rules using IDQ.
• Utilized Informatica IDQ to complete the initial data profiling and matching/removing duplicate data for the process of data migration from the legacy systems to the Confidential Oracle Database.

Environment: Informatica power center 9.1, IDQ Developer 9.1, Oracle 10g, PL/SQL, Toad, HP-UX, Informatica B2B, Windows, SQL

Confidential, Gallatin, KY

Informatica Developer

Responsibilities:

• Responsible for Evaluation, Analysis, Design, Development and Delivery of Interfaces (ETL) using Informatica.
• Interacted with Business Users and Business Analyst to gather the Requirements and Business logics.
• Worked on Informatica tool Source Analyzer, Warehouse Designer, Mapping Designer.
• Involved in Agile development, project planning and release planning activities
• Extensively used Transformations like Aggregator, Router, Joiner, Expression, Lookup, Update Strategy, and Sequence Generator.
• Extensively worked in the performance tuning of ETL mappings.
• Created reusable transformations.
• Creating data mappings to extract data from different source Databases, transform the data using ETL Informatica Transformations then load to Oracle data warehouse. Defined Confidential Load Order Plan and Constraint based loading for loading data correctly into different Confidential Tables.
• Setting up of Unit / Integrated testing of interfaces (ETL) & documentation.
• Involving with developers and application team for Plan and coordinate database changes, installation of upgrades, patches and new versions, interacting with Design DBA and other infrastructure teams.
• Performed backup and recovery using Oracle 11g's user managed backup
• Implement the Database components (Stored procedures). Alter the existing stored procedures as per design.
• Scheduled Sessions and Batches on the Informatica Server using Informatica Server Manager/Workflow Manager.

Environment: Informatica Power center8.5, Oracle, SQL Server, UNIX Shell Script.

Confidential, Seattle, WA

ETL/Informatica Developer

Responsibilities:

• Worked extensively on Designing and Developing complex Informatica mappings and workflows which applied complex transformation rules, to populate "fact and dimension" tables of the Oracle analytics database/data warehouse.
• Wrote SQL queries, stored procedures, views, triggers.
• Extensively involved in writing ETL Specs for Development and conversion projects.
• Involved in analyzing the source data coming from different Data sources such as Oracle, SQL Server, and identifying data anomalies in the source data.
• Coordinated with Business Users and the Offshore Development Team for solving design issues and requirements understanding for the coding phase.
• Extensively created complex mappings using transformations like Filter, aggregator, update strategy, lookup, router, stored procedure, sequence generator, and joiner using Informatica Power Center 9x.
• Implemented slowly changing dimensions Type 2 using date method.
• Scheduled the Jobs to run Confidential particular time/interval thru the Scheduler using Workflow Manager.
• Created tasks like Session, Decision, Email, Command, Event Wait, Event Raise and Control tasks in preparing the Workflow.
• Wrote some complex Oracle Stored Procedures and functions.
• Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.
• Created reusable Mapplets and Transformations to reduce the complexity in mappings and to handle repetitive tasks such as setting and getting Dimension details.
• Involved in Performance tuning Confidential various levels including Target, Source, Mapping, and Session for large data files.
• Redesigned some of the mappings and mapplets in the system to meet new functionality.
• Enabled incremental loading in fact table mappings and made required changes to the mappings to populate the production data.

Environment: Informatica Power Center 9x, Oracle 11g, SQL Server 2008, PL/SQL, Excel, Windows 7, UNIX.