SUMMARY:

• Over 7.5 years of IT experience training taking as an ETL Developer and worked on all phases like Business Requirements Analysis, Application Design, Data Modeling, Development, Implementations and Testing of software systems in various verticals such as Financial, Retail, Insurance industries using Informatica Power Center 9.6.1/9.5.1/ 9.1/8. x as ETL tool
• 2.5 year of real - time data warehouse development experience using CDC tool Informatica PowerExchange 9.5/9.1.
• Implemented Informatica ETL methodology for designing and developing, extraction, transformation and load processes.
• Proficient in full life cycle development of Data Warehousing, ETL strategies, reporting and hands on experience in Performance Tuning of sources, targets, transformations, mappings and sessions using Database Tuning, Partitioning, Index Usage, Aggregate Tables, Session partitioning, Load strategies, commit intervals and transformation tuning.
• Experience in Unit testing, System testing while moving the code from development to production.
• Experience in Data Warehouse/Data Mart Development Life Cycle using Dimensional modeling of STAR schema, SNOWFLAKE schema, OLAP, ROLAP, MOLAP, Fact and Dimension tables and Logical& Physical data modeling using ERWIN.
• Experienced in loading data into targets like Flat files, xml files, Oracle, DB2, SQL Server into Data Warehouse/Data Marts using Informatica.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows in all versions of Informatica.
• Experience in creating Reusable components like transformation, mapplets and tasks.
• Worked with Teradata loading utilities like Multi Load, Fast Load, TPump and BTEQ .
• Good knowledge in extracting data from Flat Files, Unstructured data, xml formats and PDF format files and transforming and loading into Oracle database, flat file JMS Queue, COBOL files and vice versa.
• Experience in developing Shell scripts on UNIX and experience with UNIX command line.
• Assign work and provide technical oversight to onshore and offshore developers.
• Good experience in documenting the ETL process flow for better maintenance and analyzing the process flow.
• Demonstrated ability to take initiatives, grasp and expand on ideas, tackle and follow through difficult assignments in the fast-pace and changing environment.
• Independent yet team oriented with excellent analytical, problem solving, multi-tasking and oral and written communication skills.

TECHNICAL SKILLS:

ETL Technology: Informatica Power Center 9.6.1/9.5.1/9.0.1/8. x, PowerExchange 9.x/8.6

Data Warehouse: Multidimensional Model Design, Star Schema Development

Data Modelling: Star-Schema Modeling, Snowflake Modeling, MS Visio, Erwin

Databases: Oracle 12c/11g/10g, SQL Server 2008/2000, MS Access, SAP, Sybase, DB2, MySQL, Teradata 13/V2R6

Programming: C, C#, C++, SQL, PL/SQL, ANSI SQL, T-SQL, SQL*Plus 3.3/8.0, Java 1.4, Python, HTML, UNIX shell Scripting, VB Scripting.

Scheduling & Reporting Tools: Tivoli, Tidal, ESP, Autosys, OBIEE 10g, Crystal Report

Environment: s: Windows 98/NT/2000/XP, MAC, Sun Solaris, UNIX, LINUX, MS-DOS 6.22

Applications: MS Office, MS Project, FrontPage, Toad 9.2/8.6

PROFESSIONAL EXPERIENCE:

Confidential, New York City, NY

Consultant ETL Developer/Support Analyst

Roles and Responsibilities:

• Transformed business requirements into technical documents BRD, explained business requirements in terms of technology to the developers.
• Developed Data Flow diagrams to create Mappings and Test plans. The Data flow diagrams ranged from OLTP systems to staging to Data warehouse.
• Developed Test plan to verify the logic of every Mapping in a Session. The test plans included counts verification, look up hits, transformation of each element of data, filters, and aggregation and target counts.
• Created Mapping Parameters, Session parameters, Mapping Variables and Session Variables.
• Created Mapplet and used them in different Mappings.
• Developed complex Informatica mappings using various transformations- Source Qualifier, Normalizer, Filter, Connected Lookup, Unconnected Lookup, Update strategy, Router, Aggregator, Sequence Generator, Reusable sequence generator transformation.
• Extensively used SCD’s (Slowly Changing Dimension) to handle the Incremental Loading for Dimension tables, Fact tables.
• Created registration and data map for loading CDC data.
• Designed various mappings for extracting data from various sources involving Flat files, Oracle, Sybase and SQL Server, IBM DB2.
• Involved in writing and modifying UNIX shell scripts.
• Worked on Debugging and Troubleshooting of the Informatica application. For debugging utilized Informatica debugger.
• Worked with data quality team to fix the production data issues and also provide solutions to the business users.
• Coordinated with offshore team to support the existing ODS system jobs.
• Coordinated with business users and across the development teams in implementing new business requests.
• Used Toad for data quality verification and unit testing the data.

