PROFESSIONAL SUMMARY:

• More than 9+ years of proven experience in PL/SQL that includes Cursors, Ref - cursors, Bulking techniques, Procedures, Functions and Packages, Oracle Supplied Packages, Collections, Partitioned Tables, Triggers, Materialized Views, Table Indexing, Index Organized Tables (IOT), SQL*Loader, ETL Tools etc.
• Experience in diversified fields in Data Warehousing. Worked on various projects involving Data warehousing using Informatica Power Center 7.1 and PowerCenter 9.1/8.1.6 (Workflow Manager, Workflow Monitor, Server Manager, Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer & Transformation Developer).
• 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.
• Good Knowledge on applying rules and policies using ILM (Information Life Cycle Management) workbench for Data Masking Transformation and loading into targets.
• Proficient in Teradata Tools and Utilities such as Teradata SQL Assistant, Import/Export.
• Expertise in designing and developing mappings from varied transformation logic using filter, expression, rank, router, aggregator, joiner, lookup, and update strategy.
• ETL, Data analysis for ODS, online transactional processing (OLTP) and Data Warehouse / Business Intelligence (BI) - logical/physical, relational and multi-dimensional modeling (Star Schema, Snowflake Schema).
• Design and development of multi-layer Web Based information systems using Web Services Including Java and JSP Strong experience in Dimensional Modeling using Star and Snow Flake Schema, Identifying Facts and Dimensions,
• Good experience in utilities such as Import/Export, SQL*Loader and SQL*PLUS.
• Experience in system analysis, design, development and implementation of large to medium scale business applications using Oracle/UNIX technologies in Client-Server and Internet environments.
• Created and maintained Database Objects like Tables, Views, Indexes, Constraints, Sequence, Synonyms, Database link, Roles and privileges.
• Extensive experience in writing data conversion scripts for migrating legacy data into Oracle Applications using SQL*Loader and PL/SQL.
• Extensive experience in creating new reports and customization of existing Reports, Forms and PL/SQL Procedures
• Maintained summaries or aggregates on data using Materialized Views.
• Strong analytical and problem solving skills with the ability to quickly adapt to new environments and learn new technologies.
• Demonstrated the ability to work as Tech Leadand Developer.
• Experience as DWH TeamLeadand SuccessfullyLeadmultiple DWH projects. Good experience in Leading both onsite and offshore teams.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.x/8.x/7.x, SQL*Plus, Oracle Warehouse Builder, Data Stage. Informatica Power Exchange, Informatica Power Mart, Informatica Data Quality/Informatica Developer, Informatica Data Transformation (B2B), Oracle Data Integrator, OLAP, OLTP, Star schema, Snowflake Schema.

Data Modeling: Dimensional Data Modeling, Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical / Logical Data Modeling, Erwin 4/3

Databases: Oracle 8i/9i/10g/11g, SQL Server, DB2, MS Access, Teradata.

PROFESSIONAL EXPERIENCE:

Confidential, Weehawken, NJ

Sr Informatica Developer

Responsibilities:

• Attended multiple requirement gathering sessions with source system teams and business users.
• Designed data structures for storage and programmed logic for data flow between the various stages of toll transaction processing.
• Maintained and tracked weekly status call with team and finished the deliveries within given timeline.
• Experience in working with Slowly Changing Dimensions and setting up Change Data Capture (CDC) mechanisms.
• Extensively Implemented SCD TYPE 2 Mappings for CDC (Change data capture) in EDW.
• Developed mappings to extract data from SQL Server, Oracle, Flat files, XML files, and loaded into Data warehouse using the Mapping Designer.

Environment: Informatica Power Center 9.6/9.1, Informatica PWX CDC, Oracle 11g, Flat Files, Teradata, DB2UDB.

Confidential, Mooresville, NC

Sr Informatica Developer

Responsibilities:

• Work closely with the Solution Architect, Data Modeler and Business Users.
• Analyzing the business requirements and providing expert knowledge and solutions on Data warehousing in turn ensuring delivery of business needs in a timely cost-effective manner.
• Assist in developing project plans, assigning the appropriate technical resources and cost estimations.
• Evaluate and design data collection, data staging, data movement, analytics delivery, data quality and archiving strategies
• Lead and guide the ETL developers in data profiling, source-target mappings, ETL development, SQL tunings and optimization, testing and implementation
• Provides reviews of deliverables and identifies gaps/areas for improvement
• Provides/reviews detailed technical specifications and ETL documentations required in each phase of the SDLC.
• Perform POC activities to capture real-time data using Informatica PWX CDC.

Environment: Informatica Power Center 9.6/9.1, Informatica PWX CDC, Oracle 11g, Flat Files, Teradata, DB2UDB.

