SUMMARY

• Around 8 years of IT Experience as an ETL Developer in designing, developing and implementing ETL processes for business applications.
• Experience in requirement gathering, system analysis, design, development, technical documentation & flow charts, implementation, test & data management, client relationship and product delivery.
• Diversified domain experience in Communication, Financial, Retail, Banking and Insurance Industries.
• Demonstrated understanding of Dimensional modeling (Star & Snow flake schema) and other data warehousing concepts.
• Worked on Informatica versions 9.x, 8.x, 7.x, 6.x.
• Extensive experience in designing the architecture for Extract, Transform, Load environment, development of mappings and process using Informatica Power Center.
• Experience in Extraction/Transformation/Loading using Informatica Power Center and various sources like fixed width/delimited/XML files, SQL Server, Mainframe, DB2 & Oracle databases.
• Experience in working on oracle 11g/10g/9i, My SQL, MS SQL Server 2012/2008, DB2, MS Access 7.0.
• Back - end programming experience in writing and implementing complex sub queries, SQL, PL/SQL Triggers, Stored Procedures, Functions and Packages.
• Strong experience in OLTP/OLAP System Study, Analysis and E-R Modeling, developing database schemas like star and snowflake schema, dimensional data modeling, Fact and dimensional tables, slowly changing dimension(SCD) techniques for incremental updating of the targets.
• Experience in creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank).
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet & Control).
• Extensively worked on developing and debugging Informatica Mappings, Mapplets, Sessions and Workflows.
• Extensive experience in Unit Testing, System Integration Testing, Performance Volume Testing and User Acceptance Testing(UAT) of the operational data sources and enterprise data warehouse.
• Involved in Performance tuning of the ETL process and SQL tuning.
• Experience in UNIX work environment, File Transfers, Job scheduling, monitoring and providing on-call support.
• Excellent communication skills, good organizational skills, outgoing personality, self-motivated, hardworking, ability to work independently or cooperatively in a team, eager to learn, ability to grasp quickly, and ability to harmonize with cross-functional teams.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.x/8.x/7.x/6.x

Databases: Oracle 11g/10g/9i/8i, SQL Server 2012/2008/2005/2003 , IBM DB2, MS-Access 7.0, My SQL, Netezza.

Reporting Tools: OBIEE, Business Objects.

Data Modeling: Erwin 4.1 and Micisoft Visio.

Languages: SQL, PL/SQL, C, C++, HTML, Shell, Pearl, Confidential -SQL.

Special Tools: TOAD, Autosys, Tivoli

Operating Systems: Windows, UNIX, Sun Solaris

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Senior Informatica Developer

Responsibilities:

• Involved in requirement analysis, ETL design and development for extracting data from the source systems like XML files, Flat Files, SQL Server and loading into DW and Data Marts.
• Worked with analysts and data source systems experts to map requirements to ETL code.
• Converted functional specifications into technical specifications (design of mapping documents) for the development of mappings to load data into various target tables.
• Created ETL Mappings Using Informatica Power Center 9.x/8.x to transform data into multiple system.
• Develop Informatica ETL jobs for data extraction, transformation, loading, data cleansing by using several built in transformations and procedures.
• Creation, configuring, scheduling and running of Sessions, Worklets and Workflows.
• Error Handling: Handled in Informatica Mappings & sessions and also through Validation Scripts
• Involved in Performance Tuning of the Complex Informatica mappings and also fine tuned the sql queries in informatica mappings.
• Wrote Power shell/ DOS scripts to support Production and Development activites.
• Wrote SQL scripts, stored procedures and DDL Scripts for Generating Tables, View, Functions.
• Added/Changed Tables, Columns, Triggers and using Confidential -SQL
• Wrote Complex Confidential -SQL and stored procedures to update the SQL Server Data Marts.
• Extensively used Confidential -SQL to create triggers and stored procedures used by the enhancements modules to update the SQL Server database.
• Preparing the unit test cases and perform Unit testing and peer reviews Confidential the end of each phase.
• Implemented Methods like Table Partitioning and optimizing SQL code by closely working with DBA’s.
• Coordinated with DBA’s in resolving the database issues that lead to production job failures.
• Providing weekend on-call support.

Environment: Informatica 9.5.1, Netezza Release 6.0.5, SQL, PL/SQL, Confidential -SQL, Oracle 11g, TOAD for Oracle, Shell, Pearl, Sun OS 5.10, MS Visio, Windows 7.

Confidential, Charlotte, NC

Data warehouse Developer

Responsibilities:

• Implemented SDLC concept in Extraction, Transformation and Loading of data using Informatica.
• Created ETL mapping using XML parser, XML generator and Web Services.
• Created documents for ETL interface specifications, technical design and unit test plan.
• Performed unit testing, integration testing and system testing ofInformatica mappings.
• Extensively worked in the performance tuning of mappings and sessions.
• Worked on Enterprise Architect to design the Batch Load Process, data flow and the ETL Loading strategy.
• Extensively worked on various reload strategies and recovery strategies.
• Worked with the web methods team to validate messages sent to the dealers.
• Worked with the test cases with the QA team to validate ETL code.
• Modify and re-develop existing interfaces to remove bugs and increase efficiency of the applications.
• Documented standard operating procedures, application level documents for production support team.
• Provided on call support to all the HR Mart applications.

