SUMMARY:

• Certified Informatica Developer with 8+years of experience in requirement analysis, development testing, support, performance tuning, deploying the code to QA and Production environments. Experienced in Health insurance, Finance, Pharmaceutical and Banking industries.
• Actively looking for a position as an Informatica Developer in a fast growth company.
• Expertise in Software development life cycle, design and implementing the solutions for Data warehouses and Data marts using Extraction, Transformation and loading (ETL) mechanism with the Star schema and Snowflake schema.
• Experienced in ETL processes utilizing Informatica Power center tools such as Repository Manager Designer, Workflow Manager and Workflow Monitor to design data conversions from a variety of relational, XML and flat file source systems to data warehouse/data marts.
• Experience in implementing the business rules by creating transformations (Expression, Aggregate, Source qualifier, connected and Unconnected Lookup, Router, Rank, Update Strategy, Normalizer) also developing Maplet, worklets and Mappings.
• Experience in Performance tuning mappings, SQL Optimization, identifying and resolving performance bottlenecks at various levels like sources, targets, mappings, and sessions.
• Experience in using Informatica tools, SQL Scripts, Stored Procedures and execution of test plans for loading data successfully into the target Systems.
• Experience in developing SQL and PL/SQL scripts for relational databases such as Oracle, Microsoft SQL Server, IBM DB2 Experience in UNIX programming and shell scripting for Informatica pre & post session operations and database administration activities.
• Worked on Change data capture/control on insert, update operations.
• Research & development of Informatica cloud version with the existing jobs.
• Extensive interaction with business users, IT Managers in analyzing business requirements and translating requirements into functional and technical specifications.
• 24x7 Production Support for business continuity.
• Knowledge of FACETS healthcare application and HIPAA X12 274 file format

TECHNICAL SKILLS:

ETL&BI Tools: Informatica Power center 9.6/ 9.5.1/9.1.0 , SSIS and Cognos.

Data Bases: SQL Server 2008, DB2, Oracle 11gR2/10g/9i, TeradataV2R5, Netezza.

Development Tools: Toad, SQL Developer, SSMS, IBM Data Studio

Operating Systems: Windows 2007/2003, Windows XP, UNIX, Mainframe

Programming/Languages: SQL, PL/SQL, T - SQL, UNIX shell scripting, Perl Scripting

Scheduling Tools: Control M, Tidal and Autosys.

Methodologies: Data Modeling Logical/Physical/Dimensional, ER modeling and Dimensional modeling, Star/Snowflake, ETL, OLAP, Complete software development life cycle.

PROFESSIONAL EXPERIENCE:

Confidential, Norfolk, Virginia

Senior Informatica/SQL Developer

Responsibilities:

• Worked with Business in regards to the requirements, understanding them thoroughly for the complete project outcome.
• Analyzed the business requirements, technical specification and physical data models for ETL mapping and process flow.
• Created Workflows, tasks, database connections, FTP connections using workflow manager.
• Expertise in using different tasks (Session, Assignment, Command, Decision, Email, Event-Raise, Event- Wait, Control)
• Co-ordination with Architects, advisors, managers, DBA’s, Informatica administrator’s and other developers during project life cycle.
• Reviewing the code developed by team developers and providing the inputs on fixes.
• Prepare the Design documents and provide the test data characteristics.

Environment: s: Informatica Power Center 9.5.1., SQL Server, IBM DB2 on Mainframes, SSIS, SQL, PL-SQL, T-SQL, TIDAL for scheduling and JIRA for defect/issue tracking.

Confidential, Westerville, Ohio

Senior Informatica Developer/ Production Support

Responsibilities:

• Responsible for design and development of rating data mart for financial Data Warehouse.
• Responsible for the design, development and implementation of dynamic SSIS packages for ETL (extract, transform, and load) development following company standards and conventions
• Preparing Functional Specifications, System Architecture/Design, Implementation Strategy, Test Plan & Test Cases.
• Implemented and documented all the best practices used for the data warehouse.
• Improving the performance of the ETL by indexing and caching.
• Created Workflows, tasks, database connections, FTP connections using workflow manager.
• Responsible for identifying bugs in existing mappings by analyzing data flow, evaluating transformations and fixing bugs.
• Developed ETL processes using MS SQL and SSIS.
• Used third party scheduling tool TIDAL for scheduling the jobs.

