SUMMARY

• Having 9 years of experience in Data warehouse Design, Development and Testing using ETL tools Informatica 9.5.1/8.6.1/7.5/6.1 with 7 years, Ascential Data stage 7.5.1/8.1 with 2 to 3 years, IBM Infosphere SQW and Teradata V2R6 with around 2 years of experience and Informatica B2B with 4 months of experience.
• Experience in analyzing the data generated by the business process, defining the granularity, source to target mapping of the data elements, creating Indexes and Aggregate tables for the data warehouse design and development.
• Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using ETL tool Data Stage (Ver8.0/7), designing and developing jobs using Data Stage Designer, Data Stage Manager, Data Stage Director and Data Stage Debugger
• And also with ETL tool Informatica (ver8.6.1) using Power Center Designer, Workflow Manager, Workflow Monitor
• Proficiency in developing SQL with various relational databases like Oracle, SQL Server, IBM DB2.
• Knowledge in Full Life Cycle development of Data Warehousing.
• Implementation Of full lifecycle in Data warehouses and Business Data marts with Star Schemas, Snowflake Schemas, SCD & Dimensional Modeling
• 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.
• Strong with relational database design concepts.
• Extensively worked with Informatica performance tuning involving source level, target level and map level bottlenecks.
• Efficient in all phases of the development lifecycle, coherent with Data Cleansing, Data Conversion, Performance Tuning and System Testing.
• Efficient in in corporation of various data sources such as Oracle, MS SQL Server, and DB2, Flat files into the staging area.
• Extensively used Powercenter Exchange to connect to different applications on Informatica.
• Experience in Mapping Server Jobs in Data Stage, Mappings in Informatica to populate tables in Data warehouse and Data marts
• Proven track record in addressing production issues like performance tuning and enhancement.
• Strong in Data warehousing concepts, dimensional Star Schema and Snowflakes Schema methodologies.
• Very Proficient on Architecture of ETL tools Informatica, Teradata and Datastage.
• Strong in Database concepts and good experience in writing complex SQL queries and Optimizing for better performance.
• Expert in unit testing, system integration testing, implementation, maintenance and performance tuning.
• Experience in different Scheduling tools like Maestro, Tivoli and Cron - tabs for automation of scheduling the jobsrun.
• Experience in UNIX Shell Scripting.
• Excellent knowledge of operating systems Windows, UNIX, Macintosh, and databases including Oracle, SQL Server, and DB2.
• Detail oriented with good problem solving, organizational, analysis, highly motivated and adaptive with the ability to grasp things quickly
• Ability to work effectively and efficiently in a team and individually with excellent interpersonal, technical and communication skills.
• Having a good knowledge on ERP applications PeopleSoft Financials, Human Resources,OBIEE, Hadoop and Informatica MDM Hub Server

TECHNICAL SKILLS

DWH ETL Tools: Informatica V9.5.1, 8.5.1,7.5.6, Informatica B2B MFT 9.5.1, Ascential Data Stage V8.1 (Designer, Director, Manager), IBM Infosphere SQW and Teradata V2R6,V2R12

RDBMS: IBM DB2, Oracle 8i/9i/10g, SQL Server 2005/2008, Netezza

Files: Microsoft Visio, MS word, MS Excel, XML and Flat Files.

BI Reporting Tools: SAP Business Objects 6.1, IBM Cognos 8.0, SAS Reporting tool.

Programming Languages/Scirpting: Unix Shell Scipting, PL/SQL, Java, C

Operating Systems: IBM AIX UNIX, Windows 8/7/Vista/NT/XP.

PROFESSIONAL EXPERIENCE

Confidential, Warwick, RI

Senior Informatica Developer

Responsibilities:

