PROFESSIONAL SUMMARY:

• Over 10 years’ experience in IT industries and 7+ years of Data Warehouse experience with domain knowledge of Finance/Banking, Insurance and Title Insurance / Real Estate Services domain.
• Extensive experience in ETL and Data Integration for developing ETL mappings and scripts using Informatica Power Center 9.5,8.6.1/8.6 using Designer, Repository Manager, Workflow Manager & Workflow Monitor. Exposure on Power Exchange functionality.
• Extensive experience in creating Transformations and Mappings using Informatica Designer to implement business rules and processing tasks using Workflow Manager to move data from Multiple Sources into Targets.
• Expertise using MS SQL Server 2008/2005/2000, oracle 11g/10g, DB 2 9.0/8.0/7.0, Teradata 12, Erwin 7.0/4.0/3.5, SQL, PL/SQL, SQL *Plus, SQL *Loader.
• Extensively used Teradata SQL Assistant and BTEQ to write SQL’s for ETL.
• Hands on experience on all phases of software development life cycle (SDLC) of Data warehousing, including requirement gathering from business users, analysis, design, creation of mapping documents, specification writing, development, testing, and implementation.
• Expertise in working with various transformations using Aggregator, Look Up, Update Strategy, Joiner, Filter, Sequence Generator, Normalizer, Sorter, Router, Java transformations in Informatica PowerCenter Designer.
• Extensive expertise in Debugging, Performance Tuning and Optimization of the Sessions and Mappings.
• Proficiency in data warehousing techniques for Data Cleansing, Slowly Changing Dimension Phenomenon, Surrogate Key assignment, Change Data Capture (CDC).
• Extensive Experience in integration of various RDBMS like Oracle, DB2, SQL server into staging area.
• Experienced in Multi - Terabyte environments, solid experience in coding using SQL, SQL * Plus, PL/SQL.
• Expertise in creating Stored Procedure/Functions, Triggers and Packages in Oracle and SQL Server 2005/2008.
• Expertise in Data Analysis, Data Design, Developing and Deployment for Data Integration for BI requirements.
• Profound knowledge of the principle of Data Warehouse using Fact tables, Dimensional Table, Star Schema Modeling and Snowflake Schema Modeling.
• Extensive Knowledge of Installation, Configuration and Maintenance of Informatica Power Center and other Informatica tools, on various OS platforms, Windows2000, Windows2003, Windows XP, Linux/Unix.
• Experience in Administrative activities such as creating folders, assigning security permissions to users and creating repositories, setting up groups/users permissions in Informatica Repository Manager and admin console.
• Ability to analyze source data for potential data quality issues and addressing these issues in ETL procedures.
• Exposure knowledge of Informatica Migration and Upgrade.
• Experience working with SDLC and implementing, Waterfall and Agile methodologies.
• Experience working with Informatica in UNIX and LINUX environments.
• Involved on report creation using OLAP data source with strong knowledge in OLAP universe.
• Coordinate ETL and database development work with developers and conduct code reviews.
• Excellent oral/written/interpersonal communication skills, quick learner, willing to adapt to the team/organizational environment.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.5/8.6, Power Exchange, Visio Architect for Designer.

Database: MS SQL Server 2005/ 2008, Oracle 11g/10g, DB2, MYSQL, Teradata

Modelling Tools: Erwin, MS Visio Database Tools, Utilities DB2 Visualizer, SQL Squirrel, Sql developer, BTEQ, Fast Load, MLOAD, FastExport, SQL*Loader, Teradata SQL assistant, SQL*Loader, Toad

Languages: COBOL, JCL

Operating Systems: Windows NT/2000/XP/2007, UNIX, LINUX

Packages: MS-Office Suite

PROFESSIONAL EXPERIENCE:

Confidential, SAN RAMON, CA

ETL Developer

Responsibilities:

• Worked closely with Business Analysis team, Reverse Engineering Team, discussed and gathered the Analytics requirements and created the Business Model using Star schemas.
• Worked on designing and coding the complete ETL process using Informatica for various transactions and loading data from different sources like Flat Files and Relational Database.
• Created numerous Mappings and Mapplets using Transformations like Filters, Aggregator, Lookups, Expression, Sequence generator, Sorter, Joiner and Update Strategy.
• Implemented slowly changing dimensions type1 and Type 2 using date
• Created Mapplets and reusable transformations to be re-used during the development life cycle.
• Used Parameter files to define values for parameter and variable used in the mappings and sessions.
• Create parameter and variables and called them whenever required.
• Dropping and recreating Indexes on the database Target table using pre-sql and post-sql techniques while loading huge tables.
• Created session and Worklets in Workflow manager having event tasks like e-mails.
• Worked on performance tuning by finding out the bottlenecks in various mappings.
• Unit testing self and other mappings before deploying the code for QA testing by creating scenarios based on business requirement.
• Involved in performance tuning of the mappings and SQL statements, worked on Query Optimization.
• Handled UNIX operating system tasks by generating Pre and Post-Session UNIX Shell Scripts.
• Involved in creating Control M Jobs which call Informatica Workflows, which run in the supply chain environment.
• Responsible for Issue Resolutions using Session Logs and Workflow Logs.
• Responsible for determining Incremental Loading mappings using Mapping Variables and Parameter Files.
• Developed shell scripts for running batch jobs and scheduling them.
• Called stored procedures in PL/SQL for certain key business requirements.
• Coordinated the UA testing with business users.
• Involved in troubleshooting data quality and integrity issues.
• Involved in Unit and Integration Testing of the Data Warehouse.
• Performed the data validations and control checks to ensure the data integrity and consistency.
• Involved in performance tuning of the mappings and SQL statements, worked on Query Optimization.
• Developed PL/SQL Procedures, Functions, Packages, SQL scripts in Oracle 9i/11g.
• Wrote UNIX shell scripts to prepress data using PMCMD command.
• Involved during User Testing and performed Unit testing.
• Writing documentation to describe program development, logic, coding, testing, changes and corrections.
• Involved in Scrum meeting on day to day activities and Task