Environment: s: Informatica Power Center 9/1.0, Oracle, SQL Server, UNIX, SQL, PL-SQL, TIDAL for scheduling (file watcher) and HP quality center for issue tracking.

Confidential, Herndon, VA

Senior Informatica Developer

Responsibilities:

• Involved in design, development and maintenance of database for Data warehouse project.
• Involved in Business Users Meetings to understand their requirements.
• Designed, Developed and Supported Extraction, Transformation and Load Process (ETL) for data migration with Informatica 8.x
• Developed various mappings using Mapping Designer and worked with Aggregator, Lookup, Filter, Router, Joiner, Source Qualifier, Expression, Stored Procedure, Sorter and Sequence Generator transformations.
• Wrote PL/SQL scripts and T-SQL scripts for the complex requirement for the stored procedures.
• Created complex mappings which involved Slowly Changing Dimensions, implementation of Business Logic and capturing the deleted records in the source systems.
• Worked extensively with the connected lookup Transformations using dynamic cache.
• Wrote UNIX scripts for the business needs.

Environment: Informatica Power Center 9.5.1/9/1.0, Oracle, SQL Server, UNIX, SQL, PL-SQL, T-SQL and TIDAL for scheduling.

Confidential, Indianapolis, IN

Informatica Developer

Responsibilities:

• Prepared a detailed Technical Design Document after analyzing the Functional Specifications and the Architectural Diagram. The Technical Design Document captured all functional and technical requirements.
• Worked with different sources like Oracle, Teradata, SQL Server, DB2 UDB and flat files.
• Worked on Complex SQL queries and
• Developed numerous Complex Informatica Mappings, Mapplets and reusable Transformations.
• Designed and created complex source to target mapping using various transformations inclusive of but not limited to Aggregator, Joiner, Filter, Source Qualifier, Expression and Router Transformations.
• Extensively used Lookup Transformation and Update Strategy Transformation while working with Slowly Changing Dimensions.
• Developed Workflows with various Tasks and Parameter files.
• Expertise in using different tasks (Session, Assignment, Command, Decision, Email, Event-Raise, Event- Wait, Control).
• Defined Target Load Plan and Constraint based loading for loading data appropriately into multiple Target Tables.
• Performed Code review to ensure that ETL development was done according to the company’s ETL standard and that ETL best practices were followed.

Environment: Informatica Power Center 8.6.0/9.1, Oracle 10g, SQL Server 2005, Netezza 4.5, Teradata V2R5, Toad, PL/SQL, BTEQ, Fast Export, Fast load, Multi load, Linux, and Windows 2000 / XP, Autosys for scheduling.

Confidential, Minnesota

Informatica Developer

Responsibilities:

• Implemented the business rules by creating transformations (Expression, Aggregate, Source qualifier, connected and Unconnected Lookup, Router, Rank, Update Strategy) and developing Maplet and Mappings.
• Developed numerous Complex Informatica Mappings, Mapplets and reusable Transformations.
• Developed Lookup Transformation and Update Strategy Transformation while working with Slowly Changing Dimensions.
• Developed Workflows with various Tasks and Parameter files.
• Created different tasks (Session, Assignment, Command, Decision, Email, Event-Raise, Event- Wait, and Control).
• Performance tuning, identifying and resolving performance bottlenecks at various levels like sources, targets, mappings, and sessions.
• Experience in using Informatica tools, SQL Scripts, Stored Procedures and execution of test plans for loading data successfully into the target Systems.
• Experience in developing SQL and PL/SQL scripts for relational databases such as Oracle, Microsoft SQL Server, IBM DB2, Netezza and Teradata.
• Experience in UNIX programming and shell scripting for Informatica pre & post session operations and database administration activities.

Environment: Informatica Power Center 8.1.1/8.6.0 , Oracle 10g, SQL Server 2005, Netezza, Teradata, Toad, PL/SQL, Linux and Windows 2000 / XP, control-M for scheduling