SUMMARY

• Over 7+ years of experience in Information Technology with ETL using Informatica PowerCenter9.x/8.x/7.x,DatabaseDevelopment,MasterDataManagement,Quality assurance.
• Excellent Experience with Informatica PowerCenter Upgrading and Administration.
• Proficient in Optimizing Database querying, data manipulation and population using SQL PL/SQL and Utilities in Oracle 11g/10g/9i, Teradata 13/12/V2R6, and SQL Server 2008/2000 databases.
• Knowledge in designing and developing Data marts, Data warehouse using multi - dimensional Models such as Snow Flake Schema and Star Schema Decision Support Systems.
• Experience in Fact & Dimensions tables, Physical & logical data modeling.
• Have strong knowledge in DataWarehousing, Database Concepts and Extraction, Transformation and Loading (ETL) from heterogeneous data sources using Informatica power center, Power Exchange, CDC and PL/SQL.
• Extensively used different types of Informatica transformations like Source Qualifier, Lookup, Router, Joiner, Filter, Aggregator, Expression, Union, XML, Web Service, Sales force (SFDC), Normalizer and Update strategy transformations to develop complex Informatica mappings.
• Experience in error handling, debugging and troubleshooting of ETL applications and expertise in identify the bottlenecks and optimize the performance of Informatica batch jobs.
• Highly Strong experienced with Informatica Performance Tuning.
• Experienced in Loader utilities including SQL Loader and Fast Load.
• Expertise in SQL/PLSQL programming development and execution of packages, stored procedures, functions, triggers.
• Well versed in developing thecomplex SQL queries, unions and multiple table joins and experience with Views.
• Strong hands on experience using Teradata utilities (SQL, B-TEQ, Fast Load, MultiLoad, FastExport, Tpump, Visual Explain, Query man, WinDDI).
• Excellent exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support.
• Extensively designed SCD 1, SCD 2, SCD 3 mappings.
• Excellent knowledge of UNIX shell scripting, automation of ETL process and scheduling of jobs.
• Extensive experience in unit testing, System testing and User Acceptance Testing.
• Extensive Experience in Business Intelligence tools like Business Objects and Cognos.
• Maintained outstanding relationship with Business Analysts and Business Users to identify information needs as per the business requirement.
• Excellent skills Requirements specification documents, Software design documents.
• Excellent Experience working with offshore and onsite co-ordination.
• Excellent written and communication skills, analytical skills with the ability to perform independently as well as in a team and will work off-hours if needed.

TECHNICAL SKILLS

ETL/OLAP & Reporting Tools: Informatica Power Center 9.x/8x/7x, Cognos 10x/8x,Informatica power exchange 9.x/8.x,Business Objects XI R3.1/5.x,OBIEE 10g,Webi

Databases: Sybase IQ 12.x,Oracle 11g/10g/9i/8i, SQL Server 2008,Teradata .

Web Technologies: HTML, CSS, XML

Scheduling Tools: Control M, Autosys, Informatica PowerCenter Scheduler, ESP,CA7.

Programming Languages: SQL, PL/SQL, UNIX, C++, Java, Perl

Data Modeling Tools: Erwin 4.0, Star-Schema and Snowflake-Schema Modeling

Generic Tools: SQL* Plus, SQL Loader, TOAD, Visio, Microsoft Office Suite

Ticketing Tool: JIRA, Service Now, Remedy, PVCS Tracker and FogBugz

Operating Systems: Unix, Windows 7/XP,AIX

PROFESSIONAL EXPERIENCE

Confidential, NY

Informatica Developer

Responsibilities:

• Involved in the Review of Requirements and development of Technical Design documents. Participated in impacted analysis.
• Co-ordinate with business team and DBA.
• Analyzing the source data and deciding on appropriate extraction, transformation and load strategy.
• Develop SQL DDL and DML statements
• Preparing ETL mapping documents for every mapping and Data Migration document for smooth transfer of project from Development to Testing environment and then to production environment
• Developed Mapplets and Worklets for reusability.
• Developed Fast Export scripts to send data files to other teams.
• Developed mappings which load data mart data into Teradata using load utilities(Fast Export, Fast Load, MultiLoad, and Tpump).
• Converted batch jobs with BULK utility to T-pump utility.
• Implemented Performance tuning in Mappings and Sessions by identifying the bottlenecks and Implemented effective transformation Logic.
• Maintain Development, Test and Production mapping migration Using Repository Manager. Involved in enhancements and maintenance activities of the data warehouse including performance tuning.
• Experience in analyzing the reporting requirement.
• Developed solutions involving the configuration ofMDMas well as coding within the ETL.
• Extensively used Stored Procedures, Functions and Packages using PL/SQL scripting for creating Connected and Unconnected Stored Procedure Transformations.
• Created Autosys schedules/jobs for automation of ETL load process.
• Involved in Unit Testing, User Acceptance Testing to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Designing the ETL process and defining the strategies for data loads of type1/type2/type3.
• Analyzed Source system functionality Identifies and logs issues and perform regression testing.
• Maintain traceability from requirements in order to design to test results
• Incorporated the ETL logic in mappings to update different databases of Oracle and SQL server using flat files, Oracle and SQL server
• Assisted in Batch processes using Fast Load, BTEQ, UNIX Shell and Teradata SQL to transfer cleanup and summarize data.
• Understanding BRD, Data required document and mapping documents.
• Designing the ETLs and conducting review meets Involvement in implementation of BTEQ and Bulk load jobs.
• Developed MLOAD scripts to load data from Load Ready Files to Teradata Warehouse.
• Created BTEQ scripts to extract data from warehouse for downstream applications.
• Worked on Teradata Query man to validate the data in warehouse for sanity check.
• Performance Tuning of sources, Targets, mappings and SQL queries in transformations.
• Identify and resolved the performance issues in Extract SQL queries for quick data retrieval.
• Production support for installed mappings.
• Done Code reviews and validated the mappings
• Run the Unix scripts to migrate the data from one server to another severs

Environment: Teradata12, Teradata 5500, SQL Assistant 12.0, Business Objects, Hyperion, BTEQ, FastLoad, FastExport, Multiload, Informatica Power Center 9.5.1, SQL, Oracle, MS SQL Server, Unix files, COBOL files, XML, Toad, Autosys.

Confidential, Little Rock, AR

Informatica Developer

Responsibilities:

• Integrated data from various finance and administrative services of the State of Arkansas.
• Participated in all phases of development life-cycle with extensive involvement in the definition and design meetings, functional and technical walkthroughs.
• Designed and built ETL mappings and workflows to load data from different sources Oracle, Sybase, SQL Server and fixed width as well as Delimited Flat files.
• Created Mapplets, Reusable transformations, Worklets and used them in different mappings and workflows.
• The Teradata EXPLAIN facility, which describes to end-users how the database system will perform any request.
• The TS/API product, a system to allow products designed for SQL/DS to access the • Teradata database machine without modification.
• Analysis of the specifications provided by the clients.
• Worked with various system interfaces to gather requirements for migration and implementation.
• Coding using BTEQ SQL of TERADATA, write Unix scripts to validate, format and execute the SQL's on UNIX environment.
• Using Teradata manager, Index Wizard and PMON utilities to improve performance.
• Created procedures to truncate data in the target before the session run.
• Implemented Variables and Parameters in the mappings.
• Developed stored procedure to automate the testing process to ease QA efforts and also reduced the test timelines for data comparison on 5000 tables.
• Written UNIX shell scripts to automate SFTP files, archive files and pre-validation scripts by exchanging SSH keys between UNIX servers.
• Expertise in documenting Mapping documents, Unit test plans, test results and Deployment plans.
• Analyzed change requests and performed impact analysis and estimated level of efforts.
• Worked on advanced concepts like concurrent running of the workflow, session level partitioning techniques and pushdown optimization.
• Scheduled workflows using PMCMD and UNIX Shell scripts using CRON Tab for daily and monthly loads.
• Involved in production deployment activities, creation of the deployment guide for migration of the code to production, also prepared production run books.
• Coordinated offshore and onsite teams efficiently for multiple projects.