• Involved in understanding of architecture design part and various integration levels of different teams and business processes and data model design
• Have prepared requirement understanding documents at the time of estimation on planning on design and implementation of ETL flows as per the business flow
• Involved with B2B team to prepare the workflows on automation of file transfer from one sponsors to different teams and shown a sample prototype to the client manager which generates a control file metadata on all processed source files
• Created Profiles, Partners, Endpoints, Accounts, workflows and configured the Prototype using Informatica B2B platform and created the prototype using DX transformations and JMS source and target transformations along with general transformations like Expression, Sequence Generator, SQL Transformations etc.
• Given a Demo to a client on automation of file tracking process and how to track the source file by generated events
• Studied the existing data sources with a view to know whether they support the required reporting and generated change data capture request.
• Extensively worked on Informatica mappings for splitting bulk data into subsets and to dynamically distribute to all available processors to achieve best job performance.
• Developed ETL jobs as per business rules using ETL design document
• Involved in creating sessions and Workflows using Informatica Workflow Manager
• Involved in Performance Tuning at mapping level and session level
• Involved in Developing Mappings and Mapplets using Informatica Designer Tool
• Used complex transformations like Lookup, Update Strategy, Sequence Generator and Stored Procedure while developing Mapplets and Mappings using Informatica Designer Tool.
• Used Informatica mappings to load data from Source to Target.
• Enhanced the reusability of the sessions across different workflows.
• Performed performance tuning of the jobs by interpreting performance statistics of the jobs developed.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, regression testing, prepared test data for testing, error handling and analysis.

Environment: Informatica 9.5.1, Informatica B2B, Flat Files, Netezza, SQL, PL/SQL, UNIX, SAS, Windows XP

Confidential, Nevada, CA

Senior Informatica Developer

Responsibilities:

• Involved in understanding of business processes and coordinated with business analysts to get specific user requirements.
• Studied the existing data sources with a view to know whether they support the required reporting and generated change data capture request.
• Extensively worked on Informatica mappings for splitting bulk data into subsets and to dynamically distribute to all available processors to achieve best job performance.
• Worked with PeopleSoft OLTP database and connected through Application Connection on Informatica
• Developed ETL jobs as per business rules using ETL design document
• Involved in Creating sessions and Workflows using Informatica Workflow Manager
• Involved in Performance Tuning at mapping level and session level
• Involved in Developing Mappings and Mapplets using Informatica Designer Tool
• Used complex transformations like Lookup, Update Strategy, Sequence Generator and Stored Procedure while Developing Mapplets and Mappings using Informatica Designer Tool.
• Used Informatica mappings to load data from Source to target.
• Enhanced the reusability of the sessions across different workflows.
• Performed performance tuning of the jobs by interpreting performance statistics of the jobs developed.
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, regression testing, prepared test data for testing, error handling and analysis.

Environment: Informatica 7.6.1, Flat files, IBM DB2, Oracle10g, SQL Server -2005/2008, Green Plum, PL/SQL, UNIX, Windows NT/XP

Confidential, Nashville, TN

Senior Informatica Developer

Responsibilities:

• Involved in understanding of business processes and coordinated with business analysts to get specific user requirements.
• Extensively worked on Informatica mappings for splitting bulk data into subsets and to dynamically distribute to all available processors to achieve best job performance.
• Developed ETL jobs as per business rules using FRD and ETL design document
• Involved in Creating sessions and Workflows using Informatica Workflow Manager
• Involved in Performance Tuning at mapping level and session level
• Involved in Developing Mappings and Mapplets using Informatica Designer Tool
• Used complex transformations like Lookup, Update Strategy, Sequence Generator and Stored Procedure while Developing Mapplets and Mappings using Informatica Designer Tool.
• Used Informatica mappings to load data from Source to target.
• Enhanced the reusability of the sessions across different workflows.
• Imported the data residing in the host systems into the data mart developed in Teradata DB using Fast Import scripts.
• Written complex SQL queries using joins, sub queries and correlated sub queries.
• Involved in creating the database views, stored procedures etc.
• Performed Unit testing and System Integration testing by developing and documenting the test cases
• Validated the report generated using Business Objects using PL/SQL queries.

Environment: Informatica 8.1,Teradata V2R6, Oracle 10g, SQL, PL/SQL, UNIX, Business Objects 6.1, Windows 2003.

Confidential

Senior Data Stage and Infosphere SQW Developer

Responsibilities:

• Interacted with End user to understand the business requirements and in identifying data sources.
• Analyzed the existing informational sources and methods to identify problem areas and make recommendations for improvement. This required a detailed understanding of the data sources and researching possible solutions.
• Helped in preparing the mapping document for source to target.
• Worked with Data stage Manager for importing metadata from repository, new job Categories and creating new data elements
• Designed and developed ETL processes using Data Stage designer to load data from Oracle, MS SQL, Flat Files (Fixed Width) and XML files to staging database and from staging to the target Data Warehouse database.
• Used Data Stage stages namely Hash file, Sequential file, Transformer, Aggregate, Sort, Datasets, Join, Lookup, Change Capture, Row Generator stages in accomplishing the ETL Coding.
• Developed job sequencer with proper job dependencies, job control stages, triggers.
• Excessively used DS Director for monitoring Job logs to resolve issues
• Documented ETL test plans, test cases, test scripts, and validations based on design
• Specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis. Verified the SAP BO Report by extracting Participated in weekly status meetings.
• Taken complete role of Migration from Datastage to Infosphere SQW.
• Designed Control Flows, Sub processes, Dataflows in Infosphere SQW
• Created single Master Control Flow for all dimensions by incorporating some dimensions to run in parallel using parallel container step and all dimensions based on their dependency and time priority
• Automated some run time parameters in Infosphere SQW.

