SUMMARY:

• 7+ years of IT experience in the field of Data warehousing in tools like Informatica 8x, 9x, 10x Power Center, Power Exchange (5.x/8.x), Oracle, SQL Server, AWS,TDM, SSIS and UNIX Shell Scripting.
• Technical proficiency in the Data Warehousing teamed with Data Analysis, Data Modeling, Business Requirements Analysis, Application Design, Development & testing, Data profiling, data standardization & Quality Control and full life cycle Implementation of Data Warehouse.
• Expert in analyzing, designing, developing, installing, configuring and deploying MS SQL Server suite of products with Business Intelligence in SQL Server Reporting Services 2005/2008, SQL Server Analysis Services of 2005/2008 and SQL Server Integration Services.
• Extensively worked on Informatica Data Quality and Informatica Power center throughout complete Data Quality.
• Develop client proposals and present at stakeholder meetings. Forecast future trends and orient strategies to capture maximum benefits. Coordinate with sales executives to better align company goals and tactics.
• Experienced in implementing Organization DevOps strategy in various operating environments of Linux and windows servers along with cloud strategies of Amazon Web Services.
• Experienced with Informatica Power Exchange (5.x/8.x) for Loading/Retrieving data from mainframe systems.
• Experience in installation and configuration of core Informatica Hub components such as Hub Console, Hub Store, Hub Server, Cleanse Match Server and Cleanse Adapter in Windows.
• Involved in Requirement gathering, Data Analysis, Application Design, Data Modeling, Application Development, Implementations and Data Quality in different Data warehouse Projects.
• Experience in designing error and exception handling procedures to identify, record and report errors.
• Extensive Experience in developing and performance tuning of informatica mappings
• Experience in using Automation Scheduling tools like Autosys and Control - M.
• Created source to target mapping documents for input into ETL specifications by Identifying, analyzing data sources
• Extensively used SQL and PL/SQL for development of Procedures, Functions and Packages
• Involved in Developing UNIX shell Scripts to generate parameter files and executed oracle procedures as batch jobs.
• Created transformations such as Joiners, Lookups, Filters, Aggregator, Sequence Generators, according to the business rules
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting
• Experience in testing the data using debugging mapping method. Identified bugs in existing mappings by analyzing the data flow and evaluating transformations.
• Used SQL tools to run SQL queries to view and validate the data loaded into the warehouse and troubleshoot data issues.
• Effective working relationships with client team to understand support requirements, and effectively manage client expectations.

TECHNICAL SKILLS:

ETL Tools: Informatica 10.X/9.X/8.x (Power Center), BODS, Teradata SQL Assistant, TOAD, Putty

Data Modeling: Physical Modelling, Logical Modelling, Relational Modelling, Dimensional Modelling (Star Schema, Snow-Flake, Fact, Dimensions), Entities, Attributes

Databases: Oracle 12g/11g/10g/9i, MS SQL Server, MS Access

Languages: SQL, PL/SQL, Data Structures, Unix Shell Script

Tools: SQL plus, PL/SQL Developer, SQL* Loader

Operating Systems: Windows NT/2000/2003/XP/Vista/7, Unix, Linux

PROFESSIONAL EXPERIENCE:

Informatica Developer

Confidential - Beaverton, OR

Responsibilities:

• Gathering Business requirements and creating technical specifications along with creating Internal and External Design documents
• Create Technical specification documents and work with Business Analysts on analysis of multiple source systems data as part of ETL mapping exercise
• Created various mappings using different transformations in LDO's such as Union, Sorter, Joiner, Expression, Aggregator etc., transformations
• Extensively used Pre-SQL and Post-SQL scripts for loading the data into the targets according to the requirement.
• Created Batch scripts to call Informatica workflow's for number of times. Created different jobs using batch scripting to call the workflow by using Command tasks.
• Created Reusable transformations, Mapplets, Worklets using Transformation Developer, Mapplet Designer and Worklet Designer
• Executed Sessions, Sequential and concurrent batches for proper execution of mappings.
• Attended status meetings with project managers, escalated issues when necessary, attended meetings for issues resolution.
• Intimate about errors which is not relating to ETL and assigned to the concern person which is responsible for that error.
• Used parameters/variables for Powercenter mappings, sessions and workflows.
• Worked in Error Handling strategy. If any errors occurred the mapping should fail.
• Worked extensively with sources and target like Flat files, SQL Server tables
• To build efficient ETL components to meet the technical requirements

