SUMMARY

• Around 3 Years of IT experience with emphasis on business requirements analysis, application design, data modeling, development, implementations, testing and project coordination of applications.
• Experience in development and designing of ETL methodology for supporting data transformations using Informatica Power Center 9.x/ 10.x.
• Extensively used various active Transformations like Filter Transformation, Router Transformation, Joiner Transformation, Lookup Transformation and Aggregator Transformation.
• Worked with various Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.
• Experienced with different classes of ODS file systems and extracted the data using Informatica Power Center.
• Worked with different data sources like Flat Files, Databases.
• Experience in relational database development using PL/SQL and SQL in Oracle and SQL Server
• Experienced in Agile and Scrum methodologies for ETL development.
• Expertise in creating Mappings, Mapplets and reusable transformations using Informatica.
• Good understanding of relational database management systems and extensively worked on Data extraction, Cleansing, transformation, loading with Oracle and SQL Server using Informatica.
• Extensive experience in automation and batch scheduling using AutoSys and Control - M tools.
• Hands on experience in handling large volumes of data in production environments.
• Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
• Validated and tested the mappings using Informatica Debugger, session logs and workflow logs.
• Hands on experience in writing, testing and implementation of the triggers, stored procedures, functions, packages at database level and form level using SQL, PL/SQL.
• Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.
• Coordination with the off-shore development team to fix release issues.
• Coordination in preparing project plans with project manager and development team to make sure project plans are correct.
• Experience in all phases of SDLC including Requirements Gathering, Design, Development, Unit Testing, On-going support and Maintenance.

TECHNICAL SKILLS

RDBMS: Oracle 11g/10g, MS SQL SERVER 2008/2014

ETL Tools: Informatica (Power Center 9.5.1 / 9.6 / 10.2 )

BI Tools: Business Objects

Operating Systems: UNIX, Windows

Languages: SQL, PL/SQL, Unix shell scripting, HTML, C, C++, Java

Scheduler: AutoSys, Control-M

Version Control: SVN, GitHub

Other Tools: Toad, SQL-Developer, Service Now, MS-Office, MS Project Plan, MS Visio

PROFESSIONAL EXPERIENCE

Confidential, Chantilly, VA

ETL Developer

Responsibilities:

• Interacted with the Business Users to analyze the Business Requirements and transform the business requirements into the technical requirements.
• Extracted data from various heterogeneous sources like Oracle, SQL Server databases and Flat Files.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated into Data warehouse.
• Worked on Designer Tools like Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer and Mapping Designer.
• Extensively used various active Transformations like Filter Transformation, Router Transformation, Joiner Transformation and Aggregator Transformation.
• Responsible for Data Cleansing and Data Validation using Expression Transformation and Lookup Transformation.
• Analyzed business process workflows and developed ETL mappings to move data from various source systems to target systems.
• Developed database Schemas like Star schema and Snowflake schema used in relational, dimensional and multidimensional data modeling using ERWIN.
• Worked with various Informatica client tools like Source Analyzer, Warehouse designer, Mapping designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Workflow Manager.
• Created PL/SQL procedures to transform data from staging to Data Warehouse Fact and summary tables.
• Extensively used Stored Procedures, Functions and Packages using PL/SQL for creating Stored Procedure Transformations.
• Extensively used workflow variables, mapping parameters and mapping variables.
• Developed, Modified and tested UNIX Shell scripts and necessary test plan to ensure the successful execution of the data loading process.
• Created various UNIX Shell scripts for automation of events, File Validation, File Archiving.
• Developed scripts using PMCMD command to run the Workflows, Sessions from UNIX environment which are called in Control-M jobs.
• Developed batch file to automate the task of executing the different workflows and sessions associated with the mappings on the development server.
• Involved in Testing, Debugging, Data Validation and Performance Tuning of ETL process, help develop optimum solutions for data warehouse deliverables.
• Performance tuning of Informatica mappings for large data files by managing the block sizes, data cache sizes, sequence buffer lengths and commit interval.
• Created and worked on change requests in Service Now.
• Created defects and worked on Incidents for production issues in Service Now.
• Developed Business Objects Universe which acts a interface between database and end user.
• Worked on Unit Testing, Integration testing and Regression testing to verify load order, time window and lookup with full load.

Environment: Informatica Power Center 10.2, Business Objects XIR2, Erwin 7.3, Oracle 11g, Sql Server, Flat Files, Control-M, Service Now, SQL, PL/SQL, UNIX, Toad

Confidential

Informatica Developer

Responsibilities:

• Analyzed the business requirements and functional specifications.
• Extracted data from oracle database and spreadsheets and staged into a single place and applied business logic to load them in the central oracle database.
• Used Informatica Power Center 9.6 for extraction, transformation and load (ETL) of data in the data warehouse.
• Extensively used Transformations like Router, Aggregator, Normalizer, Joiner, Expression and Lookup, Update strategy and Sequence generator and Stored Procedure.
• Developed complex mappings in Informatica to load the data from various sources and capture exceptions.
• Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
• Parameterized the mappings and increased the re-usability.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Used Informatica Power Center Workflow manager to create sessions, workflows and batches to run with the logic embedded in the mappings.
• Prepared technical specification for the development of Extraction, Transformation and Loaded data into various stage tables.
• Created procedures/used Pre SQL to truncate data in the target before the session run.
• Extensively used Toad utility for executing SQL scripts and worked on SQL for enhancing the performance of the conversion mapping.
• Validated and tested the mappings using Informatica Debugger, session logs and workflow logs.
• Analyzed the sessions to find source and target bottlenecks.
• Debugged mappings by creating logic that assigns a severity level to each error, and sending the error rows to error table so that they can be corrected and re-loaded into a target system.
• Worked on bug fixes on existing Informatica Mappings to produce correct output.
• Automating the daily and monthly batch processes using AutoSys scheduler.
• Created a list of the inconsistencies in the data load on the client side so as to review and correct the issues on their side.
• Created the ETL exception reports and validation reports after the data is loaded into the warehouse database.
• Written documentation to describe program development, logic, coding, testing, changes and corrections.
• Created Test cases for the mappings developed and then created integration Testing Document.
• Followed Informatica recommendations, methodologies and best practices.

Environment: Informatica Power Center 9.5.1/ 9.6, Oracle 11g/ 10g, MS-SQL Server, Toad, HP Quality Center, Windows XP and MS Office Suite, AutoSys Scheduler, UNIX Shell Scripting.