SUMMARY:

• Over 8+ years of professional IT experience in Data warehousing, Design, Modeling, Development, Analysis, Implementation and Testing.
• Expert knowledge in working with Data Warehousing tools (ETL tools) like Informatica Power Center 9.x/8.x/7.x/6.x/5.x, Power Exchange.
• Extensively used Informatica Warehouse Designer to create and manipulate Source and Target definitions, Mappings, Mapplets and Transformations.
• Extensively worked on Informatica Power Center Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator.
• Have clear understanding of Data warehousing and Business Intelligence concepts with emphasis on ETL and life cycle development using Power Center, Repository Manager, Designer, Workflow Manager and Workflow Monitor.
• Expertise in Data warehousing concepts like OLTP/OLAP System Study, Analysis and E - R modeling, 3rd Normalized (3NF) developing database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional data modeling.
• Have work experience with Relational Data Modeling tool Erwin 7.0/4.2.
• Experienced in handling SCDs (Slowly Changing Dimensions) using Informatica.
• Over Seven Years of RDBMS experience using Oracle 11g/10g/9i/8i, MS SQL Server 2008/2005/2000, MS Access 2000, SQL (DQL, DML, DDL, TCL), PL/SQL (Stored Procedure, Function, Package, Trigger, Bulk Load, Autonomous Transaction, Exception Handling), XML and SQL Editor (SQL*Plus, TOAD).
• Extensively worked on Data migration, Data cleansing and Data Staging of operational sources using ETL processes and providing data mining features for data warehouses.
• Experience in implementing update strategies, incremental loads and Change Data Capture (CDC).
• Knowledge of complete Software Development Life Cycle(SDLC) including Requirement Analysis, Requirement Gathering, Cost Estimation, Project Management, Design, Development, Implementation and Testing.
• Involved in Full Life Cycle Development (Waterfall & Agile) of building a Data Warehouse on Windows and Unix Platforms for Investment Banking, Financial, Retail, and Insurance Industries.
• Experience in UNIX working environment, writing UNIX shell scripts for Informatica pre & post session operations.
• Experience in generating reports using(Reporting tools) COGNOS and BO
• Performed System Analysis and QA testing and involved in Production Support.
• Excellent communication and interpersonal skills. Ability to work effectively working as a team member as well as an individual.
• Self-motivated individual with strong Technical & Analytical skills. Always keen and eager to face up to challenges by means of novel and innovative ideas.

TECHNICAL SKILLS:

RDBMS: Oracle 8i / 9i/10g/11g, SQL Server 2003/2005/2008 R2/2012, MS Access, DB2, Teradata 13,Teradata 13.1/V2R5.

Data Warehousing Tools: Informatica PowerCenter 9.5.1/9.1.0/ 8.6/8.1, Business Objects 5.1/6.2, SSIS, SSRS, OBIEE, And Micro Strategy.

DataBase Tools: SQL Plus, Toad, SQL Navigator, PLSQL Developer, and Query Analyzer

Design / Application Tools: Erwin 3.5 / 4.2, ER Studio.

Programming / Scripting: SQL, PL/SQL, VC++, UNIX Shell Scripts, VBScript, Perl- Shell

Operating Systems: Windows7/ NT/2000/XP, UNIX, Sun Solaris V2.8

Methodologies: Data Modeling - Logical/Physical/Dimensional, Star/SnowflakeETL, OLAP, Complete software development cycle

Scheduling Tools: Control M, Autosys. CA7 Scheduler, Informatica Native Scheduler

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

Sr. Informatica Developer

Responsibilities:

• Worked closely with Business Analyst and the end users for understanding existing business model and customer requirements and involved in preparing the functional specifications based on the business requirement needs.
• Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes using Informatica power center.
• Expertise in building scripts using Transact-SQL for DDL and DML
• Developed stored procedures in T-SQL that were invoked to load dimensions and fact tables and also for Error handling during the ETL process
• Developed stored procedures in T-SQL that were invoked to load dimensions and fact tables and also for Error handling during the ETL process
• Used Tidal scheduler to get the source file from the server using Tidal flat file FTP connection as well as power center FTP connection.
• Created Merge statement update else insert T-SQL jobs.
• Designed & developed Informatica mappings, mapplets, worklets and workflows to create load-ready data files for loading Oracle E-Business Suite.
• Designed and developed Reports for the user Interface, according to specifications given by the Track leader.
• Created stored procedures (NZ-SQL).
• Scheduled the ELT load in Autosys.
• Debugged and corrected the xfr files developed by other ELT developers.
• Fixed numerous bugs with load issues.
• Optimized the NZ-SQL queries.
• Converted Oracle ddl’s to Netezza ddl’s.
• Created the format of the unit test documents per Netezza Framework.
• Assisted ELT developers in creating the unit test documents.
• Managed user and folder permissions for the developers.
• Purged old repository objects weekly.
• Created shell script for repository backup weekly.
• Developed data Mappings between source systems to Landing and from Standardization to warehouse components using Mapping Designer.
• Did performance tuning on the ELT code developed by ELT developers.
• Debugged the framework error logs.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Problem resolution involves resolving the issues raised by the client/actuarial users, validation of the data in the database or in the application functionality.
• Worked closely with QlickView Developers.
• Involved in performance tuning at source, target, mapping and session level.
• Loaded Oracle tables from XML sources.
• Configured Informatica for the SAP Connector.
• Extracted data from SAP and loaded into Oracle EBS
• Introduced the concept of Data Dashboard to track the technical details sighting the continuous requirement changes and rework needed.
• Optimized the BOXI dashboard SQL with aggregated and sub queries.
• Created and modified BO reports.
• Loaded the data into reporting layer based on the BOXI reporting requirements in facts and dimension tables.
• Created the business objects universes.
• Supported Integration testing by analyzing and fixing the issues.
• Created Unit Test Cases and documented the Unit Test Results.
• Resolved Skewness in Teradata.
• Analyzed some of the JCL scripts for job scheduling.
• Defined Interface parameters in Informatica mappings and sessions to initiate the concurrent programs (Stored Procedures) once the Interface tables are loaded.
• Integrated Data Quality routines in the Informatica mappings to standardize and cleanse the name, address, and contact information.
• Profiled customer data and identified various patterns of the phone numbers to be included in IDQ plans.
• Used Informatica web services to create work requests/work Items for the end user.
• Successfully Integrated Multiple XML sources and created a de-normalized, flat-structured file.
• Supported Integration testing by analyzing and fixing the issues.
• Created Unit Test Cases and documented the Unit Test Results.
• Created Stored Procedures to validate and load the data from interface tables to the Oracle E-Business Suite internal tables.
• Defined Interface parameters in Informatica mappings and sessions to initiate the concurrent programs (Stored Procedures) once the Interface tables are loaded.
• Staged data in Oracle E-Business Suite stage tables using Power Center in Informatica.
• Integrated Data Quality routines in the Informatica mappings to standardize and cleanse the name, address, and contact information.
• Profiled customer data and identified various patterns of the phone numbers to be included in IDQ plans.

Environment: Informatica Power Center 9.5.1, Informatica Data Quality 9.1, Oracle 11g, Netezza TwinFin 6 (Production),Netezza TwinFin 3 and Netezza Skimmer (Non-production), Business Objects XI Edition (BOXI) Reporting tool SQL Server 2012/2008 R2, Flat files, TOAD, Windows XP, Mainframe, Tidal scheduler.

Sr. Informatica Developer

Responsibilities:

• Requirement Gathering and Business Analysis
• Analyzed the data models of legacy implementations, identifying the sources for various dimensions and facts for different data marts according to star schema design patterns.
• Worked with multiple sources such as Relational Tables, Flat Files, Excel Sources, ERP (SAP-BW) sources for Extraction using Source Analyzer/PowerExchnage
• Extensively involved in the Analysis, Design and Modeling. Worked on Star Schema, Data Modeling, Data Elements
• Created CDC sources in Power Exchange and imported that into Power Center
• Designed the ETL process for extracting data from heterogeneous source systems, transform and load into Data Mart
• Created Logical and Physical models for production using Erwin 3.5.
• Worked with Informatica PowerConnect to get data from PeopleSoft XLATTABLE table and modules like General Ledger, Accounts Payable, Accounts Receivable, and Asset Management.
• Involved in Upgrading Informatica from version 7.1.3 to 8.1
• Created Informatica mappings with PL/SQL Procedures/Functions to build business rules to load data.
• Performance tuned the workflows by identifying the bottlenecks in targets, sources, mappings, sessions and workflows and eliminated them.
• Provided production support including error handling and validation of mappings, sessions and workflow.
• Extensively used Debugger Process to test data and applying Break Points while Session is running.
• Provided production support for Business Users and documented problems and solutions for running the workflow.
• Developed UNIX scripts for scheduling the jobs.
• Designed and developed Oracle PL/SQL Procedures.
• Performance tuning of Oracle PL/SQL Scripts
• Created Universe using Business Objects for pulling the data for analysis and reporting.