Environment: Informatica Power Center (Repository Manger, Designer, Workflow Monitor, Workflow Manager), Autosys, DB2, Oracle 12g, Siebel, TOAD, SQL*Plus, Windows, UNIX, Shell Scripting.

Informatica Developer

Confidential, McLean, VA

Responsibilities:

• Responsible for technical Design Document and Details mapping document
• Develop the mappings using needed Transformations in Informatica tool according to technical specifications
• Developed design documentation and implementation proposal for extraction of data from W data warehouse.
• Supporting the ETL Inbound for heterogeneous sources using ETL CDC (Change Data Capture) Mappings and scripts in Informatica Power center.
• Developed modules to extract process & transfer the customer data using Teradata utilities.
• Experienced with Informatica Power Exchange for Loading/Retrieving data from mainframe systems.
• Created Fast Export scripts for extracting and formatting customer data from data warehouse in a mainframe file.
• Created FTP Id to set up transmission path between mainframe and UNIX machine.
• Experience in several facts of MDM implementations including Data Profiling, Data extraction, Data validation, Data Cleansing, Data Match, Data Load, Data Migration, Trust Score validation.
• Develop client proposals and present at stakeholder meetings. Forecast future trends and orient strategies to capture maximum benefits. Coordinate with sales executives to better align company goals and tactics
• Developing Informatica ETL jobs to extract data from Source and to load into the Oracle.
• Implemented Informatica error handling, dynamic parameter file generations and coding best practices

Environment: Informatica Power Center, Oracle 11g, SQL, PL/SQL, XML, MS Access, Web services, Java, UNIX, DB2, Shell Script, SSIS.

Informatica Developer

Confidential

Responsibilities:

• Extract, transform and Load data from different sources into Oracle database using Informatica as ETL tool.
• Experience in BTEQ scripts
• Have designed history logics and written good SQLs in Teradata.
• Have involved in solving complications in the production level issues.
• Have involved SIT and UAT defects closing.
• Worked extensively in shell scripting and click stream analysis
• Involved in Tuning the Informatica objects to increase the Performance of the Informatica loads.
• Written the scripts needed for the business requirements (BTEQ Scripts).
• Involved in the design, development and testing of the PL/SQL stored procedures, packages for the ETL processes.
• Transformed bulk amount of data from various sources to Teradata database by using BTEQ scripts.
• Extracted data from various Sources like Oracle, Excel Spread sheets, XML, Sybase, Teradata and Flat Files.
• Created Unix Shell Scripts for ETL jobs, session log cleanup, dynamic parameter and maintained shell scripts for data conversion
• Have helped in re-building of Jobs based on requirement.

Environment: DWH, PL/SQL, UNIX Shell Scripting, Informatica Power Center, Oracle 11g, SQL Server, UNIX.

Informatica Developer

Confidential

Responsibilities:

• Developing Informatica ETL jobs to extract data from Source and to load into the Oracle.
• Develop the mappings using needed Transformations in Informatica tool according to technical specifications
• Responsible for technical Design Document and Details mapping document
• Extensively used Informatica Power Center and created mappings using transformations like SourceQualifier, Joiner, Aggregator, Expression, Filter, Router, Lookup, Update Strategy, and Sequence Generator.
• Used Informatica reusability at various levels of development.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.
• Attended weekly status meetings and provide detailed status report to the client..
• Develop informatica mappings and workflows for new change requests.
• Involved in Developing UNIX shell Scripts to generate parameter files and executed oracle procedures as batch jobs.
• Involved in performance tuning and optimization of Informatica mappings and sessions using features like partitions and data/index cache to manage very large volume of data.
• Preparing Test Results, Unit testing, Defect Fixing

Environment: Informatica Power Center, PowerBuilder, Oracle, Oracle SQL Developer, Quest-Toad, Shell Scripts, SQL*Loader, UNIX and Windows.