PROFESSIONAL SUMMARY:

• Over 7 years of IT experience in Informatica and Data Warehousing involved with Business Requirements Analysis, Application Design, Development, testing and documentation. Implementation of full lifecycle in Data warehouses and Data marts in various industries.
• Extensive experience in developing scalable enterprise applications to the user needs which serves for Oil &Gas, Financial, Banking, Health Care Insurance and Retail Industries.
• Experience in Data Warehousing, Data Extraction, Transformation and Loading (ETL) data from various sources like Oracle, SQL Server, Microsoft Access, Microsoft Excel and Flat files into Data Warehouse and Data Marts using Informatica Power Center 9.1/9.0/8. X
• Involved in all phases of the Software Development Life Cycle (SDLC) from analysis, design, development, testing, implementation and maintenance with timely delivery against aggressive deadlines.
• Extensive experience with Informatica power center and its components like Repository Manager, Designer, Workflow Manager and Workflow Monitor, Reusable transformations, Mapplets, Worklets, Mapping Variables, Mapping Parameters, Parameter Files etc.
• Developed complex mappings andSCD Type1, Type2 and Type3mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Lookup, Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Normalize, Filter, Rank, Router, Stored Procedure and SQL transformations.
• Created and supported the workflows which handle data in the volumes of millions per day in the process of integrating Oilfield reservoir logging data with the analytics system.
• Extensively worked in Client - Server application development using Oracle 11g, 10g, 9i, PL/SQL and SQL*Plus.
• Experience in Database design, development and loading of Oracle, SQL Server, DB2 and Access.
• Expertise in development and designing of ETL methodology for supporting data transformations using Informatica Power Center.
• Responsible for performance tuning inInformatica Power Centerat the Target Level, Source level, Mapping Level, Session Level, and System Level.
• Expertise in creating stored procedures, PL/SQL Packages, Triggers and Functions.
• Strong knowledge to build ODS and Data Staging area.
• Skilled in Unix Shell Scripting on different Platform.
• Experienced in full lifecycle Data warehouses and Business Data marts with Star Schemas, Snowflake Schema Modeling.
• Worked on Informatica Scheduler to schedule the jobs automatically.
• Developed UserDefined Functions (UDF)to extract data from flat files
• Expertise in doing Data Validation, Unit testing and UAT support for developed Informatica Mappings.
• Strong technical and professional client interactional skills. Interacted with Technical, Functional & Business audiences across different phases of the project of life cycle.
• Excellent communication skills, strong decision making skills, organizational skills, Quick learner and adaptive to new and challenging environments.
• Recognized for reliability, team work, persistence and strong work ethics.
• Good Knowledge of Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).

TECHNICAL ENVIRONMENT:

Operating System: Windows, Windows NT 4.0, UNIX, MS DOS.

GUI: SQL Loader, Toad for Oracle, SQL*plus, SQL developer, iSQL*plus

Database: Oracle 9i/10g/11g, SQL Server 2005/ 2008, MySQL, MS-Access 97/2000

Modeling Techniques: Normalized Relational modeling, Dimensional modeling, Star Schema, Snowflake Schema.

Data Modeling: Erwin 4.5/4.0, Microsoft Visio, SSIS, SSRS, SSAS.

Scheduling Tool: Oracle DBMS Scheduler, Informatica Scheduler:

Data Warehousing Tools: Informatica Power center 8.6/9.1, Informatica Data Quality (IDQ), SSIS 2005.

Reporting Tool: Business Objects, Cognos, Crystal reports

Programming Language: SQL, PL/SQL, UNIX shell scripting, T-SQL, C#, C, C++, HTML, VB Script

PROFESSIONAL EXPERIENCE

Confidential, TX

ETL Informatica Developer

Responsibilities:

