SUMMARY:

• 7 and ½ years of IT experience in Analysis, Design, Development, Implementation, Testing and Support of Data Warehousing and Data Integration Solutions using Informatica PowerCenter.
• Proficiency in developing SQL with various relational databases like Oracle, SQL Server.
• Knowledge in Full Life Cycle development of Data Warehousing.
• Strong experience with Informatica tools using real - time CDC (change data capture) and MD5.
• Have extensively worked in developing ETL program for supporting Data Extraction, transformations and loading using Informatica Power Center.
• 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.
• Developed OLAP applications using Cognos 8BI - (Frame Work Manager, Cognos Connection, Report Studio, Query Studio, and Analysis Studio) and extracted data from the enterprise data warehouse to support the analytical and reporting for Corporate Business Units.
• Proficient in Optimizing Database querying, data manipulation and population using SQL PL/SQL and Utilities in Oracle 11g/10g/9i, Teradata 14/13, DB2 UDB and SQL Server 2008/2000, Sybase databases.
• Strong with relational database design concepts.
• Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks.
• Strong business understanding of verticals like Banking, Brokerage, Insurance, Mutual funds and Pharmaceuticals.
• 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.
• Experience in integration of various data sources like Oracle, Teradata, Netezza, Mainframes, SQL server, XML, Flat files and extensive knowledge on Oracle, Teradata, Netezza and MS Access.
• Realistic understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter9.x/8.x, Informatica PowerExchange 9.x/8.x, Informatica DataQuality 9.x/8.x

Databases: Oracle 11g/10g, IBM UD2 DB2, MS SQL Server 2008 / 2012, MS Access 2000, Teradata13/12/V2R5, Netezza 9

Programming Languages: C, C++, SQL, PL/SQL, UNIX, XML, Unix Shell Scripts

DB Tools: TOAD, SQL Navigator, SQL* Loader, SQL Management Studio, SQL Assistance

Mythologies: SDLC, Agile

Software: WebSphere Studio Application Developer 5.x, Sun One Studio,Macromedia DreamWeaver3.0, ColdFusion, SQL Navigator, Toad, Erwin

Operating Systems: Sun Solaris8.0/10.0, Windows XP/7, AIX, LINUX

OLAP/BI Tools: Cognos 8 Series

Others: Erwin 5.1/4.1.2, TOAD, OBIEE 10g,SQL Loader, MS Office, Smart FTP, Ultra Edit, Autosys,Control-M, HP Quality Center, MS Visio, Autosys, Erwin 9.3, Business Objects 6.0

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

ETL Informatica developer

Responsibilities:

• Developed ETL programs using Informatica to implement the business requirements.
• Communicated with business customers to discuss the issues and requirements.
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• Used Informatica file watch events to pole the FTP sites for the external mainframe files.
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
• Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• 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.
• Effectively worked on Onsite and Offshore work model.
• Pre and post session assignment variables were used to pass the variable values from one session to other.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used informatica scheduler to schedule jobs.
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
• 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.6.5, Informtica PowerExchange 9.6, Excel, Netezza, Teradata 14, DB2, UDB, PL/SQL 2012, UNIX, Shell, IDQ.

ETL Informatica developer

Responsibilities:

• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
• 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 in to staging area.
• Used Informatica reusability at various levels of development.
• Developed mappings/sessions using Informatica Power Center 8.6 for data loading.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, 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.
• Building Reports according to user Requirement.
• Extracted data from Oracle and SQL Server then used Teradata for data warehousing.
• Write Shell script running workflows in Unix environment.
• Optimizing performance tuning at source, target, mapping and session level
• Participated inweeklystatus meetings, and conducting internal andexternal reviews as well as formal walk through among various teams and documenting the proceedings.

Environment: Informatica PowerCenter 9.5, Informatica PowerExchange 9.5, IDQ 9.X, Teradata 13, Oracle 11g, Windows NT.

ETL Developer

Responsibilities:

• Used Informatica Power Center 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.
• Mappings, Sessions, Workflows from Development to Test and then to UAT environment.
• 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 Power Center Designer.
• Imported various heterogeneous files using Informatica Power Center 8.x Source Analyzer.
• Developed several reusable transformations and mapplets that were used in other mappings.
• Prepared Technical Design documents and Test cases.
• Involved in Unit Testing and Resolution of various Bottlenecks came across.
• Implemented various Performance Tuning techniques.
• Used Teradata as a source system.

Environment: Informatica PowerCenter 8.1, SQL, PL/SQL, UNIX, Shell Scripting, Teradata 13, SQL Server 2008, Sybase, Oracle 11g, DB2, Control-M,Cognos8.4.

ETL Informatica developer

Responsibilities:

• Involved in design, development and maintenance of database for Data warehouse project.
• Involved in Business Users Meetings to understand their requirements.
• Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration with Informatica 7.X.
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Created complex mappings which involved Slowly Changing Dimensions, implementation of Business Logic and capturing the deleted records in the source systems.
• Worked extensively with the connected lookup Transformations using dynamic cache.
• Worked with complex mappings having an average of 15 transformations.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once
• Monitored Workflows and Sessions using Workflow Monitor.
• Performed Unit testing, Integration testing and System testing of Informatica mappings
• Coded PL/SQL scripts.
• Wrote Unix scripts, perl scripts for the business needs.
• Coded Unix Scripts to capture data from different relational systems to flat files to use them as source file for ETL process
• Created Universes and generated reports on using Star Schema.

Environment: Informatica PowerCenter 8.6, Oracle 11g, UNIX

Informatica Developer/ Data Analyst

Responsibilities:

• Participated in Data Modeling meetings and worked on Dimension modeling.
• Created LDM and PDM through ERWIN and documented description of each components like Tables, columns, Indexes, Constraints and Dependencies.
• Created Dimension Tables and Fact Tables based on the warehouse design.
• Wrote Triggers and Stored Procedures using PL/SQL for Incremental updates.
• Integrated various sources into the Staging area to Integrate and Cleansing data.
• Involved in identifying bugs in existing mappings by analyzing data flow, evaluating transformations using Debugger.
• Worked extensively on designing Data Mapping flow from various source systems to target systems
• Involved in identifying Informatica bottleneck and Tuning various components of designer and workflow manager.
• Created Stored Procedures, Triggers, Functions, Views and Packages using PL/SQL.
• Developed different reports using Oracle Application Express and PL/SQL.
• Created scripts using SQL and PL/SQL to generate bulk data for testing team to test the performance of the application and the same data was used by DBA team to test the server performance.

Environment: Informatica PowerCenter 8.6,Oracle 11g, Teradata V2R5, Autosys, Toad, SQL, PL/SQL,Windows 2000, UNIX shell Scripts, LINUX, Mainframe.