SUMMARY:

• 8 Years of experience in the field of IT in System Analysis, Design, Coding and testing of Data Warehousing Implementations across Financial, Telecommunication and Retail Industries.
• Data Warehousing experience using Informatica Power Center 10.1, 9.6.1, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Manager, Work Flow Monitor, Datamart, OLAP, OLTP, Mapplets, Transformations, Autosys.
• Designing and Developing complex mappings by using Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator.
• Major experience using Databases like Oracle 12c, 11g, 10g, Ms SQL Serve, Teradata, RDBMS Tables, CSV Files, COBOL and Relational Sources.
• Strong experience on Data Design/Analysis, Business Analysis, User Requirement Gathering, User Requirement Analysis, Gap Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis.
• Experience on Data Modeling, Erwin Dimensional Modeling, Ralph Kimball Approach, Star/Snowflake Modeling, Datamarts, OLAP, Fact and Dimension tables, Physical and Logical data modeling and Oracle Designer.
• Strong involvement in Designing (Creating Indexes, Tables, Views, Triggers) by extraction of data from various Heterogeneous sources like Relational Databases, Flat Files and XML Files, Data Warehouse/Datamart.
• Using Teradata utilities like TPT, FASTLOAD, MULTILOAD, and BTEQ scripts.
• Informatica Data Quality experience with strong knowledge of transformations like Address Validator, Parser, Labeler, Match, Exception, Association, Standardizer and other significant transformations.
• Complete knowledge of data warehouse Methodologies Agile Methodologies, ODS, EDW, and Metadata Repository.
• Strong background in SDLC project management and Resource Planning using Agile Methodologies.
• Experience in performance tuning to the Informatica and Oracle.
• Used debugger to debug mappings to gain troubleshooting information about data and error conditions.
• Worked on the design and implementation of Slowly Changing Dimension Type 1,2.
• Well versed in using various DML and DDL statements, including manipulation of Stored Procedures, Functions, Triggers and Views on different databases including MS - SQL Server, Oracle.
• Extensively worked with SQL Loader for Bulk Loading into the oracle database.
• Experience in UNIX Operating System and Shell Scripting.
• Good skills with computer science concepts and programming.

TECHNICAL SKILLS:

ETL tools: Informatica Power Center10/9.X/8.X, IDQ, Data Warehousing.

Databases: Oracle 10g/11g, DB2, SQL Server 2005/2008,Teradata, ANSI-SQL, Flat Files, XML File, CSV Files, RDBMS Tables, SAP, COBOL.

Reporting Tools: Oracle Business Intelligence, Cognos,MicroStrategy,OBIEE

Data Access Tools: TOAD, SQL Navigator, Oracle SQL Developer

Programming Languages: SQL, PL/SQL, Unix Shell scripting, SYBASE, HTML, Python.

Scheduling Tools: Autosys, Robot, Informatica Job Scheduler

Operating Systems: UNIX, WindowsXP/Vista, MS DOS, Linux

PROFESSIONAL EXPERIENCE:

Sr.Informatica Developer

Confidential, San Jose, CA

Responsibilities:

• Collected all the details like series number and created tables to load the production details.
• Extracted data from flat files and oracle database, applied business logic to load them in the central oracle database.
• Developed mappings/ReusableObjects/Transformation/mapplets by using mapping designer, transformation developer and mapplet designer in Informatica PowerCenter.
• Implemented Informatica recommendations, methodologies and best practices.
• Implemented populate slowly changing dimension to maintain current information and history information in dimension tables.
• Worked on different data sources such as Oracle, Flat files etc.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, Union, Lookup, Joiner, XML Source Qualifier and Stored procedure transformations.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression, Lookup, Update strategy and Sequence generator, Procedure. Knowledge in use of SQL Transformations.
• Developed PL/SQL and UNIX Shell Scripts for scheduling the sessions in Informatica.
• Created E-mail notifications tasks using post-session scripts.
• Worked with command line program pmcmd to interact with the server to start and stop sessions and batches, to stop the Informatica server and recover the sessions.
• Wrote SQL, PL/SQL, stored procedures & triggers for implementing business rules and transformations.
• Created deployment groups, migrated the code into different environments.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Involved in managing the UNIX servers and defining the file systems/directory structures on the Unix box for various parameters and deciding the disk space and memory requirements.
• Provided support to develop the entire warehouse architecture and plan the ETL process.

Environment: Informatica Power Center 10.1,9.6.1, Oracle 11g/10g, Flat File, SQL Server, Toad for Oracle, UNIX, Shell Script, ESP Scheduler.

Sr.Informatica Developer

Confidential, New York, NY

Responsibilities:

• Involved in identifying the source and the source data validation, developing particular logic and transformation as per the requirement and creating mappings and loading the data.
• Designed the ETL processes using Informatica to load data from Flat Files, XML Files, Excel Files.
• Designed and customized data models for EDW from multiple sources on real time.
• Involved in design and development complex ETL mappings and stored procedures. Designed and developed Informatica mappings for data loads, business rules development and data cleansing.
• Debugged mappings by creating logic that assigns a severity level to each error, and sending the error rows to the error-table so that they can be corrected and re-loaded into a target system.
• Worked on source analyzer, Data warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer and repository Manager.
• Extensively worked on the performance tuning of the Informatica power center mappings as well as the tuning of the sessions.
• Worked specifically with the Normalizer Transformation by converting the incoming fixed width files to Cobol workbooks, and using the Normalizer transformation to normalize the data.
• Extensively used Transformations like Aggregator, Joiner, Expression, Filter, Update, Lookup, Sorter and Stored Procedure transformation.
• Created Detail design documents and technical design specification documents for ETL process Based on the Business Requirements.
• Identified and eliminated duplicates in datasets through IDQ Components of Edit Distance, Jaro Distance and Mixed Filed matcher, It enables the creation of a single view of customers, help control costs associated with mailing lists by preventing multiple pieces of mail.
• Tested all the mappings developed and checked the data transformations.
• Used Informatica B2B data transformation to read unstructured and semi structured data and load them to the target.
• The load ready files are loaded into Teradata tables using Teradata ODBC/ Fastoad, Multiload connection. The load data and time are also captured in the Teradata table.
• Created UNIX shell scripts, Stored Procedures for Data transformation.
• Used Informatica as a Data cleansing tool to correct the data before loading into the staging area.
• Solving day-to-day problems, giving support to the Business Users.

