SUMMARY

• 7+ years of overall with good analytical and programming skills.
• 5+ years of experience in using Informatica Powercenter (9.x/8.x/7.x).
• Extensive experience with data sources ranging such as Oracle, MSSQL, Teradata and also worked on integrating data from flat files, CVS files, and XML files into common reporting and analytical Data Model.
• Strong experience in ETL Process using Informatica Power Designer, Server Manager, Repository Manager.
• Experience in working with Slowly Changing Dimensions (type1, type2).
• Knowledge on Change Data Capture (CDC) mechanism.
• Experience in complete SDLC of applications.
• Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Powercenter.
• Experience with dimensional modeling using star schema and snowflake models.
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Created UNIX shell scripts to run the Informatica workflows and controlling the ETL flow.
• Strong with relational database design concepts.
• Proficient in oracle 12c/11g/10g/9i/8i in writing and using SQL Queries, SQL * Loader, Stored Procedures, Triggers, Materialized Views, Cursors, Ref cursor, Bulk Collect, Collections, Partitioning, Exception handling and Optimization tuning techniques using Explain Plan, SQL Trace.
• Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks.
• Involved in QA testing of ETL jobs.
• Independently perform complex troubleshooting, root - cause analysis and solution development.
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
• Team player, Motivated, able to grasp things quickly with analytical and problem solving skills.
• Comprehensive technical, oral, written and communicational skills

TECHNICAL SKILLS

Operating Systems: Windows, Linux, HP-UX

Software/Applications: MSXP, MS 2000, MS Word, MS Excel, MS Access, Outlook, PowerPoint

ETL: Informatica Powercenter 9.x/8.x/7.x,Metadata Manager, SSIS 2008/2005, Informatica Power Exchange

Databases: Oracle12c/11g/10g/9i, SQL Server 2008/2007/2005 , Teradata.

OLAP/BI tools: Cognos 8Series

Languages: SQL, PL/SQL, Perl & ksh Shell Scripting, C++, Core Java, HTML, XML

Tools: TOAD, SQL Developer, Oracle Form Developer, Oracle Report Developer, SQL*plus, SQL Loader

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

ETL Informatica developer

Responsibilities:

• Developed ETL programs using Informatica to implement the business requirements.
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.
• Created new mapping designs using various tools in Informatica designer like Source Analyzer, Warehouse Designer, Mapplet Designer, and mapping Designer.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router lookup, connected/unconnected, and filter.
• Developed workflow using task developer, Worklet designer and workflow designer in workflow manager and monitored the results using workflow monitor.
• Involved in enhancements and maintenance activities of the data warehouse including tuning, modifying of stored procedures for code enhancements.
• Effectively worked in Informatica version based environment and used deployment groups to migrate the objects.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used Informatica scheduler to schedule jobs.
• Created, tested and debugged the Stored Procedures, Functions, Packages, triggers and Cursors using PL/SQL.
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
• Implemented slowly changing dimension methodology for accessing the full history of customers.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Identified problems in existing production data and developed one time scripts to correct them.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.

Environment: Informatica Powercenter 9.5, Oracle 12c, HP-UX, Toad, SQL Plus, Erwin 9.2, Cognos.

Confidential, Phoenix, AZ

ETL Informatica developer

Responsibilities:

• Prepared technical specifications for the development of Informatica (ETL) mappings to load data into various target tables and defining ETL standards.
• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Develop the mappings using needed Transformations in Informatica tool according to technical specifications
• Created complex mappings that involved implementation of Business Logic to load data into staging area.
• Developed standard and re-usable mappings and mapplets using various transformations like expression, aggregator, joiner, source qualifier, router, lookup Connected/Unconnected, and filter.
• Developed mappings/sessions using Informatica Powercenter 9.1 for data loading.
• Created workflows and used various tasks like Email, Time Scheduler, Control, Decision and Session in the workflow manager.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregator, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Created, tested and debugged the Stored Procedures, Functions, Packages, Triggers and Cursors using PL/SQL.
• Execution of jobs using “Control-M” tool for scheduling and monitoring UNIX Scripts/Jobs.
• Building Reports according to user Requirement.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Extracted data from Oracle and SQL Server then used Teradata for data warehousing.
• Implemented slowly changing dimension methodology for accessing the full history of accounts.
• Wrote Shell script for workflows in UNIX environment.
• Optimizing performance tuning at source, target, mapping and session level.