Environment: Windows NT, Teradata 13, Oracle 9i, Informatica Power center 9.1.0 /Power Exchange 8.1/7.1.3, SQL Assistant, SQL Developer, Business Objects 5.1.1, Business Query for Excel, ERWIN 3.5.2, PL/SQL, TOAD.

ETL Informatica/Talend Developer

Responsibilities:

• Translated business rules and functionality requirements into ETL procedures. Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy.
• Attended POC for Talend open studio.
• Created the ODS jobs using Talend Open Studio.
• Used Talend open studio to execute jobs for ODS.
• Debugged numerous issues in Talend.
• Worked closely with the administrators with the configuration of Talend Open studio.
• Developed and tested all the backend programs, Informatica mappings and update processes.
• Developed Informatica mappings to load data into various dimensions and fact tables from various source systems.
• Developed, tested stored procedures, Cursors, Functions and Packages in PL/SQL for Data ETL.
• Used Power Exchange along with Power Center to leverage data by avoiding manual coding on data extraction programs.
• Created various active and passive transformations like Source Qualifier, Lookup, Router, Normalizer, Aggregator, Filter, Joiner, Expression and standard/reusable mappings using Informatica.
• Made substantial contributions in simplifying the development and maintenance of ETL by creating re-usable Source, Target, Mapplets and Transformation objects.
• Responsible for developing and testing the new conformed dimensions that were used by the conformed fact.
• Used Power Center Workflow Manager to create sessions, and also used various tasks like session, event wait, event raise, email to run with the logic embedded in the mappings.
• Responsible for validating the Informatica mappings against the pre-defined ETL design standards.
• Developed incremental and updateable loading through Informatica mappings.
• Used debugger and breakpoints to view transformations output and debug mappings.
• Documented all the mappings and the transformations involved in ETL process
• Used UNIX shell scripting for scheduling tasks.
• Extracted huge volumes of data from legacy systems and uploaded into Oracle using SQL*Loader and shell scripts.

Environment: Informatica 8.6.1, Power exchange, Talend Open Studio 4.X/3.X, Oracle 8i, SQL Server, PL/SQL Developer 5.0, and UNIX shell scripts, PL/SQL, TOAD.

ETL Developer

Responsibilities:

• Developed, tested stored procedures, functions and packages in PL/SQL for Data ETL.
• Used ETL tool Informatica PowerCenter 5.1 and 6.2 to create maps to transform data
• Creating various active and passive transformations like source qualifier, Lookup, Router, Procedure, aggregator, filter, joiner, expression and standard and reusable mappings using Informatica
• Loaded operational data from heterogeneous sources into various data mart.
• Unit and integration tested Informatica Sessions, Batches, and Workflows.
• Documented the mappings and the transformations involved in ETL process.
• Involved in gathering business requirements, data sourcing and data transformation, data loading, SQL and performance tuning.
• Involved in writing UNIX scripts and used them to automate the scheduling process.
• Used mapping Wizards in creating slowly growing dimensions and slowly changing dimensions.
• Recommended, designed and implemented strategies for managing the data in data warehouse.
• Analyzed business requirements and worked closely with the various application teams and business teams to develop ETL procedures that are consistent across all applications and systems.
• Responsible for creating folders and giving privileges to the new users.
• Enhanced session performance, and improved response times, through extensive performance tuning of the mappings, ETL Procedures and processes.
• Responsible for querying data from different database tables as per the requirement.

Environment: Windows NT, Oracle 8i, Teradata 9, Informatica PowerCenter 8.6.1, SQL Assistant, SQL Developer, UNIX shell scripts, PL/SQL, TOAD.