Environment: IBM Ascential Data Stage client 7.5.1 (Designer, Director, Manager), Infosphere SQW, IBM DB2, Oracle 10g, SQL Server 2008, Flat files, Sequential files, AIX UNIX, SAP Business Objects.

Confidential

Data Stage Developer

Responsibilities:

• Interacted with Business Analyst to understand the business requirements and in identifying data sources.
• Analyzed the existing informational sources and methods to identify problem areas and make recommendations for improvement. This required a detailed understanding of the data sources and researching possible solutions.
• Helped in preparing the mapping document for source to target
• Worked with Data stage Manager for importing metadata from repository, new job Categories and creating new data elements
• Designed and developed ETL processes using Data Stage designer to load data from Oracle, MS SQL, Flat Files (Fixed Width) and CSV files to staging database and from staging to the target Data Warehouse database.
• Used Data Stage stages namely Hash file, Sequential file, Transformer, Aggregate, Sort etc stages in accomplishing the ETL Coding.
• Developed job sequencer with proper job dependencies, job control stages, triggers.
• Excessively used DS Director for monitoring Job logs to resolve issues
• Documented ETL test plans, test cases, test scripts, and validations based on design specifications for unit testing, system testing, functional testing, prepared test data for testing, error handling and analysis. Verified the Cognos Report by extracting data from the Staging Database using SQL queries Participated in Weekly Status Meeting.

Environment: IBM Ascential Data Stage client 7.5.1 (Designer, Director, Manager), Oracle 10g,SQL Server 2008,IBM DB2, Greenplum, Flat files, Sequential files, AIX UNIX, IBM Cognos 8.0

Confidential

Informatica & Teradata Developer

Responsibilities:

• Involved in understanding of business processes to learn business requirements.
• Extracted data from different systems into Source. Mainly involved in ETL developing.
• Extensively worked on Informatica mappings for splitting bulk data into subsets and to dynamically distribute to all available processors to achieve best job performance.
• Developed ETL jobs as per business rules using ETL design document
• Involved in Creating Sessions and Workflows using Informatica Workflow Manager
• Involved in Performance Tuning at mapping level and session level
• Involved in Developing Mappings and Mapplets using Informatica Designer Tool
• Validated the data during the migration of reports from BO to SAS Reporting Tool.
• Involved in working with using source control systems such as VSS, CVS or TFS
• Worked on SQL Assistant to write the SQL queries.
• Involved in writing scripts for loading data from source system to target data warehouse for BTEQ, Fastload and Multiload.
• Used complex transformations like Lookup, Update Strategy, Sequence Generator and Stored Procedure while Developing Mapplets and Mappings using Informatica Designer Tool.
• Used Informatica mappings to load data from Source to target.

Environment: Informatica (Ver 7.5.1), Teradata V2R6, MS Access, SAS Reporting Tool, SQL-Server 2000/2005,SQL, PL/SQL, Toad

Confidential

Informatica & Teradata Developer

Responsibilities:

• Involved in understanding of business processes to learn business requirements.
• Extracted data from different systems into Source mainly involved in ETL developing.
• Defined and implemented approaches to load and extract data from database using Informatica transformations.
• Involved in writing scripts for loading data from source system to target data warehouse for BTEQ, Fastload and Multiload.
• Worked on SQL Assistant to create, modify new and existing reports.
• Validated the data during the migration of reports from BO to SAS Reporting Tool.
• Imported the data from different source systems to target tables using Fast Import scripts.
• Worked on SQL Assistant to create, modify new and existing reports.

Environment: Informatica 7.5.1, Teradata V2R6, MS Access, SAS Reporting Tool, SQL-Server 2000/2005,SQL, PL/SQL, Toad, UNIX, Windows NT