SUMMARY

• Over Eight years of strong IT experience in Analysis, Design, Development, Administration and implementing software solutions in Data Warehousing tools like Informatica PowerMart/ Powercenter, Informatica Data quality (IDQ), DataStage 8.5, Power Exchange, MS SQL Server Integration(SSIS) and Reporting Services(SSRS).
• In - depth knowledge of Software Development Lifecycle including Requirements gathering, Analysis, Design, Implementation, and Maintenance.
• Highly proficient in Data Modeling concepts using Erwin, Visio, Star Schema/Snowflake modeling, Facts & Dimension tables for Conceptual, Logical & Physical data modeling.
• Expertise in Data warehouse methodologies (Kimball and Inmon approaches), ODS, EDW and Metadata repository, Business Process Analysis, Reengineering, Dimensional Data modeling.
• Strong experience in implementing complex business rules by creating re-usable transformations and robust mappings/mapplets using various transformations like Lookup, Source Qualifier, Union, Router, Expression, Aggregator, Joiner, Update Strategy, Normalizer and Transaction Control etc.
• Extensively used lookups. Connected, Unconnected… Worked with all types of caches in lookups… Static cache, Dynamic cache and Persistent caches.
• Expertise in designing and building the sessions using reusable objects i.e. shared sources, targets, reusable transformations, Mapplets, reusable sessions, reusable tasks and worklets.
• Expertise in using Mapping parameters and variables and parameter files.
• Hands on experience in optimizing Mappings and implementing the complex business rules by creating re-usable transformations, Mapplets.
• Designed Parallel jobs using various stages like join, merge, lookup, remove duplicates, filter, dataset, sequential file, modify, Transformer and Change Data Capture stage.
• Excellent knowledge of Migration, backup, recovery, tuning, tracing and troubleshooting and good understanding of Session logs and reject files.
• Experience working on the project built using Agile Methodology. Involved in the estimate planning, design discussions and scrum meetings of the project.
• Experience working with IDQ transformations like Labeller, Parser, Standardizer etc.
• Have knowledge in using IDQ tool for profiling, applying rules and develop mappings to move data from source to target systems.
• Excellent knowledge of IDQ address validator to correct address, identify deliverable address.
• Good hands on working with Autosys scheduling tool to schedule Informatica jobs. Worked on building the supporting scripts and scheduling them thru Autosys.
• Working on building Unit and System Test plans. Coordinated with deployment teams in migrating code from one environment to another.
• Provided support to deployment teams in case of any issues in code deployment from one environment to another i.e. like fixing connections or helping in resolving issues in code due to unavailability of reusable objects in new environments etc....
• Good hands on experience in using SQL and PL/SQL. Worked on development of triggers, procedures, functions and packages to implement the business logic as per the requirement.
• Extensively worked with Teradata utilities like BTEQ, Fast Export, Fast Load, Multi Load to export and load data to/from different source systems including flat files.
• Ability to manage changing responsibilities taking initiatives and deliver critical projects on schedule.
• Self-motivated and able to work independently as well as a member of a team. Excellent communication, interpersonal and analytical skills.
• Experience in working with onsite-offshore models. Successfully handled projects with offshore teams.

TECHNICAL SKILLS

ETL tools: IBM Infosphere DataStage 8.5/7.5 (Designer, Director, manager, Administrator), Informatica PowerMart/PowerCenter 10.1.1/9.6/9.5/ 9.1/ 8.6/7.5.1, PowerConnect/PowerExchange, IDQ 10.1.1/9.1.0

Data bases: Oracle 11g, 10g, 9i, SQL Server-2008, DB2 and Teradata R12/R13

Reporting Tools: SSRS, Business Objects-v6.5

DB & other tools: Toad, PL/SQL developer, SQL* Plus, SQL*Loader, Rapid SQL

Programming: Oracle-SQL, PL/SQL, UNIX and Core-Java, C and C++

Operating systems: UNIX, WINDOWS7Professional, XP/NT/2000/98/95

PROFESSIONAL EXPERIENCE

Confidential, San Ramon, CA

Sr.ETL Developer

Responsibilities:

• Worked closely with multiple business units in requirement gathering, parsed high-level design spec and prepared LLD.
• Developed ETL processes for CCAR (Comprehensive Capital Analysis and Review) Implementation project.
• Created the reusable objects required for the mapping development and used them often in coding.
• Used best practices in coding and developed the mappings with high performance.
• Populated the Staging tables with various Sources like Flat files (Fixed Width and Delimited), Relational Tables (SQL Server and Oracle).
• Expertise in applying Performance Tuning techniques.
• Worked on ETL objects that were already in production and successfully modified to improve the performance.
• Performed technical walk-through as needed to communicate design/coded solution and to seek input from team members.
• Create mapping using Informatica IDQ (Data Quality) to cleanness data and feed into tables again.
• Use IDQ analyst tool to create rules and apply while running column profiling.
• Validated the current production data, existing data and the programming logic involved.
• Experience in debugging ETL jobs to check in for the errors and warnings associated with each Job run.
• Developed UNIX shell scripts to run the pmcmd functionality to start and stop sessions, batches and scheduling workflows.
• Strong problem solving skills. Helped production support teams in case of any issues in daily or monthly loads as a Level 3 support team member.

Environment: Informatica Power Center 10.1.1/9.6.1, PL/SQL, IBM Infosphere DataStage 8.5, IDQ 10.1.1/9.6.1, MS SQL Server, MS Access, Windows NT/2000, Autosys Scheduler.

