SUMMARY:

• Around 9 years of experience in software design, development, testing and support along with Analysis and Implementation of Data warehouse - Business Intelligence applications in various domains like Banking, Insurance and Health Care.
• Expertise in ETL (Extract Transform Load) using Informatica PowerCenter 8x/9x.
• Extensively worked on Informatica PowerCenter Transformations such as Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, Sequence Generator and SQL.
• Expertise in using RDBMS like Oracle 11g/12c, DB2 9.7 LUW and expertise in PL/SQL and writing Stored Procedures, Functions etc.
• Good Experience in UNIX shell scripting and job scheduling tools like Autosys.
• Extensive Data modelling experience (mainly Dimensional modelling) in Star Schema/Snowflake schema design, Fact and Dimensions tables, Physical and logical data modelling using Erwin.
• Good knowledge on TERADATA and Informatica IDQ.
• Involved in the defect analysis for SIT, UAT and PROD environments.
• Experience in identifying performance bottlenecks and tuning of Informatica Sources, Targets, Mappings, Transformations and Sessions for better performance and efficiency.
• Proven expertise in Production/Application Support of complex real time, business critical applications on Informatica, PL/SQL and UNIX.
• Experience in leading technical, support teams and balancing responsibilities of multiple projects.
• Extensive experience in Onsite / Offshore model projects and worked as Onsite lead and Offshore lead as well and handled a team of size as large as 8 members.
• Excellent communication skills and good inter-personal skills and flexible as per project needs.

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 8.x/9.x

Programming Languages: PL/SQL, UNIX Shell Scripting, Core Java

Database: Oracle 11g/12c, DB2 9.7 LUW, Teradata 14, Greenplum

Operating System: Windows 7, Windows XP, Windows 2003/2000 Server, UNIX, Z/OS

Data Warehousing (BI): Data Marts, OLTP, OLAP, Normalization, Dimensional Modelling, Fact, Dimension, Star schema, Snowflake schema, Galaxy Schema, Slowly Changing Dimensions

Scheduling Tools: Autosys, Tivoli

SQL Editors/Other Tools: TOAD, DBArtisian, Sqldeveloper, SQL Assistant Putty, GoldenGate, IBM ClearCase, ClearQuest, Perforce, Putty, HP Quality Center,ALM, Sharepoint, Jira, ServiceNow

Reporting Tools: Qlikview, OBIEE

PROFESSIONAL EXPERIENCE:

Confidential, Fairfax, VA

Senior Informatica Developer

Responsibilities:

• Mainly involved in ETL Developing using Informatica PC 9.6.1 and desgined and implemented Data recovery in case of Informatica workflow failures.
• Participated in the walkthroughs of the data models, ETL specifications, identification of dimensional attributes, Facts and Star Schema to fulfil requirements
• Designed ODS layer to load data from transactional db and developed data model using ERWIN.
• Developed transformation logic and designed various complex mappings by using the Designer and Developed mappings in order to load tables from transactional db to ODS.
• Worked with the Lookup, Aggregator, Expression, Router, Filter, Update Strategy, Stored Procedure Transformation, Joiner.
• Used Workflow Manager for Workflow and Session Management, database connection management and scheduling of jobs to be run in the batch process.
• Done unit testing and developed reconcile jobs.

Environment: Informatica PowerCenter 9.6.1, Oracle 11g/12c, Erwin 7.3.5, UNIX, Cognos

Confidential, Hoboken, NJ

Senior Informatica Developer

Responsibilities:

• Implemented BIAPPS 7.9.6.4 Human Resource Analytics for PeopleSoft 9.1 source system.
• Extensively involved in creating client specific custom reports pointing to Taleo, PeopleSoft HCM & custom CSV files.
• Extensively worked with Incremental Loading using Parameter Files, Mapping Variables, and Mapping Parameters.
• Expertise with both connected and Un-Connected Lookups, Reusable Transformation, Extensively worked with Look up Caches like Shared Cache, Persistent Cache, Static Cache, and Dynamic Cache to improve the performance of the lookup transformations, extensively used SQL Override function in Source Qualifier Transformation.
• Created custom mappings using different Transformations like Source Qualifier, filter, Router, Aggregator, Lookup, Expression, Sequence Generator, and Update Strategy to store the data in target table.
• Involved in designing custom ETL mapping to extract Recruitment information from Taleo and Workforce, Compensation & Performance Management sourcing from PeopleSoft HCM.
• Worked closely with Users, Developers and Administrators to resolve ongoing Production Problems by reviewing design changes made to production systems.

Environment: Informatica PowerCenter 9.6.1, Oracle 11g, UNIX, OBIEE 11g, Peoplesoft 9.1

Confidential

Informatica Developer

Responsibilities:

• Mainly involved in ETL Developing using DB2 and Informatica.
• Created stored procedures to populate tables.
• Did performance tuning to existing stored procedures and mappings.
• Used DB partitioning like Hash partinoing and data partitioning techniques like MDC and Range Partitiong for better performance.
• Generated XML files using Informatica for downstream systems.
• Worked with analysts, to translating business requirements into technical user specifications, including data, process and interface specifications.
• Used most of the transformations such as the Aggregators, Filters, Routers, Sequence Generator, Update Strategy, Rank, Expression and lookups (connected and unconnected) while transforming the data according to the business logic.
• Helped in creating reports/dashboards using Qlikview.
• Created and scheduled jobs through Autosys scheduling tool.
• Prepared High level and Low level design documents and did peer reviews.
• Developed reconciliation jobs which compares data between source and target.

Environment: Informatica PowerCenter 9x/8x, DB2 LUW 9.7, ERWIN 7.2, UNIX, Qlikview, Autosys

Confidential

Informatica Developer

Responsibilities:

• Extensively used ETL processes to load data from flat files into the target database by applying business logic on transformation mapping for inserting and updating records when loaded.
• Developed Informatica mappings by usage of Aggregator, SQL Overrides in Lookup, Dynamic Lookup, Source Qualifier and data flow management into multiple targets using Router transformations.
• Created Sessions & Workflows to run the mappings using Workflow Manager
• Created Stored Procedures & Functions for data transformation purpose.
• Involved in gathering requirements and created design documents and mapping documents.
• Performed data validation tests using complex SQL statements.
• Worked on Informatica PowerCenter tools - Designer, Repository Manager, Workflow Manager and Workflow Monitor.

Environment: Informatica PowerCenter 9.0.1, SQL Developer, Toad, Oracle database 11g, Unix, xml.

Confidential

Informatica Developer

Responsibilities:

• Worked on Informatica tools Source Analyzer, Warehouse designer, Mapping Designer and Transformation Developer.
• Developed Informatica mappings and also tuned them for better performance.
• Extensively used the Expression, Aggregator, Filter, Joiner, Sorter, Rank, Union, Router, Lookup transformations
• Extensively used ETL to load data from flat files.
• Designed and Deployed UNIX Shell Scripts.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the Workflow processes using Unix Shell Scripts.
• Generated SQL Loader scripts and Shell scripts for automated daily load processes.

Environment: Informatica PowerCenter 8.6.1, Oracle11g, XML, XSLT, Stylus Studio, Java, Ecllipse