Environment: Informatica Power Center 9.6.1/9.5.1/8.6, Power Exchange 9.5.1/8.6, AS-400 (DB2), Oracle 12c,Teradata 13,OBIEE 10g, SQL Server 2005/2K, AIX, Windows XP, Sun Solaris, Putty, SCM, Rally.

Confidential, NY

Consultant Data Analyst

Roles & Responsibilities:

• Fast paced project involving understanding the business, current processes and requirements.
• Gathered Requirements from users, translated user inputs into ETL design documents.
• Performed Business Analysis, Designed, Developed, Tested and Implemented Informatica transformations and Workflows for extracting the data from the multiple legacy systems.
• Developed complex mappings using multiple sources and targets in different databases and flat files.
• Used various transformations like unconnected lookup, connected lookup, aggregator, rank, joiner, stored procedure etc.
• Applied performance tuning on targets, sources, mappings, sessions and database to improve system performance.
• Created and Executed UNIX shell scripts and PL/SQL procedures, Pre-session and Post- Session Scripts to ensure timely, accurate processing and ensure balancing of job runs.
• Performed Unit testing of Informatica Mappings, Workflows, and Mapplets and tuned them to improve performance.
• Worked with the team to create reusable ETL solutions to achieve enormous improvements.
• Assisted in the process of preparation of documenting Informatica transformation Development Standards.
• Created jobs in UNIX to run the workflow through pmcmd command. Also wrote shell scripts for file transfers, file renaming and several other database scripts to be executed from UNIX.
• Created production support run book to support ETL process.
• Worked on Teradata utilities to load data from flat files to stage and from stage to data warehouse tables using FLOAD, MLOAD, BTEQ and TPUMP.

Environment: Informatica PowerCenter 9.1, Informatica PowerExchange 9.1, PL/SQL, Oracle 11g, Oracle Exadata, TOAD, Windows 2000, SQL Server 2008, Tidal, OBIEE 10g, LINUX, Teradata 12

Confidential, Florida, FL

Consultant Program Analyst/ETL Developer

Role & Responsibilities:

• Designed mapping document, which is a guideline for ETL Coding following Standards for naming conventions and Best Practices were followed in mapping development.
• Extensively used Informatica version tasks like Decision, Command, Event Wait, Event Raise, and Email.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, Update Strategy, Rank, Joiner and Stored procedure transformations.
• Optimized the SQL override to filter unwanted data and improve session performance.
• Used Debugger to track the path of the source data and also to check the errors in mapping.
• Created MQ Source, Target and created connection for MQ source and target.
• Extracted message in form of XML from MQ.
• Truncated MQ channel through Informatica once data extracted and loaded successfully.
• Used XML parser and Generator.
• Analyzed the existing mapping logic to determine the reusability of the code.
• Handled versioning and dependencies in Informatica.
• Prepared unit testing document covering field to field’s validations and source to target count.
• Scheduling the workflow comprising of different sessions for their respective mappings in order to load data into Oracle database.
• Handled creation, modifications, and documentation of Oracle Packages, Procedures, Functions, and Indexes.
• Assisted the other ETL Developers in resolving complex scenarios.
• Involved in promoting the folders from Development to Test and Test to Production Environment.
• Involved in different Team review meetings.

Environment: Informatica PowerCenter 8.6, Informatica PowerExchange 8.6, Oracle 11g, Oracle Exadata, Toad 7.6, Autosys, PL/SQL, SQL*Plus, SQL*Loader, XML, Windows NT 4.0, Cobol, DB2, Sun Solaris Unix 2.6, Unix Shell Scripting.