Confidential, Boca Raton, FL

Sr Informatica Developer

Responsibilities:

• Understood the Business point of view to implement coding using Informatica Power Center 9.6/9.1
• Extensively used Informatica Power Center 9.6/9.1 to create and manipulate source definitions, target definitions, mappings, mapplets, transformations, re-usable transformations, etc.
• Involved in design and development of complex ETL coding in an optimized manner.
• Have created / developed different types of profiles like Column level profiling, Summary profiles, drill down profiles, Score cards, reports etc using IDE
• Have created Match, and Merge rules, developed address validations etc and developed address validations to countries like US, and also developed reusable error handling rules using IDQ.
• Implemented data warehousing techniques for Data cleansing, Slowly Changing Dimension Phenomenon’s (SCD) and Change Data Capture (CDC).
• Worked with Type-I, Type-II and Type-III dimensions and Data warehousing Change Data Capture (CDC).
• Redesigned some of the existing mappings in the system to meet new functionality.
• Optimized performance by tuning the Informatica ETL code as well as SQL
• Based on the requirements, used various transformation like Source Qualifier, Normalizer, Expression, Filter, Router, Update Strategy, Sorter, XML, Lookup, Aggregator, Joiner and Stored Procedure transformations in the mapping.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse.
• Developed Slowly Changing Dimensions for Type 1 SCD and Type 2 SCD.
• Written Queries, procedures, created Indexes, primary keys and data bases testing.
• Defects were tracked, reviewed and analyzed.
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Experience in creating data maps using Power Exchange Navigator version 5.2.2
• Created mainframe data maps using Power Exchange Navigator for the sources and targets.
• Used Source Analyzer and Warehouse designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Involved in performance tuning of mappings, transformations and (workflow) sessions to optimize session performance.
• Implemented Error Rejection process to load bad/invalid records into a separate reject table.
• Used Informatica debugging techniques to debug the mappings and used session log files and bad files to trace errors occurred while loading.
• Developed workflow tasks like reusable Email, Event wait, Timer, Command and Decision.
• Created and scheduled sessions, jobs based on demand, run on time and run only once using Workflow Manager.
• Created parameter files to Dev, Test and Prod environments.
• Created Perl Scripts and called in Pre session and Post session commands.
• Involved in various testing activities like database testing, unit testing, system testing, performance testing and was also responsible for maintaining of testing metrics, defect tracking.
• Actively participated in data base testing like checking the constraints, correctness of the data, stored procedures, field size validation, etc
• Identified and debugged the errors before deploying and worked on migration of the maps and workflows from development to UAT and from UAT to Production.

Environment: Informatica Power Center 9.6/9.1, Oracle 11g, Flat Files, TOAD, Teradata, Autosys, Perl Scripting, Windows XP, UNIX.

Confidential, Boston, MA

Sr Informatica Developer

Responsibilities:

• Attended multiple requirement gathering sessions with source system teams and business users.
• Designed data structures for storage and programmed logic for data flow between the various stages of toll transaction processing.
• Maintained and tracked weekly status call with team and finished the deliveries within given timeline.
• Experience in working with Slowly Changing Dimensions and setting up Change Data Capture (CDC) mechanisms.
• Extensively Implemented SCD TYPE 2 Mappings for CDC (Change data capture) in EDW.
• Developed mappings to extract data from SQL Server, Oracle, Flat files, XML files, and loaded into Data warehouse using the Mapping Designer.
• Used Source Analyzer and Warehouse Designer to import the source and target database schemas, and the Mapping Designer to map the sources to the target.
• Created and modified COBOL copybook to connect source data using Power Exchange Navigator.
• Used Power Exchange Data Change option (CDC) to capture modified records.
• Used Informatica Designer to create complex mappings using different transformations like Filter, Router, Connected & Unconnected lookups, Stored Procedure, Joiner, Update Strategy, Expressions and Aggregator transformations to pipeline data to Data Warehouse.
• Developed Slowly Changing Dimensions for Type 1 SCD and Type 2 SCD.
• Developed various Stored Procedures, Functions, Packages and Materialized views for ETL needs.
• Developed unit test plans for each scenario and programmed for data validation and proper error handling to manage the transactions without any data loopholes.
• Responsible for tuning the Informatica Mappings and Sessions for optimum performance.
• Enhancing the system with change requests and fault fixes delivery.
• Responsible for loading the flat files into Oracle database by using SQL* Loader and Informatica.
• Database performance by optimizing back end queries, Pl/Sql tuning and implementing performance improvements by analyzing indexes, table partition, parallelism etc
• Documentation of all changes made to enhance the code for new requirements.
• Used external tables to manipulate data obtained on monthly basis for vehicle information before loading them into the tables.
• Created different SCD-II mappings using changed data capture (CDC) processes.
• Utilized Quest tool (Toad 8.0) for database monitoring and tuning.
• Involved in writing complex report SQL queries, oracle forms and oracle reports solutions.
• Involved in post production support activities.