Environment: Informatica Powercenter 9.x, Oracle 11g, SQL Server 2008/2005, Teradata 14, Teradata SQL assistant, Toad, SQL Plus, Erwin 8, HP-UX.

Confidential, Indianapolis, IN

ETL Developer

Responsibilities:

• Used Informatica Powercenter for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
• Involved in extracting the data from the Flat Files and Relational databases into staging area.
• Developed Informatica Mappings and Reusable Transformations to facilitate timely Loading of Data of a star schema.
• Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.
• Created Sessions and extracted data from various sources, transformed data according to the requirement and loading into data warehouse.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Router and Aggregator to create robust mappings in the Informatica Powercenter Designer.
• Extensively worked on Views, Stored Procedures, Triggers and SQL queries for loading the data before feeding the flat files.
• Imported various heterogeneous files using Informatica Powercenter 8.x Source Analyzer.
• Developed several reusable transformations and mapplets that were used in other mappings.
• Created simple list reports, cross-tab reports and Drill through reports using Impromptu.
• Prepared Technical Design documents and Test cases.
• Involved in Unit Testing and Resolution of various Bottlenecks came across.
• Implemented various Performance Tuning techniques.

Environment: ETL, Informatica (Powercenter 8.5.1/8.6.0 ), Informatica Power Exchange 8.1.1, Oracle 11g, SQL Server 2008, Windows XP, Shell Scripting, Cognos Impromptu & Powerplay7.x and TOAD.

Confidential

Oracle Developer/ETL Developer

Responsibilities:

• Developed Oracle PL/SQL packages, procedures, triggers, and functions.
• Coded Oracle SQL to create ad-hoc reports on an as-needed basis.
• Generated server sidePL/SQL scriptsfordata manipulationand validation.
• Worked on SQL*Loaderto load data from flat files obtained from various facilities every day.
• Used standard packages likeUTL FILE, DMBS SQL, and PL/SQLCollections and usedBULKBinding involved in writing database procedures, functions and packages for Front End Module.
• Worked extensively on Ref Cursor, External Tables and Collections.
• Involved in the continuous enhancements and fixing of production problems.
• Involved in supporting and maintaining Oracle Import, Export and SQL*Loader jobs.
• Involved in supporting and maintaining UNIX shell script jobs.
• Used Informatica Powercenter for (ETL) extraction, transformation and loading data from heterogeneous source systems into target database.
• Created mappings using Designer and extracted data from various sources, transformed data according to the requirement.
• Involved in extracting the data from the Flat Files and Relational databases into staging area.
• Developed the Informatica Mappings by usage of Aggregator, SQL overrides usage in Lookups, source filter usage in Source qualifiers, and data flow management into multiple targets using Router.

Environment: Oracle 10g/11g, PL/SQL, SQL*LOADER, SQL PLUS, TOAD, Informatica Powercenter 8.1.

Confidential

Oracle developer

Responsibilities:

• Created Tables, Views, Constraints.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developed materialized views for data replication in distributed environments.
• Loaded data into Oracle tables using SQL Loader.
• Involved in performance tuning of PL/SQL.
• Created Packages and Procedures to automatically drop the table indexes and create indexes for tables.
• Worked extensively on Ref cursor, External tables and Collections.
• Expertise in Dynamic SQL, Collections and Exception handling.
• Wrote UNIX scripts for the business needs.
• Developed Forms and reports using Oracle form Builder and Report Builder.

Environment: Oracle 9i/10g, PL/SQL, SQL*LOADER, SQL PLUS, TOAD, SQL Developer, Oracle report Builder, Oracle Form Builder.