SUMMARY

• 7+ years of specialized IT experience in building Enterprise Data Warehouse, Data Marts, Operational data stores in major industry sectors using Informatica Power Center 9.x and 8.x
• Strong Focus on Software Development Life Cycle (SDLC) with design, concept, architecture, planning, modeling, coding, development, testing, implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, Data Masking, ETL, OLAP, BI.
• Expertise in working with relational databases such as Oracle 10g/9i,Teradata 14/12, SQL Server 2000/2005/2008 , DB2, MySQL, Sybase.
• Strong experience working with Business Analyst & Modelers to understand the requirements, Model.
• Solid experience working in data masking projects while performing data masking through Informatica.
• Profound knowledge about data masking transformation in Informatica and data masking in general.
• Designed and developed complex mappings to move data from multiple sources into a common target area such as Data Marts and Data Warehouse using lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Normalizer, Sequence Generator, and Update Strategy from varied transformation logics in Informatica as well as performance tuning of mappings and sessions.
• Strong experience in Enterprise Data Warehouse environment with Informatica & Teradata combination and extensive work with Slowly Changing Dimensions (SCDs).
• Hands on experience with Teradata utilities likeBTEQ, Fast Export, Fast Load, and Multi Loadto export and load data to/from different source systems including flat files.
• Extensive experience in writing UNIX shell scripts and automation of the ETL processes using UNIX shell scripting. Worked with PMCMD to interact with Informatica Server from command mode.
• Expertise in OLTP/OLAP System Study, Understanding E - R modeling and Dimensional Models using Star schema and Snowflake schema techniques, Identifying Facts and Dimensions.
• Good communication skills with ability to work as Team player. Ability to work in groups as well as independently with minimum supervision.
• Expert Agile & Waterfall methodology also expert in using Agile tools like Rally & Jira.

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 9.6.1/9.5.1 /8.6.1/7.1.1

Modeling: Dimensional Data Modeling, Star Schema Modeling, Snow - flake Schema Modeling, E-R Modeling, Microsoft Visio.

RDBMS: Oracle 11g/10g/9i, Teradata 14/13/12, DB2, SQL Server 2000/2005/2008 , DB2,MySQL, Sybase

Reporting Tools: Cognos, Business Objects

Operating Systems: Windows, Unix & Linux

Languages: XML, UNIX Shell Scripting, SQL, PL/SQL

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

Informatica / Teradata Developer

Responsibilities:

• Performed major role in understanding the business requirements and understanding the business model.
• Developed complex mappings using Informatica with multiple sources and targets in different databases, flat files and loading them in to Teradata.
• Solved Various Defects in Set of teradata Scripts which executed the Teradata BTEQ, MLOAD, FLOAD utilities.
• Imported various Application Sources, created Targets and Transformations using Informatica Power Center 10.1 Designer (Source analyzer, Transformation developer, Mapplet designer, and Mapping designer).
• Developed masking routines using Informatica mappings using various masking rules and data masking transformation.
• Created Informatica Power Center mappings, sessions, workflows and worklets.
• Used Expression, Unconnected /Connected Lookup, Router and Data Masking transformations to create the mappings.
• Utilized BTEQ, Mload and FastLoad utility of the Teradata to load data in the Teradata Enterprise Data warehouse (EDW).
• Used PMCMD commands of Informatica in UNIX scripts to schedule workflows and jobs.
• Experienced and involved in doing Performance tuning for BTEQ and Teradata queries.
• Used parameters, variables and parameter file in Informatica.
• Performed debugger testing and unit testing for Informatica mappings.
• Developed and scheduled Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results in Workflow monitor.
• Wrote Teradata queries to unit test in place masking applications.
• Worked closely with Architect and Lead for the applications assessment with the Data Masking team and provided support on the databases and applications.

Environment: Informatica Power Center 10.1, SQL Developer for Oracle, Oracle 10g/11g, PL/SQL, DB2, Teradata 15,Teradata SQL Assistant, Toad, Unix, Windows.

Confidential, Dallas, TX

Sr. ETL Informatica Developer / Teradata Developer

Responsibilities:

• Involved in designing the process for getting the data from all systems to Data Warehousing system.
• Performed major role in understanding the business requirements and designing and loading data into data warehouse (ETL).
• Imported various Application Sources, created Targets and Transformations using Informatica Power Center 9.6.1 Designer (Source analyzer, Transformation developer, Mapplet designer, and Mapping designer).
• Collection of data source information from all the legacy systems and existing data stores.
• Involved in Data Extraction, Transformation and Loading from source systems to ODS.
• Developed complex mappings using multiple sources and targets in different databases, flat files and loading them in to Teradata.
• Used various transformations like Unconnected /Connected Lookup, Aggregator, Expression Joiner, Sequence Generator, Router etc.
• Responsible in the development of Informatica mappings and tuned for better performance.
• Developed and scheduled Workflows using task developer, worklet designer, and workflow designer in Workflow manager and monitored the results in Workflow monitor.
• Worked with Reporting team which utilizes Business Object tools for objects and to address their need from ETL point of view.
• Extensively used Dynamic lookup to implement the type 2 changes.
• Implemented various loads like Daily Loads, Weekly Loads, and Quarterly Loads using Incremental Loading Strategy using the concepts of Change Data Capture (CDC).
• Utilized BTEQ, Mload and FastLoad utility of the Teradata to load data in the Teradata Enterprise Data warehouse (EDW). Used PMCMD commands of Informatica in UNIX scripts to schedule workflows and jobs.
• Experienced and involved in doing Performance tuning for BTEQ and Teradata queries.

Environment: Informatica Power Center 9.6.1, Oracle 10g/11g, PL/SQL, DB2, Teradata, Toad, Erwin, Business Object 6.0, Unix, Windows.

Confidential, San Antonio, TX

Sr. ETL Developer

Responsibilities:

• Developed internal and external Interfaces to send the data in regular intervals to Data warehouse systems.
• Worked closely with Architects, Lead and Project Manager for the applications assessment to all the Data Masking team and provided support on the databases and applications
• Utilized BTEQ, Mload and FastLoad utility of the Teradata to load data in the Teradata Enterprise Data warehouse (EDW).
• Analyzing results of Queries and review with Business Colleagues to define masking plans.
• Extensively used Power Center to design multiple mappings with embedded business logic.
• Involved in discussion of user and business requirements with business team.
• Performed data migration in different sites on regular basis.
• Involved in upgrade of Informatica from 9.1 to 9.5.
• Created complex mappings using Unconnected Lookup, Sorter, and Aggregator and Router transformations for populating target tables in efficient manner.
• Attended the meetings with business integrators to discuss in-depth analysis of design level issues.
• Involved in data design and modeling by specifying the physical infrastructure, system study, design, and development.
• Extensively involved in performance tuning of the Informatica ETL mappings by using the caches and overriding the SQL queries and by using Parameter files.
• Developed complex SQL queries to develop the Interfaces to extract the data in regular intervals to meet the business requirements and extensively used Teradata Utilities like M - load, F- Load, TPT, BTEQ and Fast Export.
• Analyzed session log files in session failures to resolve errors in mapping or session configuration.
• Written various UNIX shell Scripts for scheduling various data cleansing scripts, loading process and automating the execution of maps.
• Created transformations like Expression, Lookup, Joiner, Rank, Update Strategy and Source Qualifier Transformation using the Informatica designer.
• Created mapplets and used them in different mappings.
• Worked on Flat Files and XML, DB2, Oracle as sources.
• Written PL/SQL Procedures and functions and involved in change data capture (CDC) ETL process.
• Implemented Slowly Changing Dimension Type II for different Dimensions.
• Involved in Informatica, Teradata and oracle upgrade process and testing the environment while up gradation.
• Worked with Informatica version Control excessively.
• Experience in using SVN as version control for migration.
• Written Unit test scripts to test the developed interfaces.
• Managed enhancements and coordinated with every release with in Informatica objects.
• Provided support for the production department in handling the data warehouse.
• Worked under Agile methodology and used Rally tool one to track the tasks.
• Written thorough design docs, unit test documentation, Installation and configuration guide documents.
• Performed bulk data imports and created stored procedures, functions, views and queries.

Environment: Informatica Power Center 9.6.1/9.5.1 , Teradata 14/12, Oracle 10g, DB2, XML, Flat Files, SQL Assistant, Toad, PL/SQL, Unix shell scripting, Cognos, SVN, Windows 7.

Confidential - Dallas

Informatica ETL Developer Intern

Responsibilities:

• Involved in Requirement analysis in support of Data Warehousing efforts
• Maintain Data Flow Diagrams (DFD’s) and ETL Technical Specs or lower level design documents for all the source applications
• Worked with source databases like Oracle, SQL Server and Flat Files
• 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
• Created complex mappings using Unconnected and Connected lookup Transformations
• 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
• 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
• Worked with various Informatica Power Center objects like Mappings, transformations, Mapplet, Workflows and Session Tasks
• Responsible for the performance tuning of the ETL process at source level, target level, mapping level and session level
• Worked extensively with update strategy transformation for implementing inserts and updates
• 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
• 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
• Auditing is captured in the audit table and EOD snapshot of daily entry is sent to the distributed list to analyze if anything is abnormal
• Monitored workflows and session using Power Center workflows monitor
• Used Informatica Scheduler for scheduling the workflows

Environment: Informatica Power Center 8.5 / 8.6.1, Oracle 9i, SQL Server, Sybase, SQL, PL/SQL, Cognos, Unix AIX and windows XP.