SUMMARY

• Around 7+ Years of IT experience in Data Modeling, ETL Design, Development, Programming, Testing, Performance tuning, Implementation and Troubleshooting & error handling in the field of Data warehousing and gathering Business User Requirements.
• Strong Data warehousing experience specializing in RDBMS, ETL Concepts.
• Also performed ETL procedure to load data from different sources into data warehouse using Informatica Power Center (Repository Manager, Designer, Workflow Manager and Workflow Monitor).
• Expert in the ETL Tool Informatica. Has extensive experience in working with various Power Center Transformations using Designer Tool.
• Expertise in Data warehouse designing and Data modeling of physical/logical data, Facts and Dimensions, Star schema, analysis, implementation by using Erwin
• Strong Data analysis to ensure accuracy and integrity of data in the context of Business functionality.
• Strong knowledge and Experience in using Informatica Power Center 8.1/8.5/9.1/9.6 ETL tool.
• Understanding of Ralph Kimball Data Warehouse methodologies and knowledge on the various data design models like Star Schema and Snowflake models
• Expert - level mastery in designing and developing complex mappings to extract data from diverse sources including flat files, RDBMS tables, legacy system files.
• Extensive experience in designing and developing complex mappings from varied transformations logic like Unconnected and Connected lookups, Normalizer, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy.
• Implemented data warehousing methodologies for Extraction, Transformation and Loading using Informatica Designer, Repository Manager, Workflow Manager, Workflow Monitor, Repository Server Administration Console.
• Experience in working with UNIX Shell Scripts for automatically running sessions, aborting sessions and creating parameter files.
• Data Processing experience in designing and implementing Data Mart applications, mainly transformation processes using Informatica Power Center.
• Solid experience in writing SQL queries, Stored Procedures, Cursors, Indexes, Views, Sequences and Triggers.
• Expert developer skills in Teradata RDBMS, development and production DBA support use of FASTLOAD, MULTILOAD, and Teradata SQL and BTEQ Teradata utilities.
• Experience on Debugger to validate the mappings and gain troubleshooting information about data and error conditions.
• Experience on post-session and pre-session shell scripts for tasks like merging flat files after creating, deleting temporary files, changing the file name to reflect the file generated date etc.
• Experience on Business Intelligence / Reporting tool- BO XI R3, BO BI 4.1.
• Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.

TECHNICAL SKILLS

ETL & Reporting Tools: Informatica Power Center 9.x/8.x, BO XI R3, BO BI 4.1

Database: Oracle, SQL Server, Teradata, PostgreSQL, MySQL, MS Access

Programming: C, C++, Java, SQL, Korn Shell Scripting, Perl Scripting, Java Scripting

Tools: TOAD, SQL* Plus, HP Kintana, Dollar Universe, SSH Tectia Client, SVN, HP Quality Center, CVS, Artifactory Tool

Operating System: Windows, UNIX

Modeling Tool: Erwin, Rational Rose

PROFESSIONAL EXPERIENCE

Confidential, WI

ETL/Informatica Developer

Responsibilities:

• Analyzed the specifications and identified the source data that needs to be moved to data warehouse.
• Gathering requirements, conducting a design overview, detailing ETL specifications, data analysis/troubleshooting, implementation tasks, and general mentoring.
• Actively involved in meetings with the SME’s forbusiness requirements gathering and analysis of source systems data to comprehend their processing patterns.
• Developed the ETL logic to load data from various heterogeneous systems such as DB2, Flat files, Oracle 11g/12c.
• Created complex and robust mappings, workflows using workflow manager. Monitored tasks using workflow monitor.
• Used various transformations like Source Qualifier, Unconnected lookup, connected lookup, Expression, Joiner, Filter, Router, Update Strategy, and Procedure etc.
• Enhanced session and workflows performance by applying performance tuning on targets, sources, mappings and sessions.
• Worked on Informatica Power Center tool -Source Analyzer, Data warehousing designer, Mapping Designer & Maplets, Transformations, Work Flow Manager and Work Flow Monitor.
• Developed Workflows containing different Tasks like Sessions, commands, Decisions, Timer, Control, Email.
• Coordinated with the operations team for scheduling the Work Flows.
• Worked extensively with designer tool to develop Mappings, Mapplets, and Reusable transformations to extract, transform and load the data.
• Implemented Performance Tuning Logics wherever possible to provide maximum efficiency and performance.
• Involved in the performance tuning of Informatica mappings/sessions.
• Created and used parameter files to provide values to the variables used across sessions and workflows of Informatica.
• Involved in process of enhancing the existing Informatica and PL/SQL code and bug fixing.
• Created and executed Unit Test Plans for the various Mappings.
• Created new Unix Scripts and modified the existing scripts for enhancing the performance (optimizing)of the ETL jobs, Database updates, Automate the process, File handling.
• Coordinated with the QA team and production team during migration phase.
• Designed the framework Model, Report Structure for various subject areas based on their process and data analysis.

