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, TPUMP, 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-SAP BO XI R3, SAP 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 PowerCenter 9.x/8.x, SAP BO XI R3, SAP BO BI 4.1

Database: Oracle 12c/11g/10g/9i/8i, SQL Server 2005, 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, Texas

Informatica Developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Translated requirements into business rules and made recommendations for innovative IT solutions.
• 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 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 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.
• 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 SAP BO XI 4.1.
• Handled Unit testing and Data testing in both Development and Test environment.
• Migrated the SAP BO Universe and Reports from SAP BO XI R3 to SAP BOBI 4.1
• Understanding the entire functionality and major algorithms of the project and adhering to the company standards.

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

Confidential, Texas

Informatica Developer

Responsibilities:

• Interacted with the Business users to identify the process metrics and various key dimensions and measures. Involved in the complete life cycle of the project.
• Developed FRD (Functional Requirement Document), data architecture document and communicated with the concerned stakeholders. Conducted Impact and feasibility analysis.
• Worked on dimensional modelling to design and develop STAR schemas by identifying the facts and dimensions. Designed logical models as per business requirements using Erwin.
• Responsible for Business Analysis and Requirements Collection.
• Created the design and technical specifications for the ETL process of the project.
• Translated requirements into business rules & made recommendations for innovative IT solutions.
• Documented data conversion, integration, load and verification specifications.
• Parsing high-level design spec to 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 Teradata database.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Worked on Teradata RDBMS, development and production DBA support. Experience in use of FASTLOAD, MULTILOAD, TPUMP, and Teradata SQL 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.
• Maintained Development, Test and Production Mapping migration using Repository Manager. Involved in enhancements and maintenance activities of the data warehouse including performance tuning.
• Implemented various new components like increasing the DTM Buffer Size, Database Estimation, Incremental Loading, Incremental aggregation, Validation Techniques, and load efficiency.
• Involved working on Unit testing, Integration/ System testing, Regression testing, and User Acceptance Testing.
• Performance tuning of the process at the mapping level, session level, source level, and the target level.
• Created Workflows containing command, email, session, decision and a wide variety of tasks.
• 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.

Environment: Informatica Power Center/Power Mart 9.x/9.0.1, PL/SQL Developer, Teradata 12, Shell Scripting, UNIX, Business Objects XIR3, Windows XP, TOAD.

Confidential, Texas

Informatica Developer

Responsibilities:

• Analysis of specification documents and prepared technical specification document accordingly while development.
• Used Informatica Power Center for (ETL) extraction transformation and loading data from heterogeneous source systems.
• Developed Informatica mappings by using various transformations like Lookup (Connected, Unconnected), Joiner, Expression, Aggregator, Update Strategy, Normalization, Stored Procedure etc.
• Prepared SQL Queries to validate the data in both source and target databases.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Performed unit testing and documented the unit test plan and its results.
• Scheduled the jobs using Dollar Universe scheduler.
• Designed the Business Objects Universes and developed the Web Intelligence and Desktop Intelligence reports according to the requirement.
• Followed optimized methods while developing the Business Objects Universe.
• Involved in migration of SAP BO Universe and Reports from SAP BO XI R3 to SAP BOBI 4.1.
• Involved in Knowledge Transfer, sessions to the clients for the BO BI 4.1 Reports.

Environment: Informatica 9.1,Oracle, SAP BO XI R3/BOBI 4.0, HP Kintana and Dollar Universe

Confidential, New York

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, and rollout to the field user and support for production environment.
• Worked with Informatica Power Center client tools.
• 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