SUMMARY

• 6+ years of IT professional experience with involvement in Analysis, Design and Development of differentETLapplications and using Business Intelligence Solutions in Data Warehousing and Reporting with different databases.
• Expertise in Full Life Cycle development of Data Warehousing.
• Strong experience in providingETLsolutions usingInformaticaPower Center 9.x/8.x/7.x
• Experience with dimensional modeling using star schema and snowflake models.
• Highly proficient in integrating data with multiple Databases involving Teradata, Oracle, My Sql, SQL Server, DB2,Mainframe and Flat Files like Delimited, Fixed width.
• Developed complex mappings inInformaticausing various transformations like Source Qualifier, Joiner, Aggregator, Update Strategy, Rank, Router, Java, Lookup - Connected & Unconnected, Sequence Generator, Filter, Sorter, Stored Procedure transformation etc.
• Good Experience with Change data Capture for pulling Delta data.
• Worked on Initial Load Mapping templates for historical load.
• Expertise in handling & creating process for Slowly Changing Dimension (SCD) Type 1 & Type 2 to maintain history in dimension tables.
• Proficiency in developing SQL with various Relational Databases.
• Experience in creating Stored Procedures, Functions, Views and Triggers.
• Having solid Experience in Informatica and Teradata combination process.
• Strong experience using Teradata utilities like MLOAD, FLOAD, TPUMP, FAST EXPORT and TPT for improving Teradata target load performance. Have also created BTEQ scripts to load data in to base tables.
• Strong Experience in doing Performance Tuning of Teradata BTEQs.
• Strong Experience in working with Tuning of Different Relational data bases.
• Extensively worked withInformaticaperformance tuning involving source level, target level and mapping level bottlenecks.
• Expertise on creating mappings for performing Data Quality, Data Cleaning & Data Validation.
• Created shell scripts to run theInformaticaworkflows and controlling theETLflow.
• Experience in doing DWH Production support on rotational basis.
• Experience with using Scheduling tools - Informatica Schedular, Maestro, Cron Job, Control M, and Autosys.
• Experienced in working both Waterfall & Agile Methodologies.
• Experience with Agile Tools Rally, Jira & Scrum Process.
• Experience working with offshore and onsite co-ordination.
• Able to work independently and collaborate proactively & cross functionally within a team.
• Good team player with ability to solve problems, organize and prioritize multiple tasks.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 10.1/ 9.6.1/9.5.1 /8.6.1/8.1.1

RDBMS: Oracle 10g/9i/8i, Teradata 15/14/12, DB2, SQL Server, DB2, MySQL, Sybase

Modelling: Dimensional Data Modeling, Star Schema Modeling, Snow - flake Schema Modeling, Erwin, Microsoft Visio.

Reporting Tools: Cognos, Business Objects, Dashboard

QA Tools: Quality Center

Languages: Java, XML, UNIX Shell Scripting, SQL

Operating System: Unix, Linux, Windows

PROFESSIONAL EXPERIENCE

Confidential, Woonsocket, RI

Sr. ETL Informatica Developer

Responsibilities:

• Analyzed the Business Requirement Documents (BRD) & Source to Target Mapping Document (STM) for better ETL Process before the development.
• Used Informatica Power Center to pull data from different source systems/ files, cleanse, transform and load data into the Teradata using Teradata Utilities.
• Worked with Oracle Golden Gate system to extract data from it.
• Worked to establish the pumps for Oracle Golden Gate.
• Worked on Informatica- Source Analyzer, Warehouse Designer, Mapping Designer & Mapplet, and Transformation Developer.
• Created Reusable transformations, Mapplets, Worklets using Transformation Developer, Mapplet Designer and Worklet Designer.
• Used most of the transformations such as the Source Qualifier, Expression, Aggregator, Filter, Connected and Unconnected Lookups, Joiner, java, update strategy and stored procedure.
• Extensively used Pre-SQL and Post-SQL scripts for loading the data into the targets according to the requirement.
• Used command task extensively to execute the unix scripts from informatica.
• Developed mappings for SCD Type 1 and SCD Type 2 dimensions.
• Created process to handle Change Data Capture (CDC).
• Involved in source data Profiling and Tuning of queries for Source Data Extraction
• Involved in Initial loads, Incremental loads and Daily loads to ensure that the data is loaded in the tables in a timely and appropriate manner.
• Involved in Enhancing existing Production Objects for additional reporting requirements.
• Tuned the performance of mappings by following Informatica best practices and also applied several methods to get best performance by decreasing the run time of workflows.
• Worked extensively on Informatica Partitioning when dealing with huge volumes of data and also partitioned the tables in Teradata for optimal performance.
• Loaded data in to the Teradata tables using Teradata Utilities Bteq, Fast Load, Multi Load, and Fast Export, TPT.
• Extensively worked in the performance tuning of Teradata BTEQ.
• Worked with power exchange to extract the data from mainframe.
• Worked extensively with different Caches such as Index cache, Data cache and Lookup cache (Static, Dynamic and Persistence) while developing the Mappings.
• Involved in moving the BIG data Hive QL process to Informatica & Teradata.
• Involved in analysis for future migration of Informatica to SSIS and knowledge on SSIS tool.
• Responsible for Unit Testing, Integration Testing and helped with User Acceptance Testing.
• Involved in doing DWH data Analysis for reporting & also written SQL for ADHOC reporting purpose.
• Written Unix Wrappers for different purposes - PMCMD in Built, Archiving Logs, Purging data, FTP the Files.
• Co-ordinate with reporting team for better understanding of DWH data.
• Involved in writing technical design documentation along with deployment activities.
• Scheduling Informatica jobs and implementing dependencies if necessary using Maestro.
• Involved in Heavy Production Support on rotational basis.
• Managed enhancements and coordinated with every release with inInformaticaobjects
• Written thorough design docs, unit test documentation, Deployment & Runbook documents.
• Worked under Agile methodology and used Rally tool one to track the tasks.

Environment: InformaticaPower Center 9.6.1/9.5.1 , SSIS, Teradata 15/14/13.10, Oracle 10g,Oracle Golden Gate, DB2, Hadoop, Hive QL, XML, Flat Files, Teradata Sql Assistant, Toad, Sql, PL/SQL, Unix shell scripting, Cognos, SVN, Unix, Windows.

Confidential, Tysons Corner, VA

ETL Informatica Developer

Responsibilities:

• Worked with Business Analyst and Requirements understanding.
• Worked onInformaticaPowerCenter tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Design reference data and data quality rules using IDQ and involved in cleaning the data using IDQ inInformaticaData Quality 9.5 environment.
• Parsed high-level design specification to simpleETLcoding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time.
• Involved in building theETLarchitecture and Source to Target mapping to load data into Data warehouse.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data warehouse.
• Review existing code, lead efforts to tweak and tune the performance of existingInformatica processes.
• Scheduling the sessions to extract, transform and load data in to warehouse database on Business requirements.
• LeadingInformaticateam, coordinating with various group to understanding requirements, test code, migrate code and involved in production support.
• Hands on experience usingInformaticato integration with Teradata.
• Worked in Power Exchange to connect and import sources from external systems like SAP R/3, DB2, Salesforce, Mainframes, and AS/400.
• Supported team members in programming, review and coding ofETLapplications.
• Design the architecture for production support in order to scheduling the tasks (without any manual intervention) using Unix Shell Scripting.
• Experience in Unit testing, System testing while moving the code from development to production
• Created Teradata utilities like MLOAD, FLOAD and Tpump for loading data to various phases.
• Worked on Real time component like registration and restart token setup of PowerExchange.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Wrote UNIX shell Scripts & PMCMD commands for FTP of files from remote server and backup of repository and folder.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move the mappings from development to testing and then to production repositories.

Environment: InformaticaPower Center 9.5.1/9.1.1 , IDQ 9.5.1, Power Exchange, SQL, PL/SQL, Oracle 11g, Flat Files, Autosys, Cron Job, Sybase, UNIX AIX, Agile, Teradata V14, Toad 9.0, Cognos 8.

Confidential, Pheonix,AZ

Sr. ETL/Informatica Developer

Responsibilities:

• Interacted with Business Analyst to understand the business requirements.
• Involved in Understanding the logical and physical data models with Modellers & Data Architects.
• Involved in staging the data from external sources and was responsible for moving the data into the Warehouse usingETLInformatica.
• Involved in building the ETL architecture using Informatica 9.1.1/ 8.6.1 and Source to Target mapping to load data into Data warehouse.
• UsedInformaticaas anETLtool to create source/target definitions, mappings and sessions to extract, transform and load data into staging tables from various sources.
• Responsible for mapping and transforming existing feeds into the new data structures and standards utilizing Router, Lookups (Connected, Unconnected), Expression, Aggregator, Update strategy & stored procedure transformation.
• Used SCD Type 2 to populate the data in a generic way. Single mapping is used to load multiple tables.
• The scope of this design includes a generic design for implementing tables whose content will be managed in part by end-users of the Data Warehouse. The content changes can be made via the standard production change request process.
• Created mappings using flat files and relational databases as sources to build update Mappings.
• Created reusable transformations and mapplets and used them in mappings.
• Written SQL override queries in source analyzer to customize mappings.
• Debug mappings to gain troubleshooting information about data and error conditions usingInformaticaDebugger.
• As the requirement is to maintain the history of every change for all columns, have implemented the slowly changing dimension type 2 with effective start and end date of the record.
• Providing periodic update to customer on the coding, unit testing,release and act as Coordinator between development and business team.
• Handled UNIX system tasks by generating Pre and Post-Session UNIX Shell Scripts.
• Analyzed source data and formulated the transformations to achieve the customer requested reports.
• Performed Unit testing and moved the data into QA.
• Handled UNIX system tasks by generating Pre and Post-Session UNIX Shell Scripts.
• Analyzed source data and formulated the transformations to achieve the customer requested reports.
• Performed Unit testing and moved the data into QA.
• Participated in scheduling workflows, error checking, production support, maintenance as well as in testing of ETL procedures usingInformaticasession logs.
• Involved in Performance tuning on sources, targets mappings and SQL (Optimization) tuning.
• Documentation of the project activity all along the course of the project along with Failure Recovery plans.

Environment: InformaticaPower Center 9.5.1/9.1.1 /8.6.1, MS SQL server2005/2008, My Sql, Oracle 11g, PL/SQL, TOAD, Flat Files, Windows, Unix.

Confidential

Jr. ETL/Informatica Developer

Responsibilities:

• Used update strategy to effectively migrate data from source to target.
• Moved the mappings from development environment to test environment.
• DesignedETLProcess usingInformaticato load data from Oracle, Flat Files to target Oracle Data Warehouse.
• Interacted with the business community and database administrators to identify the Business requirements and data realties.
• Created various transformations as per the business logic like Source Qualifier, Normalizer, Lookup, Stored Procedure, Sequence Generator, Router, Filter, Aggregator, Joiner, Expression and Update Strategy.
• Created design documentInformaticamappings based on business requirement.
• CreatedInformaticamappings using various Transformations like Joiner, Aggregate, Expression, Filter and Update Strategy.
• Wrote stored procedures, functions, Packages and used in many Forms and Reports.
• Wrote database triggers for automatic updating the tables and views.
• Involved in the performance improvement project.
• Involved in designing of testing plan (Unit Testing and System Testing).
• Tested scripts by running workflows and assisted in debugging the failed sessions.
• Improving workflow performance by shifting filters as close as possible to the source and selecting tables with fewer rows as the master during joins.
• Used persistent caches whenever data from workflows were to be retained.
• Used connected and unconnected lookups whenever appropriate, along with the use of appropriate caches.
• Created tasks and workflows in the Workflow Manager and monitored the sessions in the Workflow Monitor.
• Perform Maintenance, including managing Space, Remove Bad Files, Remove Cache Files and monitoring services.
• Set up Permissions for Groups and Users in all Development Environments.
• Involved in the team meetings and providing status report to project manager.

Environment: InformaticaPower Center 7.1/8.1.1, Oracle 9i, Flat Files, OBIEE, PL/SQL, UNIX, Autosys, ERWIN, TOAD, UNIX Shell Scripting.