Confidential, Milwaukee, WI

Sr. ETL Developer

Responsibilities:

• Worked on the requirements gathering and analysis for loading data into ODS.
• Worked closely with data population developers, multiple business units and a data solutions engineer to identify key information for implementing the Data warehouses.
• Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
• Parsed high-level design spec to simple ETL coding and mapping standards
• 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.
• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translating business rules and functionality requirements into ETL procedures.
• Developed and tested all the backend programs, Informatica mappings and update processes
• Populated the Staging tables with various Sources like Flat files (Fixed Width and Delimited), Relational Tables (Teradata and Oracle).
• Created mappings using various Transformations such as Source qualifier, Aggregator, Expression, lookup, Router, Filter, Rank, Look up, Sequence Generator, and Update Strategy.
• Created and used the Normalizer Transformation to normalize the flat files in the source data.
• Extensively built mappings with SCD1, SCD2 implementations as per requirement of the project to load Dimension and Fact tables.
• Expertise in applying Performance Tuning techniques. Worked on ETL objects that were already in production and successfully modified to improve the performance.
• Handled initial (i.e. history) and incremental loads in target database using mapping variables.
• Used Debugger to debug mappings and created breakpoints for better analysis of mappings.
• Defined Business rules in Informatica Data Quality (IDQ) to evaluate quality of data by creating cleanse processes to monitor compliance with standards and also identified areas for data quality gaps and assist in resolving data quality issues.
• Design and developed Exception Handling, data standardization procedures and quality assurance controls
• Exported Mappings from IDQ to Informatica Power Center
• Worked with Workflow Manager for maintaining Sessions by performing tasks such as monitoring, editing, scheduling, copying, aborting, and deleting.
• Created Bonus summary reports using SQL Server reporting tool (SSRS).
• Worked on Autosys job scheduling and Unix Scripting.
• Developed UNIX shell scripts to run the pmcmd functionality to start and stop sessions, batches and scheduling workflows.
• Performed Unit Testing and created unit test plan of the code developed and involved in System testing and Integration testing as well. Coordinated with the testers and helped in the process of integration testing.
• Worked with other team members and performed the knowledge transfer.

Environment: Informatica Power Center 9.6, PL/SQL, PowerExchange, IDQ 9.1.0, MS SQL Server, MS Access, MS SQL Server-2008 R2/2012.

Confidential, Los Angeles, CA

ETL Developer

Responsibilities:

• Developed ETL procedures to ensure conformity, compliance with standards and lack of redundancy, translating business rules and functionality requirements into ETL procedures.
• Developed and tested all the backend programs, Informatica mappings and update processes
• Created mappings using various Transformations such as Source qualifier, Aggregator, Expression, lookup, Router, Filter, Rank, Look up, Sequence Generator, and Update Strategy.
• Interpreted logical and physical data models for Business users to determine common data definitions and establish referential integrity of the system.
• Parsed high-level design spec to simple ETL coding and mapping standards
• 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.
• Used Evaluate expression options to validate and fix the code using Debugger tool while testing Informatica code.
• Worked with Workflow Manager for maintaining Sessions by performing tasks such as monitoring, editing, scheduling, copying, aborting, and deleting.
• Performed code reviews and involved in code migrations from Dev to Test and also supported deployments in code migration from Test to Prod environment.
• UsedTeradata Utilities FASTLOAD, MULTILOAD, TPUMPto load data
• Wrote BTEQ scripts to transform data. Wrote FAST EXPORT scripts to export data.
• Wrote, tested and implemented Teradata Fast load, Multi load and BTEQ scripts.
• Generated elaborate Test Cases and Test Plans to verify ETL code using business scenarios.
• Provided support to Prod Support team in any issues after code is migrated and live.
• Worked with other team members and performed the knowledge transfer.

Environment: Informatica Power Center 9.5/8.6, Oracle10g, Teradata R12/R13, Teradata SQL Assistant,MLOAD, TPUMP, FAST LOAD, FAST EXPORT, PL/SQL, MS SQL Server, MS Access.

Confidential

ETL Developer

Responsibilities:

• Worked on complete SDLC from Extraction, Transformation and Loading of data using Informatica.
• Collaborated with Business analysts and the DBA for requirements gathering, business analysis and designing of the data marts.
• Involved in the analysis, design and development of all the interface’s using Informatica Power mart tools in interface team and interfaced with all the other tracks for business related issues.
• Worked with heterogeneous sources from various channels like Oracle, SQL Server, flat files, and web logs.
• Wrote SQL procedures for data extraction, transformation and loading.
• Created mappings to move from Various Systems (CRM, OLTP) to Transaction History database (Reporting Database).
• Extensively used Transformations like, Aggregator, Router, Joiner, Expression, Lookup, Update Strategy and Sequence Generator.
• Used Debugger to test the mappings and fix the bugs. Used Evaluate expressions to fix any issues found while debugging any code issues.
• Extensively worked in the performance tuning of ETL mappings and Sessions.
• Used Mapping Wizard to create reusable sessions and workflows.
• Responsible for creating business solutions for Incremental and Full loads.

Environment: Informatica Power Center 8.1/7.5.1, Informatica Power Connect, Flat files, Oracle8i, Windows NT, MS SQLServer2000, Toad/PL/SQL, Windows, Unix Shell Programming.