SUMMARY:

• Having 8+ years of experience in IT industries and experience in ETL Designing and Implementing Data Warehouses and Data Marts on Windows and UNIX platforms.
• Extensive experience on ETL of data from heterogeneous source systems like Flat files, XML, Oracle, VSAM files using Informatica (9.5.1/9.0.1/8.6 ).
• 2+ Years of experience in developing PL/SQL Procedures, Functions, Triggers and Packages using TOAD11.6/10.6, SQL Developer 2.1
• Experience with Databases like Oracle 11g/10g/9i, Teradata.
• Experience in developing Perl scripts for parsing word and excel documents.
• Have good knowledge of Data Modeling (Dimensional, Star and Snowflake Schema), identifying FACT and Dimensions Tables, Physical and Logical Database design using ERWIN.
• Experience in implementing Change Data Capture (CDC) using Informatica Power Center.
• Extensively worked on transformations such as Source Qualifier, Joiner, Filter, Router, Expression, Lookup, Aggregator, Sorter, Normalizer, xml transformation, Update Strategy, Sequence Generator and Stored Procedure transformations.
• Experience in Debugging, Performance Tuning and Optimization of the Sessions and Mappings.
• Experience in UNIX shell scripting, CRON, FTP and file management in various UNIX environments.
• Worked with different Teradata utilities like Fload, Mload and BTEQ.
• Experience in Agile/Scrum methodology.
• Good knowledge in interacting with Informatica Data Explorer (IDE), and Informatica Data Quality (IDQ).
• Have good knowledge in Administrative activities such as creating folders, assigning security permissions to users and creating repositories, setting up groups/users permissions in Informatica Repository Manager and admin console.
• Resolving data issues, complete unit testing and complete system documentation for ETL processes.
• Supporting during Assembly/Integration Test, QA, UAT, and Production for Issues/Bug fixes/Defects
• Excellent verbal and communication skills, has clear understanding of business procedures and ability to work as an individual or as a part of a team.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.5.1/9.0.1 /8.6 , IDQ 9

Languages: C, SQL, PL/SQL, UNIX Shell Scripting, Perl, XML

Databases& utilities: Oracle 11g/10g/9i, SQL *plus, TOAD, BTEQ, Fast Load, MLOAD, Fast Export, SQL*Loader, Teradata SQL assistant, SQL Developer

Data Modeling & Scheduling Tools: ERWIN, Autosys, TIDAL 6.2

Operating Systems: Windows NT/XP, UNIX, LINUX(fedora)

Other Tools: Microsoft Office (Word, Excel, PowerPoint, Visio)

PROFESSIONAL EXPERIENCE:

Confidential, Riviera Beach, FL

ETL Developer

Environment: Informatica Power Center 9.5.1,Oracle 11g, TOAD 11.6,Teradata 13, Fast Load, MLOAD Utilities, UNIX Shell Scripting, ERWIN 7.3,TIDAL 6.2

Responsibilities:

• Involved in Dimensional Data Modeling using Erwin. (Conceptual, Logical and Physical).
• Analyzed Functional Specification Document provided by the architect and created Technical Specification Document.
• Based on FSD designed and developed ETL Processes using Informatica PowerCenter 9.5.1
• Coordinated with IT source systems for all the feed issues.
• Created reusable transformations and Mapplets and used them in complex mappings.
• Created different transformations for loading the data into target database using e.g. Source Qualifier, Joiner Transformation, Update Strategy, Lookup transformation, Router, filter, xml parser and xml source qualifier transformation, Expressions, Aggregator, and Sequence Generator.
• Implemented Type I and II Slowly Changing Dimensions.
• Developed PL/SQL procedures for processing business logic in the database and use them as a Stored Procedure Transformation.
• Developed UNIX shell scripts to automate data loading process.
• Worked on Performance tuning by identifying the bottlenecks in sources, targets, mappings and transformations.
• Migrated Mappings, Sessions and Common Objects from Development to Test and to Production.
• Performed Unit Testing, prepared Test Cases for the same.
• Prepared Unit testing cases document and mapping design document

Confidential, Eagan, MN

ETL Developer

Environment: Informatica Power Center 9.0.1,Teradata 12, BTEQ Scripts, UNIX, TOAD 10.6,Autosys, Oracle 10g

Responsibilities:

• Developed Informatica mappings and workflows as per standards.
• Created reusable transformations and Mapplets and used them in complex mappings.
• Created different transformations for loading the data into target database using e.g. Source Qualifier, Normalizer, Joiner Transformation, Update Strategy, Lookup transformation, Router, filter, Expressions, Aggregator, and Sequence Generator.
• Created Slowly Changing Dimension (SCD) Type 2 mappings for loading dimensional data to maintain historical data.
• Made use of Command, Control, Event wait, Event raise Timer tasks to automate workflows.
• Implemented CDC using Informatica power center.
• Developed PL/SQL procedures for processing business logic in the database and use them as a Stored Procedure Transformation.
• Involved in preparation of Teradata BTEQ scripts.
• Migrated Mappings, Sessions and Common Objects from Development to Test and to Production.
• Worked on Performance tuning by identifying the bottlenecks in sources, targets, mappings and transformations.
• Performed Unit Testing, prepared Test Cases for the same.
• Prepared Unit testing cases document and mapping design document.

Confidential, Greensboro, NC

PL/SQL Developer

Environment: Oracle9i, SQL, PL/SQL, TOAD, SQL*Loader, UNIX, MS Office Tools

Responsibilities:

• Involved in design, development and maintenance of the database model.
• Responsible for the creating stored procedures and database triggers.
• Wrote SQL scripts to create staging tables and developed SQL*Loader control files to load the data from data files into the staging tables.
• Used TOAD, PL/SQL developer tools for faster application design and developments.
• Extensively used cursors, procedures, functions, packages.
• Implemented UNIX Shell scripts and scheduled Cron jobs.
• Made adjustments in Data Model and SQL scripts to create and alter tables.
• Worked cooperatively with the team members to identify and resolve various issues related to database.
• Extensively worked on project documentation (MS Word, Visio) and deck (MS Power Point) for the management.

Confidential, Huntsville, AL

Developer

Environment: Perl 5, MS Word, MS Excel, Windows, Bugzilla

Responsibilities:

• Involved in design, development and maintenance of the tool.
• Developed Perl scripts for checking field’s header, printability, size, font, spell check.
• Used Perl Win32::OLE module for word and excel files.
• Supporting teams across organization for their use.
• Prepared low level design document and test documents.
• Performed unit and integration testing and supported in code fixes.