PROFESSIONAL SUMMARY:

• Over 8+ years of IT experience in all phases of Software Development Life Cycle (SDLC) and Agile methodologies, Implementation of business applications for various clients.
• Extensive ETL experience of more than 7 years in data extraction, transformation and loading data using Informatica PowerCenter 9.x/8.x, 4 years in Informatica PowerExchange9.x,8.x and Data Warehousing and Teradata.
• Strong understanding of Dimensional Modeling, Star and Snowflake Schemas.
• Extensive Working experience in applying Relational Database concepts, Entity Relation diagrams and Normalization concepts.
• Proficient in data modeling and designing fact, dimensional and aggregate tables.
• As a ETL developer, have extensive experience in writing DDL, DML and DCL scripts, developing all database objects such as Tables, Views, Temporary tables, Partitions, Indexes and programming using PL/SQL to create Stored Procedures, Functions, Cursors, Triggers and Materialized Views.
• Worked on Data Mapping from OLTP to OLAP databases for BI Reporting.
• Tuning of SQL Queries, Database leading to significant improvement in system response time and efficiency using Hints, Indexing, parallel, Analyze, Explain plan, DBMS TRACE and TKPROF.
• Designed complex ETL mappings, reusable transformations using Regular Expressions, Dynamic Lookups, and Update Strategies for slowly changing dimensions, critical performance tweaking stages with fine - tuned source qualifier and extensive use of mapplets for common sub routines.
• Extensive experience in creating shell scripts for ETL workflow execution, sftpfile transfers, archival, PL/SQL execution and log generationfor daily status update.
• Worked in Agile mode in the salesforce data migration projects. Experience in UNIX working environment, writing UNIX shell scripts for Informatica pre & post session operations.
• Strong knowledge in RDBMS concepts and extensive experience in creation and maintenance of Tables, Views, Materialized Views, Stored Procedures, Packages, Synonyms, Indexes, Triggers, Bulk Load and PL/SQL programming.
• Excellent interpersonal, communication and presentation skills with the ability to successfully interact with team members and business customers.
• Outstanding communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new technologies and tools.
• Strong Team spirit, excellent interpersonal and management skills.

TECHNICAL SKILLS:

Databases: Oracle 9i/10g/11g/12c, Teradata 14/13/12, MS Access, SQL Server 2002

Core Skill Set: ETL (Informatica Power Center), Data Quality(IDQ), DataBase, Data Modeling, SQL, PL/SQL, and Data Warehousing

ETL tools and Utilities: Informatica Power Center 9.6/8.x, Informatica PowerExchange 9.6/9.1, Informatica IDQ,Apex Data loader (Salesforce), SQL*Loader, DAC, TOAD, SQL Server Management Studio and WinSCP

Programming Languages: Shell Script, C, C++, java

Job Scheduling tools: ESP Agent,Unix, Linux, Crontab and windows task scheduler

Reporting Tools: Qlikview and BOXI

PROFESSIONAL EXPERIENCE:

Confidential, Stanford, CA

Sr. Informatica Developer

Responsibilities:

• Data modelingin data warehouse for transactional data /flat files and designed change capturestrategyfor various loads.
• Data warehouse design and development, on data migration/conversion and validation
• Used transformations like Router, Update Strategy, Lookups, Filter, Joiner, Stored Procedureand Aggregator.
• Extensive experience in architecture, data modeling, proof of concept, requirement study and system analysis.
• Mainframe files processing and merging file data into warehouse.
• Nightly batch performance improvement, saved time in hours and made sure loads gets completed before business begins on the next day.
• Strong knowledge in OLTP schema (normalized) Vs Star schema (dimension, fact, aggregate tables, SCD)and SQL, PL/SQLexecution.
• Data migration from Siebel CRM to Salesforce - One-time load and ongoing delta
• Built mappings to bridge delta data from Salesforce into data warehouse systems
• Played as a liaison between the Siebel team and SFDC team
• Created database tables, indexes, partitions, stored procedures, functions, triggers, DB links as part of building the reports
• Extensive data analysis on Activity, Opportunity, Customer & Accounts data
• Shell script creation and modification for workflow execution and scheduling on LINUX
• Bridged the gap between ETL and BI team communications
• Worked with various Power Center components like Informatica Client tools like Mapping Designer, Workflow Manager, and Repository Manager & Workflow Monitor
• Saved hours in the nightly batch execution cycle by modifying the job schedule
• Optimal usage of persistent variables in change capture
• Replaced multiple update statements with Bulk inserts and Merge SQL to improve performance.
• Shell scripts creation to do file transfers using ftp/sftp protocols to multiple external systems.
• Resolved on-going maintenance issues and bug fixes; monitoring Informatica sessions as well as performance tuning of mappings.
• Implemented Slowly Changing Dimension practice for the objects that needed tracking history.
• Transformed legacy systems PL/SQL’s and shell scripts into mappings and workflows
• Solved defects raised in SIT, UAT phases. Delivering Functional and Technical specifications documentsfor every release.
• Tracking development items progress via daily stand up call with offshore.
• Extensive working knowledge in all SDLC and Agile lifecycle including requirements. gathering, analysis, design, review, documentation, development, testing, deployment and production support.
• Played active role in supporting all the go-lives for the project.
• Leading a team of ETL developers for this project.

