SUMMARY:

• 8 Years of IT experience including Data Warehouse Design, Analysis, Architecture, Dimension Modeling, Business Intelligence strategy, Development, Testing, Implementation, Training and Documentation.
• Expertise in entire life cycle of DWH with project scope, Analysis, requirements gathering, data modeling, ETL Design, development, Unit / System testing and production support.
• Strong ETL experience of using Informatica 10.2/ 9.6.1/9.5.1 /9.1/8.6.1 Power Center Client tools - Source Analyzer, Target Designer, Transformation Developer, Mapping Designer, Mapplet Designer, Repository manager, Workflow Manager/Monitor.
• Developed complex mappings using Informatica Power Center Transformations - Lookup (Connected& Unconnected, Filter, Expression, Router, Joiner, Update Strategy, Aggregator, Stored Procedure, Sorter, and Sequence Generator.
• Having strong hands on experience in extraction of the data from various source systems like Teradata, DB2, Oracle, My Sql, Sql Server, Flat Files, XML and SFDC.
• Co- ordinated guided and leads the teams effectively in technology migration from Informatica 8.6 to 9.1.
• Experienced with Teradata utilities like BTEQ, M-LOAD, F-LOAD, F-EXPORT, T-PUMP & TPT
• Experienced with Teradata performance tuning using Explain Plan.
• Experience in resolving on-going maintenance issues and bug fixes, monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Experience in Understanding Data Warehouse Design & Model.
• Extensive experience in developing Stored Procedures, Packages, Functions, Views and Triggers, Complex SQL queries and Oracle PL/SQL.
• Proficiency in data warehousing techniques for Change Data Capture (CDC), Data Cleansing, S lowly Changing Dimensions (SCD - Type 1 and Type 2).
• Excellent interpersonal and communication skills, and is experienced in working with senior level managers, business people and developers across multiple disciplines.
• Solid analytical and dynamic troubleshooting skills.
• Self-motivated and enjoy working in a technically challenging environment.
• Experienced in scheduling of ETL jobs using diff scheduling tools Maestro, Autosys, Control-M.
• Independently perform complex troubleshooting, root-cause analysis and provide solution to fix defects.
• Experience in work allocation, status tracking and Coordinating with teams to keep them focused on the deliverables.
• Expertise in using both Agile & Waterfall Methodologies effectively.

PRIMARY SKILLS:

Databases: Teradata, Oracle, DB2, My Sql, Sql Server, Flat File, XML

TECHNICAL SKILLS:

ETL tools: Informatica Power Center 10.2/ 9.6.1/9.5.1 /8.6.1

Databases: Oracle 12c/11g/10g/9i, DB2, Teradata, My Sql, Sql Server, SFDC.

Languages: SQL, PL/SQL, UNIX, Shell Scripts, JAVA, XML.

Modeling: Dimensional Data Modeling, Star & Snow Flake Schema.

Reporting Tools: Cognos, Business Objects.

Operating System: Windows, Unix/Linux.

PROFESSIONAL EXPERIENCE:

Confidential, Irving, TX

Sr. Informatica ETL Developer & Support Engineer

Responsibilities:

• Involved in Walk-through meetings with Business Analysts to understand the Mapping Document.
• Strong Understanding logical and physical data models that capture current state/future state data elements and data flows using Erwin.
• Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database.
• Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer.
• High proficiency with Power Center and involved in utilizing Informatica product effectively to move Mainframe DB2 and flat-file data to oracle.
• Create ETL processes to extract data from Mainframe DB2 tables for loading into various oracle staging tables.
• Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
• Created Mapplet and used them in different Mappings.
• Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
• Implemented Slowly changing dimension Type 1 and Type 2 for change data capture.
• Worked with various look up cache like Dynamic Cache, Static Cache, Persistent Cache, Re Cache from database and Shared Cache.
• Performance tuning of the Informatica mappings using various options available in informatica.
• Performance tuning using Informatica partitioning.
• Used Teradata BTEQs to load data from staging to base database.
• Used Teradata Utilities - M-Load, F-Load, F-Export, T-Pump & TPT both at scripting level and along with Informatica connection.
• Involved in doing performance tuning (Using Explain Plan) of long running Teradata BTEQs in prod environment as part of the support team.
• Written UNIX Shell Scripts for various purposes in the project.
• Managed Change control implementation and coordinating daily, monthly releases.Extensively used debugger to test the logic implemented in the mappings.

Environment: Informatica Power Center 10.2/9.6.1, Oracle 12c/11g, DB2, Teradata 15, Flat Files, Sql Assistant, Toad, Unix.

Confidential, Tampa, FL

Sr. Informatica ETL Developer

Responsibilities:

• Maintain Mapping Documents for all the source applications.
• Involved in Requirement analysis in support of Data Warehousing efforts.
• Extensively worked with various Active transformations like Filter, Sorter, Aggregator, Router and Joiner transformations.
• Extensively worked with various Passive transformations like Expression, Lookup, Sequence Generator, Mapplet Input and Mapplet Output transformations.
• Worked with source databases like Oracle, SQL Server and Flat Files.
• Extensively worked with Teradata utilities BTEQ, F-Load, M-load & TPT to load data in to ware house.
• Responsible for definition, development and testing of processes/programs necessary to extract data from client's operational databases, transform, cleanse data and load it into data marts.
• Created complex mappings using Unconnected and Connected lookup Transformations.
• Responsible for the performance tuning of the ETL process at source level, target level, mapping level and session level.
• Implemented Slowly changing dimension Type 1 and Type 2 for change data capture.
• Worked with various look up cache like Dynamic Cache, Static Cache, Persistent Cache, Re Cache from database and Shared Cache.
• Worked extensively with update strategy transformation for implementing inserts and updates.
• Worked with various Informatica Power Center objects like Mappings, transformations, Mapplet, Workflows and Session Tasks.
• Auditing is captured in the audit table and EOD snapshot of daily entry is sent to the distributed list to analyze if there are any abnormalities.
• As per business we implemented Auditing and Balancing on the transactional sources so that every record read is either captured in the maintenance tables or wrote to Target tables.
• Extensively used the tasks like email task to deliver the generated reports to the mailboxes and command tasks to write post session and pre session commands.
• Extensively used debugger to test the logic implemented in the mappings.
• Performed error handing using session logs.
• Tuned performance of Informatica session for large data files by increasing block size, data cache size and target based commit interval.
• Involved in production support when required.
• Monitored workflows and session using Power Center workflows monitor.
• Used Informatica Scheduler for scheduling the workflows.
• Provided 24*7 supports for Production environment for Extraction, Loading and transformation of data by remote monitoring.
• Monitoring the Extraction and loading processes of data and Involved in writing UNIX shell scripting for automating the jobs.

Environment: Informatica Power Center 9.6.1/9.5.1 , Oracle, Sql server, My Sql, Flat Files, Teradata 14/12,Cognos, Unix and Windows.

Confidential, Chicago, IL

ETL Informatica Developer

Responsibilities:

• Involved in Requirement analysis in support of Data Warehousing efforts
• Reviewing the data model and ETL flow with Modelers & Architects.
• Providing the time estimation of various tasks involved in development phase.
• Understanding of client requirements during team discussions.
• Development of Informatica Mappings as per the requirement in STM to load data into the Data Warehouse.
• Writing SQL Scripts based on the requirement.
• Scheduling of Informatica sessions for testing automation of loads.
• Performance tuning of long running jobs in Informatica.
• Updating of ETL Specification, Test Case and Reporting Metadata Documents after testing in various environments (Development, QA and Production)
• Creating the functions and few rules for having a good data quality.
• Extracted the data from the Flat Files, Oracle and My Sql into staging area and populated in to data warehouse which is DB2.
• Developed and documented data Mappings/Transformations and Informatica sessions.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, Sequence Generator, look-up, Update Strategy, Rank, Joiner, and Stored procedure transformations.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Involved in Migration & Testing of mappings, sessions, worklets and workflows from Informatica 7.1 to Informatica 8.6.1 and make sure all the environment is upgraded properly.
• Responsible for the performance tuning of the ETL process at source level, target level, mapping level and session level.
• Extensively used the tasks like email task to deliver the generated reports to the mailboxes and command tasks to write post session and pre session commands.
• Extensively used debugger to test the logic implemented in the mappings.
• Performed error handing using session logs.

Environment: Informatica Power Center 9.6.1/9.5.1 Oracle, Sybase, SQL, PL/SQL, Cognos, Unix, Windows.

Confidential, Dallas, TX

ETL Developer

Responsibilities:

• Developed Informatica mappings, Reusable transformations. Developed and wrote procedures for getting the data from the Source systems to the Staging and to Data Warehouse system.
• Extensively used transformations to implement the business logic such as Sequence Generator, Normalizer, Expression, Filter, Router, Rank, Aggregator, Look Up (Target as well as Source), Update Strategy, Source Qualifier and Joiner, Designed complex mappings involving target load order and constraint based loading
• Create/build and run/schedule Workflows and Worklets using the Workflow Manager.
• Extensively worked in the performance tuning of the programs, ETL Procedures and processes. Coded Database triggers, functions and Stored procedures and written many SQL Queries. Helped coding shell scripts for various administration activities for daily backup. Involved in Physical schema implementation, objects like table-space, table rollback segments, Created database structures, objects and their modification as and when needed.
• Performance Tuning of the Informatica Mappings by adopting Explain plans, cutting down query costs using Oracle hints, changing the mapping designs.
• Responsible to tune ETL procedures and STAR schemas to optimize load and query Performance.
• Optimizing/Tuning mappings for better performance and efficiency, Creating and Running Batches and Sessions using the Workflow Manager, Extensively used UNIX Shell scripts for conditional execution of the workflows. Optimized the performance of Mappings, Workflows and Sessions by identifying and eliminating bottlenecks
• Performed Unit Testing at development level, Source code migration and documentation
• Involved in full life cycle development including Design, ETL strategy, troubleshooting Reporting, and Identifying facts and dimensions.
• Managed the Metadata associated with the ETL processes used to populate the data warehouse.

Environment: Informatica Power Center 9.5.1, Oracle, SQL, PL/SQL, UNIX, Erwin, Toad.

Confidential

Jr. ETL Developer

Responsibilities:

• Involved in Project Analysis and documenting the dev requirements.
• Worked with ETL Architects, Data Modelers & Business Analysts.
• Designed and developed database views and stored procedures, Packages and Functions.
• Used SQL to extract the data from the database and also using views on the tables.
• Worked with Development Life Cycle in performing the Data Movement.
• Wrote stored procedures, functions &Packages.
• Involved in the creation of Mapping for various requirements using Informatica and used Informatica Workflow Manager for configuring mappings also validated schedule run and monitor jobs using Workflow Monitor.
• Involved in the preparation of documentation for ETL using Informatica standards, procedures and naming conventions.
• Various features of PL/SQL such as Dynamic SQL and parameter passing of PL/SQL tables were evaluated.
• Developed SQL Applications for extracting the data from the Oracle tables.
• Created detailed system design specifications to serve as a guide for system and the program development.
• Wrote triggers and packages by using PL/SQL for giving security privileges.

Environment: Informatica Power Center 8.6.1/9.1.1, Oracle, SQL, PL/SQL, UNIX, Erwin, Windows NT.