• Analysed the existing reporting applications, documentation, and research findings to prepare a recommendation through a logical approach that includes: drafting future state diagrams, detailing assumptions and preparing a risk assessment to support the integration process strategy.
• Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business.
• Extracted data from Flat files, DB2, SQL and Oracle to build an Operation Data Source (ODS). Applied business logic to load the data into Global Data Warehouse.
• Created Tables, Keys (Unique and Primary) and Indexes in the SQL server.
• Extensively worked on Facts and Slowly Changing Dimension (SCD) tables.
• Transform the Oracle PL/SQL packages logic into the ETL design for the EDW Teradata.
• Designed and developed several complex mapping involving Filter, Router, Expression, Lookup (connected and unconnected), Aggregator, Sequence Generator, Update Strategy, Joiner, Normalizer, Sorter and Union to develop robust mappings in the Informatica Designer.
• Writing PL/SQL packages, stored procedures and functions using new PL/SQL features like Collections, Objects, Object Tables, Nested Tables, External Tables, Merge, Intersect, Minus, Bulk Into and Dynamic SQL commands.
• Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.
• Define the Data Quality and assurance objective process to support the Data conversion and integration processes which were not just restricted to data source selection, input criteria, defining the boundaries, clarity and completeness for the output data.
• Data profiling to understand the existing data and its properties and generating report to support the defining Data quality and enrichment approach.
• Worked on complex Source Qualifier queries, Pre and Post SQL queries in the Target.
• Worked on different tasks in Workflow Manager like Sessions, Events raise, Event wait, Decision, E-mail, Command, Worklets, Assignment, Timer and Scheduling of the workflow.
• Extensively used workflow variables, mapping parameters and mapping variables.
• Created sessions, batches for incremental load into staging tables and scheduled them to run daily.
• Used shortcuts to reuse objects without creating multiple objects in the repository and inherit changes made to the source automatically.
• Modified existing mappings for enhancements of new business requirements.
• Implemented performance tuning logic on Targets, Sources, Mappings and Sessions to provide maximum efficiency and performance.
• Involved in Unit, Integration, System, and Performance testing levels.
• Created detailed Unit Test Document with all possible Test cases.
• Provided support to develop the entire warehouse architecture and plan the ETL process.
• Used IDQ transformations like Parser, Standardizer, Match and Consolidation transformations for cleansing of data and loaded into stage tables.
• Created SQL Server Reports based on the requirements using SSRS 2012
• Created SSIS packages to load data into Data Warehouse using Various SSIS Tasks like Execute SQL Task, bulk insert task, data flow task, file system task.
• Involved in writing UNIX shell scripts to run and schedule batch jobs.
• Created and maintained UNIX shell scripts for pre/post session operations and various day-to-day operations.
• Developed Automation Shell Script programs for the job automation in UNIX environment to avoid manual intervention.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Prepared migration document to move the mappings from development to testing and then to production repositories.
• Managed work assignments and coordinated within the development team.

Environment: Informatica Power center 9.1, Informatica Data Quality (IDQ), Oracle10g, PL/SQL, UNIX shell scripting, MS Excel, Business Objects, Informatica Scheduler, MS Access, TOAD, MS SQL, Flat Files.

Confidential, Atlanta, GA

ETL Informatica developer

Responsibilities:

• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
• Co-ordinate with team members for effective management for all project requirements and responsible for deliverables and receivables during all project phases.
• Used Informatica Power Center for (ETL) extraction, transformation and loading data from heterogeneous source systems.
• Developed design strategy to extract data from flat files and Oracle, and to load the data into the target database.
• Extracted data from different sources like Oracle, SQL Server, DB2 and Flat files loaded into DWH.
• Design and develop SSIS packages, store procedures, configuration files, tables, views, and functions; implement best practices to maintain optimal performance.
• Utilized SSIS (SQL Server Integration Services) to produce a Data Warehouse for reporting.
• Develop mappings transformations like Filter, Joiner, Sequence Generator and Aggregator and perform query overrides in Lookup transformation as and when required to improve the performance of the mappings.
• Studied the existing OLTP system(s) and Created facts, dimensions and star schema representation for the data mart.
• Extensively worked on the performance tuning of the Informatica PowerCenter Mappings as well as the tuning of the sessions.
• Created Stored Procedures for data transformation purpose.
• Created Tasks, Workflows, Worklets to move the data at specific intervals on demand using Workflow Manager and Workflow Monitor.
• Scheduled to automate the update processes and Informatica Workflows.
• Wrote PL/SQL procedures for processing business logic in the database.
• Tuned SQL queries for better performance.
• Worked with database connections, SQL joins, cardinalities, loops, aliases, views, aggregate conditions, parsing of objects and hierarchies.
• Managed complex many-to-many relationships and hierarchies of parent customer and mortgage.
• Designed workflows with many sessions with decision, assignment task, event wait and event raise tasks used informatica scheduler to schedule jobs.
• Monitored all the sessions that are scheduled, running completed and failed. Involved in debugging the Mappings which are failed.
• Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations.
• Created and used Debugger sessions to debug sessions and created breakpoints for better analysis of mappings.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.
• Involved with the testing team to build the Test plans.