Confidential

ETL Developer( Senior Software Engineer)

Responsibilities:

• Worked closely with Business Analysis team, Reverse Engineering Team, discussed and gathered the Analytics requirements and created the Business Model using Star schemas.
• Worked on designing and coding the complete ETL process using Informatica for various transactions and loading data from different sources like Flat Files and Relational Database.
• Created numerous Mappings and Mapplets using Transformations like Filters, Aggregator, Lookups, Expression, Sequence generator, Sorter, Joiner and Update Strategy.
• Implemented slowly changing dimensions type1 and Type 2 using date
• Created Mapplets and reusable transformations to be re-used during the development life cycle.
• Used Parameter files to define values for parameter and variable used in the mappings and sessions.
• Create parameter and variables and called them whenever required.
• Dropping and recreating Indexes on the database Target table using pre-sql and post-sql techniques while loading huge tables.
• Created session and Worklets in Workflow manager having event tasks like e-mails.
• Worked on performance tuning by finding out the bottlenecks in various mappings.
• Unit testing self and other mappings before deploying the code for QA testing by creating scenarios based on business requirement.
• Involved in performance tuning of the mappings and SQL statements, worked on Query Optimization.
• Handled UNIX operating system tasks by generating Pre and Post-Session UNIX Shell Scripts.
• Involved in creating Control M Jobs which call Informatica Workflows, which run in the supply chain environment.
• Responsible for Issue Resolutions using Session Logs and Workflow Logs.
• Responsible for determining Incremental Loading mappings using Mapping Variables and Parameter Files.
• Developed shell scripts for running batch jobs and scheduling them.
• Called stored procedures in PL/SQL for certain key business requirements.
• Coordinated the UA testing with business users.
• Involved in troubleshooting data quality and integrity issues.
• Involved in Unit and Integration Testing of the Data Warehouse.
• Performed the data validations and control checks to ensure the data integrity and consistency.
• Involved in performance tuning of the mappings and SQL statements, worked on Query Optimization.
• Developed PL/SQL Procedures, Functions, Packages, SQL scripts in Oracle 9i/11g.
• Wrote UNIX shell scripts to prepress data using PMCMD command.
• Involved during User Testing and performed Unit testing.
• Writing documentation to describe program development, logic, coding, testing, changes and corrections.
• Involved in Scrum meeting on day to day activities and Task

Environment: Informatica Power Center 9.x/8.6.1(Repository Manager, Designer, Source Analyzer, Workflow Manager, Workflow Monitor, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer and Task Developer,, Oracle 11g, Teradata, Flat Files, XML, CSV Files, Unix Shell Scripts, SQL Developer, Windows XP.

Confidential

ETL Developer (Software Engineer)

Responsibilities:

• Worked closely with Business Analysis team, discussed and gathered the Analytics requirements and created the Business Model using Star schemas.
• Worked on designing and coding the complete ETL process using Informatica for various transactions and loading data from different sources like Flat Files and Relational Database.
• Created numerous Mappings and Mapplets using Transformations like Filters, Aggregator, Lookups, Expression, Sequence generator, Sorter, Joiner and Update Strategy.
• Implemented slowly changing dimensions type1 and Type 2 using date
• Created Mapplets and reusable transformations to be re-used during the development life cycle.
• Used Parameter files to define values for parameter and variable used in the mappings and sessions.
• Create parameter and variables and called them whenever required.
• Dropping and recreating Indexes on the database Target table using pre-sql and post-sql techniques while loading huge tables.
• Created session and Worklets in Workflow manager having event tasks like e-mails.
• Worked on performance tuning by finding out the bottlenecks in various mappings.
• Unit testing self and other mappings before deploying the code for QA testing by creating scenarios based on business requirement.
• Involved in performance tuning of the mappings and SQL statements, worked on Query Optimization.
• Developed Procedures, Functions in Sql Server 2005/2008.
• Handled UNIX operating system tasks by generating Pre and Post-Session UNIX Shell Scripts.
• Involved in creating Crontabs Jobs which call Informatica Workflows, which run in the chain environment.
• Played a key role in day to day production support of the Informatica batch.
• Responsible for Production Support and Issue Resolutions using Session Logs and Workflow Logs.
• Responsible for determining Incremental Loading mappings using Mapping Variables and Parameter Files.
• Developed shell scripts for running batch jobs and scheduling them.
• Coordinated the UA testing with business users.
• Worked with Informatica 8.6.1 (IDQ) toolkit, Analysis, data cleaning, data matching, data conversion, exception handling, and monitoring capabilities of IDQ 8.6.1.
• Worked on Standard and label transformation in IDQ.
• Involved in production support and troubleshooting data quality and integrity issues.
• Involved in Unit and Integration Testing of the Data Warehouse.
• Performed the data validations and control checks to ensure the data integrity and consistency.
• Involved in performance tuning of the mappings and SQL statements, worked on Query Optimization.
• Developed PL/SQL Procedures, Functions, Packages, SQL scripts in Oracle 9i/10g.
• Wrote UNIX shell scripts to prepress data using PMCMD command.
• Involved during User Testing and performed Unit testing.
• Writing documentation to describe program development, logic, coding, testing, changes and corrections.

Environment: Informatica Power Centre 8.6.1(Repository Manager, Designer, Source Analyzer, Workflow Manager, Workflow Monitor, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer and Task Developer, IDQ Data Quality, SQL Server 2005/2008, Flat Files, CSV Files, Cobol Files, Unix Shell Scripts.