SUMMARY:

• 8+ years of IT professional experience with involvement in Analysis, Design and Development of different  ETL applications 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 providing  ETL solutions using  Informatica  Power 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 in  Informatica using 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 with  Informatica performance 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 the  Informatica workflows and controlling the  ETL flow. 
• 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 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, Dayton, OH

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.

Environment: Informatica Power 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, Alpharetta, GA

Sr. ETL Informatica Developer

Responsibilities:

• Worked with Business Analyst and Requirements understanding. 
• Worked on Informatica PowerCenter 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 in Informatica Data Quality 9.5 environment. 
• Parsed high-level design specification to simple ETL coding and mapping standards. 
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time.
• Involved in building the ETL architecture 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 existing Informatica processes. 
• Scheduling the sessions to extract, transform and load data in to warehouse database on Business requirements. 
• Leading Informatica team, coordinating with various group to understanding requirements, test code, migrate code and involved in production support. 
• Hands on experience using Informatica to 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 of ETL applications.
• 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: Informatica Power 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, Phoenix, 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 using  ETL  Informatica. 
• 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.
• Used  Informatica as an  ETL tool 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 using  Informatica Debugger . 
• 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 using Informatica session 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: Informatica Power 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, Phoenix, AZ

Informatica Developer

Responsibilities:

• Designed and developed  ETL strategies and mappings from source systems to target systems.  ETLstrategies were designed to cater initial and incremental load . 
• Worked with source teams to resolve data quality issues raised by end users. 
• Mappings were developed in  Informatica employing transformations like Joiner, Expression, Aggregate, Rank, Lookup, Update Strategy, Filter and Router . 
• Applied Slowly Changing Dimension and Dynamic lookup techniques. 
• Used debugger to validate the mappings and gain troubleshooting information about data and error conditions. 
• Developed post and pre session shell scripts and scheduled Event based sessions at the  Informatica workflow manager. 
• Informatica Metadata repository was created using the Repository Manager as a hub for interaction between the various tools. 
• Used Metadata manager for validating, promoting, importing and exporting repositories from development environment to testing environment.
• Performed data quality analysis, gathered information to determine data sources, data targets, data definitions, data relationships, and documented business rules.
• Worked on loading Flat Files in to Data warehouse.
• Created Stored procedures, collections and packages.
• Used  Informatica Power center workflow manager to create sessions, batches to run with the logic embedded in the mappings 
• Implemented performance-tuning techniques by identifying and resolving the bottlenecks in source, target, transformations, mappings and sessions. 
• Responsible for identifying the missed records in different stages from source to target and resolving the issue. 
• Extensively used PL/SQL Procedures/Functions to build business rule. 
• Used parameters and variables (sessions/mappings) extensively for incremental loads. 
• Used SQL tools like TOAD to run SQL queries and validate the data. 
• Analyzed Session Log files in case the session failed to resolve errors in mapping or session configurations. 
• Setting up tasks to schedule the loads at required frequency using Power Center workflow manager. 
• DB2 Performance tuning both system and database management of DB and DBM configuration. Analyzing queries both Adhoc and Online and provide trace and log analysis. 
• Worked with DB2 Explain, Runstats, REORG and other ONLINE and Offline utilities.

Environment: Informatica PowerCenter8.6.1/8.1, Oracle 10g/9i, Db2, Flat Files, Toad, Putty, Winscp, UNIX,Windows.

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. 
• Designed  ETL Process using  Informatica to 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 document  Informatica mappings based on business requirement. 
• Created  Informatica mappings 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 T esting ).
• 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: Informatica Power Center 7.1/8.1.1, Oracle 9i, Flat Files, OBIEE, PL/SQL, UNIX, Autosys, ERWIN, TOAD, UNIX Shell Scripting.