Environment: Teradata V2R6, Teradata SQL Assistant, BTEQ, FLOAD, FEXP, MLOAD, FTP,Informatica Power Center 9.1, Oracle 11g, SQL Developer, Toad 10.6, PL/SQL, SQL Server, Sybase, CRON Tab, Windows XP.

Confidential, Birmingham, AL

Informatica Developer

Responsibilities:

• Responsible for requirement gathering analysis and Participation in requirement gathering sessions and converting the business requirements into ETL Technical Specification.
• Participated in all phases of development life-cycle with extensive involvement in the definition and design meetings, functional and technical walkthroughs.
• Responsible for definition, development and testing of processes/programs necessary to extract data from operational databases, Transform and cleanse data, and Load it into data warehouse using Informatica Power center.
• Designed and developed ETL Mappings using Informatica to extract data from Oracle, flat files, Excel Files and load the data into the target databases/Flat files.
• Used various Transformations like Source qualifier, Expression, Joiner, Lookup, Filter, Router, Sequence Generator, Sorter, and Stored Procedure for better data messaging and to migrate clean and consistent data using the Informatica Power Center Designer.
• Used Workflow Monitor to monitor the jobs, reviewed error logs that were generated for each session in the session log file, rectified the cause of failure and restarted them.
• Created Mapplets, Reusable transformations, Worklets and used them in different mappings and workflows.
• Involved in the Development of Informatica Mappings and Mapplets and also tuned them for Optimum performance, Dependencies and Batch Design.
• Worked with Variables and Parameters in the mappings to pass the values between sessions.
• Configured and ran the debugger from within the mapping designer to troubleshoot the mappings before normal run of the workflow.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Analyzed change requests and performed impact analysis and estimated level of efforts.
• Implemented error handling logic that involves testing of incorrect input values for the mappings and the means of handling those errors.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for Unit Testing, Systems Testing.

Environment: Informatica Power Center 8.1, Oracle 11g, SQL Developer, Toad 10.6, PL/SQL, SQL, CRON Tab, Windows XP, UNIX.

Confidential

ETL Developer

Responsibilities:

• Preparation of technical specification for the development of Informatica Extraction, Transformation and Loading (ETL) mappings to load data into various tables in Data Marts and defining ETL standards.
• Developed various Mapplets, Transformations and validated the fine-tuned the ETL logic coded into mappings.
• Made substantial contributions in simplifying the development and maintenance of ETL by creating re-usable Source, Target, Mapplets and Transformation Objects.
• The data in Legacy systems is extracted, Transformed and loaded into Data mart using ETL tool Informatica.
• Responsible for the Dimensional data modeling and populating the business rules using mappings into the repository for Metadata management.
• Created complex joins, Transformations of all types to pass data through ETL maps.
• Created Informatica mappings and sessions to accomplish data migrations. Sources were Oracle database and Flat files and targets were Flat files.
• Maintaining warehouse meta data, naming conventions, and warehouse standards for future application development.
• Created and managed daily, weekly and monthly data operations, workflows and scheduling processes.
• Migrated mappings, sessions and Common objects from Development to Test and Production.
• Development of Universes and reports using User Module and Web Intelligence based on user requirements
• Report development involves exploring features of Business Objects features, to make the project user friendly as much as possible
• Development is designed to take away ongoing maintenance of table or views creation as fiscal year changes and to support User-friendly ad-hoc querying.

Environment: Informatica 7, Oracle 9i, XML, MS-Access, Erwin, Business Objects Toad, PLSQL, Toad, Cognos 6. Window 2000, Windows NT SQL Loader.