Environment: Informatica Power Center 10.1,9.6.1, Oracle 11g/10g, Teradata, Flat File, SQL Server, Toad for Oracle, UNIX, Shell Script, ESP Scheduler.

Sr. ETL/Informatica Developer

Confidential, Charlotte, NC

Responsibilities:

• Gathered requirements from the end users and involved in analysis of source system, business requirements and identification of business rules.
• Involved in the Data Warehouse, Data Modelling based on the client requirement.
• Responsible for developing support and maintenance for the ETL processes using Informatica powercenter.
• Good knowledge on Teradata TDWM, PMON, DBQL, SQL assistant and BTEQ.
• Work with Transformations like Java, Filter, Lookup, Expression, Normalizer, Joiner, Aggregator.
• Extracted sources from Cloud, Flat Files, Oracles, SQL Server and load them into WH.
• Involved in migration projects to migrate data from data warehouses on Oracle/DB2 and migrated those to Teradata.
• Responsible for creating system design and detail design documents based on the requirement document provided by the business users.
• Extensively worked in the performance tuning of Teradata SQL, ETL and other processes to optimize session performance.
• Developed various Mappings and Mapplets, also developed and Error Processing to capture the error records and loads them into a message log table.
• Created UNIX Scripts to automate the activities like start, stop and abort the information workflows by using PMCMD command in it.
• End to Day job create script with Sybase statements to publish the result of core processes by he end of the day.
• Extensively used Debugger Process.

Environment: Informatica Power Center 9.6.1,9.5.1 Oracle 11g/10g,Teradata, SQL Server, Toad for Oracle, UNIX, Shell Script, ESP Scheduler.

Role:Informatica Developer

Confidential, Tennessee

Responsibilities:

• Developed complex Informatica mappings to load the data from various sources using different transformations.
• Worked Informatica power center tools like source analyzer, mapping designer, mapplet and transformations.
• Teradata views have been developed against the departmental database and claims engine database to get the required data.
• Developed Re-Usable transformations and Re-Usable mapplets.
• Extensively worked with both connected and unconnected Lookup Transformations.
• Load balancing fo ETL processes, involved in Unit testing and System testing.
• Creating and modifying MULTILOADS for Informatica using UNIX and Loading data into IDW.
• Detail system defects are created to inform the project team about the status throughout the process.

Environment: Informatica Power Center 8.6.1,9.5, Oracle 11g/10g, SQL Server, Toad for Oracle, UNIX, Shell Script.

Lead Informatica Developer

Confidential, Portland, OR

Responsibilities:

• Worked as a Lead Developer and team lead for the offshore project members.
• Involved in end to end ETL required to build the customer billing data marts.
• Designed ETL process from source system to final datamarts and created ETL documents in vision to assign work to the offshore team.
• Developed new mappings with reusable transformations and mapplets based on business requirements.
• Modified PL/SQL stored procedures for Informatica mappings.
• Worked with the Informatica admin team for the deployment and version controlling.
• Coordinating with source system owners for day-to-day ETL progress monitoring.
• Created sessions and Workflow to load data from the SQL server, flat file and Oracle sources that exist on servers located at various locations all over the country.
• Worked on shell scripts to handle flat files which include files from source systems and transferring files to downstream systems.
• Involved in Reviewing of Checklists and Project Deliverables.
• Worked on a Remedy tool to create service requests, incidents for the changes in the database.
• Involved in unit testing, Integration testing and User acceptance testing of the mappings.
• Responsible for scheduling workflows, error checking, production support, maintenance and testing of ETL procedures using Informatica session logs.
• Taking care of production Deployment during code releases.

Environment: Informatica Power Center 8.1,8.6.1, Oracle 10g,9i, SQL Server, UNIX, Shell Script, Windows XP.

Oracle Developer/ Database Analyst

Confidential

Responsibilities:

• Coordinating with end users and business analysts to understand the scope of business requirements, user expectations, and ensure the accuracy of reporting specifications.
• Designed and Documents Universe and Report Requirements definition templates, security strategies, Migration strategies and Report distribution strategies.
• Evaluated the possible use of aggregated tables and worked with DBA to create aggregated tables.
• Involved in writing Unix Shell Scripts to run batch jobs and automating their schedules.
• Designed and Developed data validation, Stored Procedures, Functions and Triggers using SQL Server and Oracle.
• Designed Report output formats, complex, filtering and formula calculations, as well as the rendering of multi-band and multi-grouped reports.
• Coordinated between management, users and technical teams for requirement gathering.
• Involved in various activities like preparation of technical Documentation, Client Discussion for purposed solution and User acceptance testing.

Environment: Oracle 11g/10g,DB2, Flat File, SQL Server, Toad for Oracle, UNIX, Shell Script