Environment: Informatica Power Center 9.1/8.6, Oracle 10g, Informatica Scheduler, PL/SQL, SQL, SQL Server, DB2, Windows XP.

Confidential, Dallas, Texas

Informatica Developer

Responsibilities:

• Designed ETL processes using Informatica to load data from Flat Files, and Excel files to target Oracle Data Warehouse database.
• Performed data manipulations using various Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, and Sequence Generator, Stored Procedure etc.
• Used SQL overrides in source Qualifier to meet business requirements.
• Written pre session and post session scripts in mappings. Created sessions and workflows for designed mappings. Redesigned some of the existing mappings in the system to meet new functionality.
• Created and used different tasks like command and email tasks for session status.
• Used Workflow Manager to create Sessions and scheduled them to run at specified time with required frequency.
• Monitored and configured the sessions that are running, scheduled, completed and failed.
• Responsible for testing, modifying, debugging, documenting and implementation ofInformatica mappings.
• Performed metadata validation, reconciliation and appropriate error handling inETLprocesses.
• Managed complex many-to-many relationships and hierarchies of parent customers and mortgage.
• Gathered consolidated records of mortgage customers in the bank.
• Used pmcmd commands to run the Informatica mappings using Unix Scripts.
• Used Informatica Mapping Debugger to check the logical errors while doing data Validation.
• Responsible for performance tuning inInformatica Power Centerat the Target Level, Source level, Mapping Level, Session Level, and System Level.
• Maintained relationships with assigned customers post integration support their needs and build the relationship to encourage future growth of business with the customer.
• Created complex reports that had multiple pages, multipleUI itemslike lists, charts, graphs.

Environment: Informatica 8.6, PL/SQL, Oracle 10g, Oracle DBMS Scheduler UNIX, Windows XP.

Confidential, Texas

ETL Informatica Developer

Responsibilities:

• Interacted with the business community and database administrators to identify the business requirements and data realties.
• Responsible for dimensional modeling of the data warehouse to design the business process.
• Parsing high-level design specification to simple ETL coding and mapping standards.
• Designed new database tables to meet business information needs. Designed Mapping document, which is a guideline to ETL Coding.
• Documented standards handbook for Informatica code development.
• Developed a number of Informatica Mappings, Mapplets and Transformations to load data from relational and flat file sources into the data warehouse.
• Used SQL queries and database programming using PL/SQL (writing Packages, Stored Procedures/Functions, and Database Triggers).
• Used various transformations like Source Qualifier, Lookup, Update Strategy, Router, Filter, Sequence Generator, and Joiner on the extracted source data according to the business rules and technical specifications.
• Loaded the data from IMS files into oracle tables using informatica with any data cleansing required.
• Worked on SQL tools like TOAD to run SQL queries and validate the data.
• Worked on database connections, SQL Joins, views in Database level.
• Extensively used SQL*Loader to load Data from flat files to Database tables in Oracle.
• Used Power Center server manager/Workflow manager for session management, database connection management and scheduling of jobs to be run in the batch process.
• Implemented Slowly Changing Dimensions to update the dimensional schema.
• Implemented procedures/functions in PL/SQL for Stored Procedure Transformations.
• Monitored workflows and collected performance data to maximize the session performance.
• Documented the mapping process and methodology used to facilitate future development.

Environment: Informatica 8.6, PL/SQL, Oracle 10g, UNIX, Windows XP.

Confidential

Oracle Developer

Responsibilities:

• Involved in creation ofschemaobjects like indexes, views, stored procedures and synonyms.
• Involved in the analysis of how the purchase order process was organized. Involved in a team in designing the database schema for the metadata for storing the informative queries that are generated dynamically.
• Involved in writingTriggerswhich internally called procedures and functions.
• Involved intestingthe database for queries that were generated and handled the performance issues effectively.
• Provided database maintenance, resolved technical problems in respect to performance of the database such as tuning SQL statements.
• Involved in functional specification, test plan and Documentation.

Environment: MSSQL, Oracle 9i, SQL*plus, i*SQL, PL/SQL, Windows XP, SQL*Loader,