Environment: Informatica PowerCenter 9.6/9.5.1, Informatica PowerExchange 9.6/9.5.1, IDQ, Oracle 11g, Sql Server2000/2008, UNIX Shell script, Linux, Toad, SQL *Loader, Salesforce, CDC, SQL, PL/SQL,Visio, Autosys, Clear Case.

Confidential, IL

Sr. Informatica Developer

Responsibilities:

• Interacted with Business Analysts for Requirement gathering, understanding the Requirements, Explanation of technical probabilities and Application flow.
• Developed ETL mappings, transformations using Informatica Power Center 9.5.1
• Extracted data from flat files, DB2 and loaded the data into Oracle staging using Informatica Power Center.
• Designed and created complex source to target mapping using various transformations inclusive of but not limited to Sorter, Aggregator, Joiner, Filter, Source Qualifier, Expression and Router Transformations.
• Extensively used Lookup Transformation and Update Strategy Transformation while working with Slowly Changing Dimensions (SCD) and also performed reading and loading high-volume Type 2 dimensions.
• Extensively used Informatica debugger to figure out the problems in mappings. Also involved in troubleshooting existing ETL bugs.
• Implemented Incremental loading of mappings using Mapping Variables and Parameter Files.
• Experienced in designing and developing Informatica IDQ environment.
• Worked with Informatica Data Quality (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, duplicate elimination and exception handling and monitoring capabilities of IDQ.
• Used Mapping Parameters and Mapping Variables based on business rules provided.
• Wrote PL/SQL Procedures for data extractions, transformation and loading.
• Assisted in Data Modeling and Dimensional Data Modeling.
• Involved in Performance Tuning by determining bottlenecks at various points like targets, sources, mappings, sessions or system. This led to better session performance.
• Scheduled workflow daily basis for incremental data loading.
• Designed and developed UNIX shell scripts as part of the ETL process to automate the data load processes to target.
• Involved in Unit Testing, User Acceptance Testing (UAT) to check whether the data loads into target are accurate, which was extracted from different source systems according to the user requirements.
• Maintained Version Control using Clear Case.
• Scheduling jobs using Autosys to automate the Informatica Sessions.
• Provided Production Support at the end of every release.

Environment: Informatica PowerCenter9.5.1, Informatica PowerExchange 9.5.1,IDQ 9.5.1, Teradata 14, UNIX Shell script, Toad, SQL *Loader, SQL, PL/SQL, Teradata14.

Confidential, San Francisco, CA

Informatica Developer

Responsibilities:

• Actively involved in gathering requirements from end users, involved in modifying various technical & functional specifications.
• Functional and Technical Specification documents creation and gathering approval from leadership
• Built mappings to load data from Siebel to Salesforce objects
• Designed data models to do one-time full load into salesforce and bridge the delta data from salesforce back to Siebel
• Performed detailed data qualify analysis by comparing record count and column values
• Agile Scrum/Sprint environment
• Configured email delivery system when records fail to get updated or inserted into salesforce as part of exception handling
• Sequenced the data load workflows to get all the parent child relationship data loaded without any data loss
• Modified mappings to go throughcipher cloud encryption and extensive testing of encrypted data on cloud
• Data extraction and transformation from salesforce to data warehouse systems
• Fixed various connection issues those raised during the development phase
• Troubleshooting and solutions for production issues.

Environment: Informatica PowerCenter 9.1.0/8.6, Informatica PowerExchange 9.1.0/8.6, Oracle 11g, Teradata 13, MS SQL SERVER 2000, SQL, PL/SQL, SQL*Loader, UNIX Shell Script.

Confidential, Huston, TX

Sr. Informatica Developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection.
• Worked with Informatica Data Quality 8.6 (IDQ) toolkit, Analysis, data cleansing, data matching, data conversion, exception handling, and reporting and monitoring capabilities of IDQ 8.6.
• Created mapping documents to outline data flow from sources to targets.
• 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.
• Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Developed mapping parameters and variables to support SQL override.
• Created Mapplets to use them in different mappings.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Used existing ETL standards to develop these mappings.
• Worked on different tasks in Workflows like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment, Timer and scheduling of the workflow.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Extensively used SQL* loader to load data from flat files to the database tables in Oracle.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• 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 PowerCenter 8.6, Informatica PowerExchange 8.6, Oracle 11g, Teradata 13, SQL, PL/SQL, TOAD, Shell Scripts, UNIX.

Confidential, Houston, Texas

Informatica Developer

Responsibilities:

• Extensively worked on Informatica Power Center tools- Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager and Informatica Power Exchange.
• Worked with Data modeler, according to changes in the model worked on changes in the Informatica.
• Imported the source definition into source analyzer from oracle and for DB2, VSAM files used Informatica power exchange in the source analyzer.
• Imported the Target definitions into Target Designer from oracle and for DB2, VSAM files used Informatica power exchange in the Target Designer.
• Working with Business Analyst, Translating Business requirements into Functional requirements.
• Developed and Tested new mappings. Created and configured the sessions for work flow.
• Created and maintained parameter files for workflows in the UNIX and CVS.
• Worked on Joiner, Aggregator, Update Strategy, Rank, Router, Lookup (static and Dynamic), Sequence Generator, Filter, Sorter, Source Qualifier.
• Implemented slowly changing dimensions - Type I, II &III in different mappings as per the requirements.
• Created connections for relational, Non-relational and applications in the workflow manager. Created mappings using Reusable Transformations.
• Migrating mappings, workflows and parameter files from development to production.
• Developed PL/SQL scripts line packages and store procedures for data updates.

Environment: Informatica PowerCenter 8.6, Oracle 11g, DB2 Mainframe, Flat files, UNIX, shell scripting, SQL Developer, Oracle 11g, Windows XP

Confidential, Michigan, IN

ETL Informatica Developer

Responsibilities:

• Extensively worked on Informatica Designer, Workflow Manager, and Workflow Monitor as a senior Informatica Developer.
• Extracted data stored in Oracle 11g, Oracle 10g and Oracle 9i and Flat files and loaded data into Oracle Data warehouse
• Developed several complex Mappings, Mapplets and Reusable Transformations to facilitate daily weekly and monthly loading of Data
• Extensively used transformations like Aggregator, Expression, Sorter, Sequence Generator, Joiner, Filter, Router, Rank, Look up and Update Strategy transformations to model various standardized business processes
• Used Informatica features to implement Type I, II changes in slowly changing dimension tables.Created Data Breakpoints and Error Breakpoints for debugging the mappings.
• Created Workflow, Worklet, Assignment, Decision, Event Wait and Raise and Email Task, scheduled Task and Workflow based on Client requirement
• Participated in reconciling data drawn from multiple systems across the company like Oracle 11g, Oracle 10g, flat files into Oracle data warehouse
• Involved in data Transformations between different Informatica folders and also Repositories along with DBA team.
• Generated Informatica Mappings to populate the data into dimension and Fact tables for data classifications to end developers.
• Experience using different transformations like Aggregator, Lookup (connected and unconnected), Filter, Expression, Router, Update Strategy and Sequence Generator for data transformations.
• Created and Configured Workflows, Work lets and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager.
• Developed reusable transformations to load data from various data sources to the DW.
• Fixing invalid Mappings, testing of Stored Procedures and Functions, Unit and Integration Testing of Informatica Sessions, Batches and Target Data.
• Scheduled Informatica sessions and workflows using Informatica Scheduler in Business process as Requested in SLA.
• Performed extensive debugging and performance tuning of mappings, sessions and workflows including partitioning, memory tuning and cache management.
• Created and maintained various project related documents like high level design documents etc.Created, executed and documented associated test cases.

Environment: Informatica PowerCenter 8.1(Informatica Designer, Workflow Manager, Workflow Monitor), Oracle 10g, Flat files, ODBC, Windows NT, UNIX, Shell Scripts, Toad 7.5,Apex explorer/loader, SQL.