Environment: Informatica 8.6, Erwin 7.1, Oracle 11g, Teradata, PL/SQL developer, SQL*PLUS, SQL, SQL*Loader, Toad, ER-Studio, UNIX, CVS, HTML, XML

Confidential, Burlington, VT

Sr.Informatica Developer

Responsibilities:

• Logical and Physical data modeling was done using Erwin for data warehouse database in STAR SCHEMA
• Using Informatica PowerCenter Designer analyzed the source data to Extract & Transform from various source systems (oracle 10g, DB2, SQL server and flat files) by incorporating business rules using different objects and functions that the tool supports.
• Using Informatica PowerCenter created mappings and mapplets to transform the data according to the business rules.
• Used various transformations like Source Qualifier, Joiner, Lookup, Sql, router, Filter, Expression and Update Strategy.
• Implemented slowly changing dimensions (SCD) for some of the Tables as per user requirement.
• Developed Stored Procedures and used them in Stored Procedure transformation for data processing and have used data migration tools
• Documented Informatica mappings in Excel spread sheet.
• Tuned the Informatica mappings for optimal load performance.
• Have used BTEQ, FEXP, FLOAD, MLOAD Teradata utilities to export and load data to/from Flat files.
• Analyzed, identified, fixed bad data and imported data fromSales Force - CRM to Oracle. Upstream data integration and migration processes in predefined schemas.
• Created and Configured Workflows and Sessions to transport the data to target warehouse Oracle tables using Informatica Workflow Manager. Informatica Web-services and web-portal applications.
• This role carries primary responsibility for problem determination and resolution for each SAP application system database server and application server.
• Worked along with UNIX team for writing UNIX shell scripts to customize the server scheduling jobs.
• Constantly interacted with business users to discuss requirements.

Environment: Informatica PowerCenter 8.1, Oracle 10g, SQL Server 2008, MS Access 2010, SQL*Loader, UNIX, Winscp, Informatica Metadata Manager, Putty, SQL, PL/SQL, Autosys 4.5

Confidential, Denver, CO

Informatica Developer

Responsibilities:

• Data Modeler for the Billing system for Wireless Data mart. This system takes care of existing Qwest customers only.
• Data Analyst- for analyzing the data for integrity across environments. Maintain Entity Relationships of data models.
• Data Lead- migration of reference data to Production environment from Dev. Ensuring that only valid data are moved across environments through Release Notes.
• Extracted data from source systems, transformed as per the business rules specified in the ETL design
• Loading the data from various data sources (Oracle/DB2 UDB) into data marts for the Informatica data integration.
• Worked with static and dynamic caches for the better throughput of sessions containing Rank, Lookup, Joiner and aggregator transformations.
• Developed mappings to load data from Oracle and DB2 using different transformations like Source Qualifier, Expression, Look up, Aggregate, Update Strategy, Joiner, Sorter, xml and Filter into staging area/target tables.
• Data validation (quality check) for source data (including flat files, csv files, and relational tables) are carried before loading into staging tables/datamart. Invalid data are logged into Error db for business users to analyze. Erred source data are posted into the datamart through a separate mapping once data resolved.
• Developed ETL and source to target mappings. Created Several Informatica Mappings to populate the data into dimensions and fact tables.
• Fixed invalid Mapping's, tested Stored Procedures and Functions, Unit Testing of Informatica Sessions, Workflows
• Database administration activities like creation of tables, defining index etc. for reference data table changes.
• Reference Data Migration from development to SIT and to production.
• Project management, managing releases and communicating with both internal and external stake holders

Environment: Informatica Power Center 7.6, Erwin Data Modeler 4.5, TOAD 9.7.2, Control-M, Windows XP, HP UNIX, Oracle 10G

Confidential

PL/SQL Developer

Responsibilities:

• Requirements gathering from users designing the database. Functional specs review and created technical specs documents.
• Created Platform independent schema structure so that the product data can be implemented in any database.
• Used Internationalization and Localization techniques in designing data structure so that it can be adapted to various languages and regions without engineering changes.
• Developing Oracle PL/SQL stored procedures, Functions, Packages, SQL scripts to facilitate the functionality for various modules.
• Developed Ab Initio graphs to manipulate the logs and load the data into the Oracle databases.
• Developed re-usable graphs for data extraction and scrubbing for various transformation processes

Environment: Unix/Oracle 9i (SQL and PL/SQL), Agile Methodology