SUMMARY

• 8 years in IT with 7 years experience in Data warehouses using POWER CENTER as an ETL tool and 3 years in TABLEAU dashboard.
• Experience in designing and implementing ETL environments using ETL strategies as well as tools like INFORMATICA POWER CENTER 9.X/8.x/ 7.x/6.x
• Experience in Relational Databases (RDBMS), Data Modeling and Design and build the Data Warehouse, Data marts using Star Schema and Snow Flake Schema for faster and effective Querying. Implemented Ralph Kimball methodology in designing DWH and Enterprise DWH systems. Used extensively Erwin & Microsoft Visio for data modeling tools.
• Experience in the Analysis, Design, Development, Testing, and Implementation of business application systems for Retail, Financial, Automobile, Telecom and Manufacturing Sectors.
• Extensive experience in Extraction, Transformation and Loading of data from different heterogeneous source systems like Flat files, Excel, XML, DB2 UDB, Oracle, SQL Server, Teradata.
• Have strong experience on TABLEAU installation and configuration.
• TABLEAU experience in creating views aggregates, formatting, sorting, grouping and using filters to do calculations alongside using parameters.
• Extensively worked on Informatica power center tools - Designer, Workflow Manager, and Workflow Monitor & Repository Manager.
• Extensively worked on Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet and Mapping Designer.
• Worked on error handling and problem fixing in Informatica.
• Extensively worked in Design, Development, Testing and Production Environments.
• Extensively worked with Client's for gathering Requirements.
• Experience migration of code from different Environment i.e. from Dev to UAT/QA for testing.
• Exposure in preparation of Technical Design document, Test cases, Unit testing, System testing, and Integration testing.
• Hands on experience with Complex mappings from varied transformation logics like Connected and Unconnected Lookups, Router, Aggregator, Joiner, Update Strategy and Re-Usable transformations.
• Experience in Capturing Incremental data (CDC) from source systems.
• Involved in full life cycle development of Data Warehousing.
• Exposure in Data Modeling using Star/Snowflake Schema Design, Data Marts, Relational and Dimensional Data Modeling, Fact and Dimensional tables, Physical and Logical data modeling using Erwin.
• Worked Extensively with Slowly Changing Dimensions i.e. Type1, Type2 and Type3.
• Experience in Installation, Configuration of Informatica Power Center/Power Mart Client, Server.
• Perform and participate in all aspects of the project lifecycle including, requirements definition, solution design, and development.
• Experience in Oracle 11g/10g/9i/8.x, SQL Server 2000, MS Access 2000 database programming using SQL and standard built-in Oracle Packages.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.5/9.1/8.6.1/8.5/8.1/7. x/6.xSource Analyzer, Mapping Designer, Workflow MonitorWorkflow Manager, Data Cleansing, Data QualityRepository, Metadata, Data Mart, OLAP, OLTPWeb services, Power Mart 5.1/4.7.2, informatica Data-Analyzer 9.1, Power Exchange 8.

Data modeling tools: Erwin 7.x/ 4.2/3.x, Microsoft Visio

RDBMS: Oracle 11g/10g/9i/8i, IBM-DB2, MSSQL ServerTeradata V2R6, TD10, TD13 versions, MS Access's

Web Tools: HTML, DHTML, XML.

Other tools & Utilities: SQL* Plus, TOAD, Auto Sys

Languages: SQL, TSQL, C, C++

Scripting languages: UNIX Shell Scripting.

Operating systems: Windows 2000/2003/NT/XP, UNIX, LINUX

BI Tools: TABLEAU 8.1

PROFESSIONAL EXPERIENCE

Confidential

Informatica ETL & Tableau Developer

Responsibilities:

• Understood the Business point of view to implement coding using Informatica Power Center 9.1/8.6.1.
• Extensively used Informatica Power Center 9.1/8.6.1 working with source definitions, target definitions, mappings, mapplets, transformations, re-usable transformations, etc.
• Involved in design and development of complex ETL coding in an optimized manner.
• Redesigned some of the existing mappings in the system to meet new functionality.
• Optimized performance by tuning mappings and session level.
• Based on the requirements, used various transformation like Source Qualifier, Normalizer, Expression, Filter, Router, Update Strategy, Sorter, Lookup, Aggregator, Joiner and Stored Procedure transformations in the mapping.
• Developed Informatica SCD Type1, Type 2 and Type 3 mappings.
• Involved in performance tuning of mappings, transformations and (workflow) sessions to optimize session performance.
• Implemented Error Rejection process to load bad/invalid records into separate bad files either in the database or flat files
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command and Decision task.
• Created and scheduled sessions, jobs based on demand, run on time and run only once using Workflow Manager.
• Created parameter files to Dev, Test and Prod environments.
• Created Perl Scripts and called in Pre session and Post session commands.
• By using Autosys, created the job which runs a Perl script, the script in turn runs the ' PMCMD ' command to run a workflow.
• Involved in various testing activities like database testing, unit testing, system testing, performance testing and was also responsible for maintaining of testing metrics, defect tracking.
• Identified and debugged the errors before deploying and worked on migration of the maps and workflows from development to UAT using migration template.

Confidential

Informatica & Tableau Developer

Responsibilities:

• Involved Documentation of Data Warehouse using ETL (Extraction, Transformation and Load) tool Informatica.
• Analyzing existing database schemas and designing star schema models to support the users reporting needs and requirements.
• Extensively used Informatica Power Center 9.0.1 - Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer, Informatica Repository Manager and Informatica Workflow Manager.
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup (connected and unconnected), Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Extracted data from multiple sources like Oracle RDBMS, XML files and flat files to load data into data warehouse built on Oracle.
• Created and Configured Workflows, Worklets and Sessions to load the data to target warehouse tables using Informatica Workflow Manager.
• Developed Informatica SCD Type 1, Type 2 and Type 3 mappings.
• Implemented performance tuning logic on Targets, Sources, mappings, sessions to provide maximum efficiency and performance.
• Developed workflow and modified existing once, tasks like reusable Email, Event wait, Timer, Command and Decision task among others.
• Designed and Developed Oracle PL/SQL and Shell Scripts, Data Import/Export, Data Conversions and Data Cleansing, Performance tuning of Oracle PL/SQL Scripts .
• Hands on Stored Procedures, Functions, Packages and Triggers using PL/SQL.
• Designed UNIX Shell Scripts to automate Pre-Session and Post-Session Processes.
• Used SQL developer and TOAD to run SQL queries and validate the data in warehouse and data mart.
• Strong in UNIX Shell scripting. Developed UNIX scripts using PMCMD utility and scheduled ETL.
• Identified and debugged the errors before deploying and worked on migration of the maps and workflows from development to testing, testing to QA and from QA to production.
• Worked with a team to implement Tableau for better reporting visual optimizations from old systems.
• Involved in dashboard and worksheet development alongside managing sites in the server environment and other Admin responsibilities such as scheduling the extraction user Access management and security monitoring.

Confidential

Informatica Developer

Responsibilities:

• Extensively used Informatica Power Center 8.1 working with source definitions, target definitions, mappings, mapplets, transformations, re-usable transformations etc.
• Involved in design and development of mappings and stored procedures in an optimized manner.
• Implemented partitioning and bulk loads for loading large volume of data and better performance and less time performance.
• Involved in loading the data from Source Tables to ODS (Operational Data Store) Tables using Transformation and Cleansing techniques using Informatica.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Based on the requirements, used various transformation like Source Qualifier, Normalizer, Expression, Filter, Router, Update strategy, Sorter, Lookup, Aggregator, Joiner, Stored procedure transformations in the mapping.
• Developed mapplets and worklets for reusability.
• Implemented weekly error tracking and correction process using Informatica.
• Involved in performance tuning of mappings, transformations and (workflow) sessions to optimize session performance.
• Developed Informatica SCD type-I, Type-II and Type III mappings. Extensively used almost all of the transformations of Informatica including complex lookups, Stored Procedures, Update Strategy, mapplets and others.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command, Decision.
• Creating Test cases and detailed documentation for Unit Test, System and Integration Test to check the data quality.

Confidential

Informatica Developer

Responsibilities:

• Extensively used Informatica Power Center 8.6.1 working with source definitions, target definitions, mappings, mapplets, transformations, re-usable transformations, etc.
• Created source-to-target mappings, storage capacity planning, developing ETL processes using the Oracle Data Integrator 10g.
• Involved in design and development of complex ETL mappings and stored procedures in an optimized manner.
• Implemented partitioning and bulk loads for loading large volume of data.
• Involved in loading the data from Source Tables to ODS (Operational Data Store) Tables using Transformation and Cleansing Logic using Informatica.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Based on the requirements, used various transformation like Source Qualifier, Normalizer, Expression, Filter, Router, Update strategy, Sorter, xml, Lookup, Aggregator, Joiner, Stored procedure transformations in the mapping.
• Developed Informatica SCD type-I and Type-II mappings.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command, Decision.
• Created Stored Procedures, Packages in PL/SQL with Oracle in order to create, update several tables like Order processing Information table and Audit Log tables.
• Used PMCMD command to start, stop and ping server from UNIX and created UNIX SHELL PERL scripts to automate the process
• Created UNIX Shell scripts and called as pre session and post session commands.
• Creating Test cases and detailed documentation for Unit Test, System, Integration Test and UAT to check the data quality.

Confidential

Informatica Developer

Responsibilities:

• Identified the flow of information, analyzing the existing systems, evaluating alternatives and choosing the "most appropriate" alternative
• Developed mappings to extract data from Oracle, Flat files and load into Data Warehouse using the Mapping Designer
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target
• Understood the Business point of view to implement coding using Informatica Power Center designer
• All the jobs are integrated using complex Mappings including Mapplets and Workflows using Informatica Power Center designer and workflow manager.
• Migrate historical data, which is one time and built migration process for ongoing data loads using Informatica power center designer
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse
• Involved in versioning the whole process and retiring the old records using the built-in DD UPDATE, DD DELETE and DD INSERT
• Developed standards and procedures for transformation of data as it moves from source systems to the Data Warehouse
• Extensively used "pmcmd" commands on command prompt and executed UNIX Shell scripts to automate workflows and to populate parameter files
• Debugging invalid mappings using break points, testing of stored procedures and functions, testing of Informatica sessions, batches and the target Data
• Identified sources, targets, mappings and sessions and tuned them to improve performance
• Written Triggers, Stored Procedures for Complex mappings, Used Debugger in troubleshooting the existing mappings
• Created and scheduled sessions, jobs based on demand, run on time and run only once using Workflow Manage
• Involved in various testing activities like database testing, unit testing, system testing, performance testing and was also responsible for maintaining of testing metrics, defect tracking .

Confidential

ETL Developer

Responsibilities:

• Involved in gathering and reviewing business requirements. Involved in designing the specifications, Design Documents, Data modeling and design of data warehouse.
• 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.
• Created the repository manager, users, user groups and their access profiles.
• Created complex mappings in Power Center Designer using Expression, Filter, Sequence Generator, Update Strategy, Joiner and Stored procedure transformations.
• Created connected and unconnected Lookup transformations to look up the data from the source and target tables.
• Modeling and populating the business rules using mappings into the Repository for Meta Data management.
• Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), and Informatica and ETL package design, and RDBMS systems like SQL Server, Oracle.
• Implemented Slowly Changing Dimensions (SCDs, Both Type 1 & 2).
• Cleansed the source data, extracted and transformed data with business rules, and built reusable mappings, known as ‘Mapplets’ using Informatica Designer.
• Involved in the development of Informatica mappings and also performed tuning for better performance.
• Extensively worked on tuning (Both Database and Informatica side) and thereby improving the load time.
• Setting up sessions to schedule the loads at required frequency using Power Center, Workflow manager, PMCMD and also using scheduling tools
• Used parallel processing capabilities, Session-Partitioning and Target Table partitioning utilities.
• Automated the entire processes using UNIX shell scripts.
• Conduct status meetings with project managers, escalate issues when necessary, conducts meetings for issues resolution.

Environment: Informatica Power Center 8.6/8.5, Windows-NT, Oracle 9i/10g, DB2, SQL, PL/SQL, SQL * Loader, T SQL, TOAD, XML.