Environment: Informatica Power Center 9.6, Oracle 11g/12c, PL/SQL, SQL Server 2014, XML, MS Office tools.

Confidential, TX

Informatica Developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Translated requirements into business rules and made recommendations for innovative IT solutions.
• Developed FRD (Functional Requirement Document), data architecture document and communicated with the concerned stakeholders. Conducted Impact and feasibility analysis.
• Documented data conversion, integration, load, and verification specifications.
• Parsing high-level design specification into simple ETL coding and mapping standards.
• Worked with Power Center Designer tools in developing mappings and mapplets to extract and load the data from flat files to Oracle database.
• Maintained warehouse metadata, naming standards and warehouse standards for application development.
• Created the design and technical specifications for the ETL process of the project.
• Developing Mapping Documents indicating the source tables, columns, data types, transformation required, business rules, target tables, columns and data types.
• Used Informatica as an ETL tool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from flat files to Oracle database.
• Responsible for Business Analysis and Requirements Collection.
• Created the design and technical specifications for the ETL process of the project.
• Responsible in developing the ETL logics and the data maps for loading the tables.
• Responsible for mapping and transforming existing feeds into new data structures and standards using Router, Lookups Using Connected and Unconnected, Expression, Aggregator, Update Strategy & Stored Procedure transformation.
• Worked on Informatica Power Center Tool - Source Analyzer, Data warehousing designer, Mapping Designer & Mapplets, and Transformations.
• Maintained Development, Test and Production Mapping migration using Repository Manager. Involved in the enhancements and Maintenance activities.
• Worked on Teradata RDBMS, development and production DBA support. Experience in use of FASTLOAD, MULTILOAD and BTEQ Teradata utilities.
• Used Informatica as an ETL tool to create Data Marts, source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.
• Worked with slowly changing dimension Type1, Type2, and Type3.
• Creating Informatica Exception Handling Mapping for Data Quality, Data Cleansing and Data Validations.
• Created workflows containing Command, Email Session, Decision and wide variety of tasks.
• Created workflows based on dependencies in Informatica for the code changes.
• Implemented various new components like Incremental Loading, Validation Techniques, and load efficiency.
• Involved working on Unit testing, Integration/ System testing, Regression testing, and User Acceptance Testing.
• Writing UNIX scripts for unit testing the ETL Code (Sessions, Workflows, and Log Files).
• Developed the Business Objects Universe for some of the modules, enhanced the existing universe and created the Web Intelligence & Desktop Intelligence Reports in BO XI 4.1.
• Handled Unit testing and Data testing in both Development and Test environment.
• Scheduled batch and sessions within Informatica using Informatica scheduler and also wrote shell scripts for job scheduling.
• Employed performance tuning to improve the performance of the entire system.
• Migrated the SAP BO Universe and Reports from BO XI R3 to BOBI 4.1
• Understanding the entire functionality and major algorithms of the project and adhering to the company standards.

Environment: Informatica Power Center 9.5.1(Repository Manager, Designer, Workflow Manager, Workflow Monitor and Repository Server Admin console), BO XI R3/BOBI 4.1, Oracle 11g/12c, Korn Shell scripting, Dollar Universe

Confidential, PA

Informatica Developer

Responsibilities:

• Created Dimension Tables and Fact Tables based on the warehouse design.
• Involved in creating Logical and Physical design of databases using Erwin.
• Participated in build of the Data Warehouse, which includes the Design of Data mart using Star Schema.
• Created Repository using Informatica Power Center - Repository Manager.
• Extracted data from flat files and oracle database, applied business logic to load them in the central oracle database.
• Extensively worked in Oracle SQL, PL/SQL, SQL*Plus, SQL*Loader, Query performance tuning, Created DDL scripts, Created database objects like Tables, Views Indexes, Synonyms and Sequences.
• Developed and supported the extraction, transformation and load process (ETL) for a Data.
• Involved in Extraction, Transformation and Loading (ETL) Process.
• Used Teradata utilities like MultiLoad, and Fast Load to load data into Teradata data warehouse from Oracle and DB2 databases.
• Solved Various Defects in Set of wrapper Scripts which executed the Teradata BTEQ, MLOAD, FLOAD utilities and Unix Shell scripts.
• Organised a team of Developers to Develop, Unit Test, Test cases and Result Preparation Related with Loading Scripts and other deliveries related with Teradata scripts.
• Created necessary Repositories to handle the metadata in the ETL process
• Worked extensively with complex mappings using expressions, aggregators, filters, lookup and procedures to develop and feed in Data Warehouse.
• Created reusable transformations and Mapplets and used them in mappings. Extensively used Shell scripts to automate the Pre-Session and Post-Sessions processes.
• Performed data manipulation using basic functions and Informatica Transformations.
• Modified Universes and generated reports using Business Objects.
• Designed & developed reports, Drilldown reports using Business Objects Reporter.

Environment: Informatica 9.1, Oracle 9i, SQL Server, ERWin 3.5, Business Objects, UNIX (AIX), Windows NT,, Teradata V2R6, Teradata SQL Assistant, BTEQ, FLOAD, MLOAD.

Confidential, CA

Informatica Developer

Responsibilities:

• Identified business rules for data migration and analyzed the business requirements.
• Worked with pre and post sessions, and extracted data from Transaction system into Staging area.
• Extensively worked with Informatica Tools - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Repository Manager, Workflow Manager, Workflow Monitor, and Informatica Server.
• Created workflows with the event wait task to specify when the workflow should load the tables.
• Used PL/SQL to write store procedures to increase performance.
• Extensively used Debugger Process to test Data and applied Breakpoints.
• Loaded data from various sources using different transformations like Source Qualifier, Joiner, Sorter, Aggregator, Union, and Update Strategy to load data into the target.
• Worked on Data Cleansing, Data Conversion & Process implementation.
• Perl Scripting for backup and monitoring of databases.
• Provided daily support to clients including data research and test environment data refreshes.
• Monitored the processes to identify potential issues and apply preventative and correction actions.
• Designed the slowly changing dimension strategy for warehouse.
• Responsible for dealing with the problems, bug fixing and trouble shooting.
• Provided production support.
• Coordinated between Development, QA and Production migration teams.

Environment: Informatica Power Center 9.1, Oracle 11g/10g, MS Access, PL/SQL, Toad 9.6.1.1, Perl scripts

Confidential

ETL Developer

Responsibilities:

• Involved in different phases of SDLC from requirements, design, development, testing, training and rollout to the field user and support for production environment.
• Worked with Informatica Power Center client tools and SAP Business Objects Data Services / BODS.
• Created source and target mappings, transformation logic and processes to reflect the changing business environment over time.
• Designed and developed mapping, transformation logic and processes in Informatica for implementing business rules and standardization of source data from multiple systems into the data warehouse.
• Developed source to target mappings and scheduling Informatica Sessions.
• Maintained source and target mappings, transformation logic and processes to reflect the changing business environment over time.
• Worked on Oracle SQL, PL/SQL, Query performance tuning, Created DDL scripts, Created database objects like Tables, Indexes, Synonyms, and Sequences etc., closely worked with DBAs to create Physical Databases.
• Involved in designing the Data Mart and entire data warehousing life cycle.
• Involved and worked with DBA to build Dimension Tables and Fact Tables.
• Interacted extensively with user and Involved in gathering requirements, prototyping and prepared various documents like Interface Requirement Document, Customer Requirement document, Integration test plan, Unit test plan Release notes etc.

Environment: Informatica Power Center 8.x, UNIX, PL/SQL, Oracle 9i/10g, Oracle TOAD, SubVersion - SVN

Confidential

ETL Developer

Responsibilities:

• Provided 24*7 for Informatica (Production Support).
• Extensively used transformations like router, aggregator, lookup, source qualifier, joiner, expression, and sequence generator transformations in extracting data in compliance with the business logic developed.
• Used Informatica Designer to create complex mappings, transformations, source and target tables.
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions.
• Worked with Oracle database and SQL Server.
• Did SQL querying, optimization and performance tuning for Oracle DB and SQL Server.
• Wrote start up scripts and modified scripts performance issue resolution.
• Supported production jobs, data enhancements and code fixes.
• Involved in performance tuning of targets, sources, mappings, and sessions.
• Worked with UNIX shell scripts extensively for job execution and automation.

Environment: Informatica Power Center 8.1, Oracle 9i, SQL Server 2005, SQL Query Analyzer, Shell Scripting, UNIX