Confidential, Washing DC

Informatica Developer

Role & Responsibilities:

• Designed ETL processes using Informatica to load data from Flat Files, and Excel files to target Oracle Data Warehouse database
• Performed data manipulations using various Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, and Sequence Generator, Stored Procedure etc.,
• Used tuned SQL overrides in source Qualifier to meet business requirements
• Written pre session and post session scripts in mappings.
• Created sessions and workflows for designed mappings. Redesigned some of the existing mappings in the system to meet new functionality
• Created and used different reusable tasks like command and email tasks for session status
• Involved in the data analysis for source and target systems and good understanding of Data Warehousing concepts, staging tables, Dimensions, Facts and Star Schema, Snowflake Schema.
• Identify the flow of information, analyzing the existing systems, evaluating alternatives and choosing the "most appropriate" alternative
• Understand the components of a data quality plan. Make informed choices between sources data cleansing and target data cleansing.
• Prepare documentation on all aspects of ETL processes, definitions and mappings.
• Used features like email notifications, scripts and variables for ETL process using Informatica Power Center.
• Involved in Data Extraction from Oracle and Flat Files using SQL Loader Designed and developed mappings using Informatica Power Center
• Used Workflow Manager to create Sessions and scheduled them to run at specified time with required frequency
• Monitored and configured the sessions that are running, scheduled, completed and failed.
• Created test case, participate in System integration test, UAT and migrated code from Development to Test to QA to Production.
• Compiled report presentations using tools like Business Object reports.
• Involved in writing UNIX shell scripts for Informatica ETL tool to fire off services and sessions

Environment: Informatica Power Center 8.1/8.6, MS SQL server 2000,Teradata V2R6, SQL/PL SQL, Windows XP, UNIX Shell Script, Sun Solaris.

Confidential, Bentonville, AR

INFORMATICA DEVELOPER

Role & Responsibilities:

• Involved in designing and customizing logical and physical data models for Data warehouse supporting data from multiple sources on realtime.
• Used Star Schema approach for designing of Data Warehouse using Erwin.
• Designed and developed Informatica mappings, enabling to Extract, Transform and Load the data into target tables.
• Extensively worked on Informatica Designerand Workflow Manager.
• Extensively used almost all of the transformations of Informatica including source qualifier, expression, filter, aggregator, rank, Lookups, Stored Procedures, sequence generator, joiner, Update Strategy and others.
• Worked with Memorycache for improvingthroughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations.
• Developed Slowly Changing Dimension (SCD) mappings.
• Developed Sessions, Worklets using Informatica Workflow Manager.
• Extensively worked in the Performance tuning of the Programs, Procedures and Processes.
• Translated business requirements into data warehouse design.
• Worked in modules with relational E/R and Dimensional data modeling in large transaction.
• Worked on technical Documentation of existing and proposed models.
• Worked closely with DBA and developers during planning, analyzing and testing phase.
• Running the SQL scripts from TOAD and creating Oracle Objects like tables, Views, Indexes, sequences and Users.SQL coding for problem resolution and performance optimization
• Participated in identifying scope of the project, planning and development with other team.
• Worked with various IT and management teams with the schedule.
• Prepared testcases and performed Unittesting. Created test cases and test scenarios and documented actual results; involved in system testing of overall processes; compared actual results to expected results; and wrote Test Plans and created Test Cases effectively using Quality Center.
• Worked on datacleansing and query tuning. Involved in analyzing the source data coming from different data sources like Oracle, Flat Files, XML and SQLServer and identifying data anomalies in operational data.
• Worked in the data mapping, designing phase and deploying the mappings
• Trouble shot development related issues which arose at the time of UAT.
• Developed Pre and Post SQL scripts, PL/SQLstored procedures and functions.
• Responsible for errorhandling using Session Logs, Reject Files, and Session Logs in the Workflow Monitor.
• Used mapping Parameters and Variables to pass the values between sessions.
• Developed Informatica Mappings and Sessions based on user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Involved in analysis, solution and low level design.

Environment: Informatica PowerCenter 8.1, Windows 2000, Oracle 10g, SQL Server 2000, MS Suite, AIX, Autosys, Putty, Harvest, Axiom, TFS.