Environment: Informatica Power Center 9.1.0/8.6.0 , oracle, DB2, SQL Server 2005/2008, ESP cybermation Scheduler, SQL, PL/SQL, Perl, Enterprise Architect, MS Visio, Windows XP, Sun Solaris UNIX.

Confidential, Columbus, OH

ETL Developer

Responsibilities:

• Created mappings using the transformations such as the Source qualifier, Aggregator, Expression, Lookup, Router, Filter, Rank, Sequence Generator, update Strategy.
• Created reusable objects like Mapplets, Reusable Transformations and work lets.
• Carried out testing to check whether the application was functioning as per the Business rules and functional documents.
• Developed and managed automated batch job schedules using Maestro.
• Developed Unix Shell Scripts to download files from the mainframe, file checking, directory cleanup, file backups and execute jobs for batch processing.
• Extensively worked on Oracle Stored Procedures.
• Major responsibilities included writing Test plans, creating Test scripts, team co-ordination and technical writing / Documentation during Manual Testing.
• Developed and implemented various enhancements to the application in the form of production and new production rollouts.
• Involved in fine tuning queries for better performance (includes indexing, pre-joining and materializing views, database partitioning).
• Involved in system integration testing, performance volume testing and user acceptance testing.
• Followed the best practices for the environment as set up by the Administrator which include but are not limited to Change control process, Documentation process, Code/Peer Review, Optimization standards.

Environment: Informatica 8.1.1, Oracle 10g, DB2, Netezza, PL/SQL,SQL, Unix/Perl/Shell scripting, Autosys, Configuration management (Harvest), WinSql, TOAD.

Confidential, Auburn Hills, MI

Informatica Developer

Responsibilities:

• Involved in gap analysis, SD, SI and testing phases of the ETL process.
• Worked closely with the data architect on the schema design and table definitions.
• Created documents for ETL interface specifications, technical design and unit test plan.
• Extract data from multiple source systems by creating mappings using various Transformations to build business rules to load data into the target systems.
• Extensively worked on star schema and snowflake schemas and modified existing schemas to meet the business requirements.
• Worked on enhancing the existing data models and created new schemas based on business requirements using ERWIN.
• Design of processes from different file source systems/Siebel Source Systems via Informatica mappings and stored procedures into data warehouse.
• Transformations used in Infomatica Power Center are: connected & unconnected lookups for slowly changing dimensions, routers to route the data to various targets, expressions to modify data, source qualifiers to get selective data, aggregators to group data, filters to filter unwanted data, sequence generators to generate data sequences, normalizer to normalize data, joiners to join heterogeneous sources and update strategy to update the target tables.
• Used mapping variables in power center to reference and record values in mappings, and passed parameter files in sessions to reassign variable values.
• Used Conversion process for VSAM to ASCII source files using Informatica Power Exchange.
• Created SSIS packages to gather data from various sources.
• Extensively used PL/SQL stored procedures and functions.
• Created and used Perl scripts for running workflows and generated log files for the ETL process.
• Involved in unit testing, system integration testing, performance volume testing and user acceptance testing.
• Involved in fine tuning queries for better performance (includes indexing, pre-joining and materializing views, database partitioning).
• Involved in executing test cases, verifying results and logging defects in the Mercury Quality Center during the QA process.
• Experience in creating Metadata Objects and Web Catalog Objects (Dashboards, Pages, and Reports) using OBIEE Admin Tool and Siebel Analytics Web.
• Created ad-hoc reports using Business Objects functionality like slice and dice, drill down, functions, cross tab, master/detail, aggregate awareness and coalesce function.
• Worked extensively on creating dashboard reports and maintaining and modifying the ETL process that fed the dashboard.
• Trained the end user on the objects and metrics available in the Universe and helped with creating ad-hoc reports.
• Extensively worked on UNIX, TOAD and SQL Plus.

Environment: Informatica Power Center 7.1.4/7.1, Informatica Power Exchange 8.1, Business Objects 6.5/XI, Oracle 10g, Siebel Analytics 7.x, OBIEE, Netezza, TOAD for Oracle/SQL Server, Tivoli Workflow scheduler, SQL, PL/SQL, Perl, Rational Clearcase, MS Visio, Windows XP, UNIX.

Confidential

ETL Developer

Responsibilities:

• Documented Informatica mappings, design and validation rules.
• Developed different mapping logic using various transformations to extract data from different sources like flat files, IBM MQ series, Oracle
• Created Sessions and Workflows to load data from the IBM DB2 UDB 8 databases that were hosted on HP UX 11i RISC server
• Developed mapping logic using various transformations like Expression, Lookups (Connected and Unconnected), Joiner, Filter, Sorter, Update strategy and Sequence generator.
• Actively implemented Informatica performance tuning by identifying and removing the bottlenecks and optimized session performance by tuning complex mappings.
• Extensively involved in unit testing, integration testing and system testing of the mappings and writing Unit and System Test Plan.
• Migrated objects from the development environment to the QA/testing environment to facilitate the testing of all objects developed and check their consistency end to end on the new environment.
• Involved in production support, resolving the production job failures, interacting with the operations support group for resuming the failed jobs.

Environment: Informatica Power Center 7.1, WindowsAutosys 4.5, HP-UNIX 11i, Oracle 9i, PL/SQL, IBM DB2 8.5, VSAM files UDB 8.