PROFESSIONAL SUMMARY:

Over * years of IT experience and Technical proficiency in ETL and Data Warehousing involved with Business Requirements Analysis, Application Design, Development, testing and documentation. Implementation of full lifecycle in Data warehouses and Data marts in various industries

Extensive experience in developing scalable enterprise applications to the user needs which serves for Financial, Insurance, Bank Industries.

Experience in all phases of the Software Development Life Cycle (SDLC)

Extensive experience with Informatica power center and its components like Repository Manager, Designer, Workflow Manager and Workflow Monitor, Reusable Transformations, Power Exchange, Mapplets etc

Expertise in implementing complex Business rules by creating robust Mappings, Mapplets, shortcuts and reusable transformations.

Experience in Data warehousing, Data Architecture & Extraction, Transformation and loading (ETL) data from various sources into Data Warehouse and Data Marts using Informatica Power Center 10.1/9.x/8.6.0/8.1.1/7.x/6.x/5.x

Involved in all aspects of ETL-requirement gathering, coming up with standard interfaces to be used by operational sources, data cleaning, coming up with data load strategies, designing various mappings, developing mappings, unit testing, integration testing, regression testing and UAT in development

Good understanding of Star and Snowflake Schema, Dimensional Modeling and Slowly Changing Dimensions

Experience on Informatica Data Quality, MDM, Data Masking and B2B.

Experience on Informatica Intelligent Cloud Services for Data Integration with Salesforce and On-Premise Application/Relational Database.

Experience in writing scripts such as SQL queries, PL/SQL Stored Procedures, Views, and Materialized Views & Triggers

Strong technical and professional client interactional skills. Interacted with Technical, Functional & Business audiences across different phases of the project of life cycle.

Experience using Oracle 11g/10g/9i/8i/7i, SQL, PL/SQL, SQL Loader, MS SQL Server 6.5/7.0/2000ß, MS Access 2000, Windows 95/98/2000/XP, Win NT 4.0

Excellent communication skills, strong decision-making skills, organizational skills, Quick learner and adaptive to new and challenging environments

Recognized for reliability, teamwork, persistence and strong work ethics

TECHNICAL SKILLS:

ETL Tools

Informatica Power Center 10.x/9.x/8.x/7.x/6.x/5.x (Source Analyzer, Mapping Designer, Mapplet, Transformations, Workflow Monitor, Workflow Manager), B2B, Data Masking, Data Quality, Informatica EDC, Axon, Informatica Cloud, SSIS.

Databases

Oracle 11g/10g/8i/9i, SQL Server 6.5/7.0/2000/2005/2008, MS SQL Server 7.0/2000, MS Access 2000/1997, Sybase 12.0

Data Modeling

Star-Schema Modeling, Snowflake-Schema Modeling, ERWIN Tool

Tools

SQL Navigator, SQL*Loader, SQL-Programmer, TOAD

(Tool for Oracle Application Development)

Operating Systems

Windows95/98/NT4.0/2000,XP,MDOS,SunSolaris 2.6/2.7, HP-UX, UNIX

Job Scheduling

Informatica Scheduler, Control M, Autosys

EDUCATION:

Master’s Degree in Information Technology

PROFESSIONAL EXPERIENCE:

Client: Toyota, Plano TX Dec 2013 - Current

Role: Sr Informatica Developer

Responsibilities:

Worked in Integration team and coordinated with different application teams for batch interfaces

Worked in Core Analysis and documented all business requirements for the replacement of Mainframe.

Extensively used ETL to load data using Power Center/from source systems like Flat Oracle. Files and Excel Files into staging tables and load the data into the target database

Worked with Business analysts for requirement gathering, business analysis, and testing and project coordination.

Involved in all technical work related to Informatica mappings.

Worked on Managed File Transfers for Secure data transfer between Applications.

Analyzed the requirements and framed the business logic for the ETL process

Analyzed source data and gathered requirements from the business users.

Worked on understanding and creating ETL Design documents and specifications.

Prepared technical specifications to develop ETL mappings to load data into various tables confirming to the business rules.

Hands on experience with MDM, Data Quality, B2B, Data Masking and Metadata Manager.

Worked with various Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, Stored procedure, Router and Normalizer etc.

Worked with Connected and Unconnected Stored Procedure for pre & post load sessions.

Worked on generating reports using Tableau.

Worked on the Analysis of Batch (Informatica) Interfaces.

Prepared technical specification to load data into various tables in Data Marts.

Worked on B2B Data Transformation Studio (DTS), Data Masking, Data Quality as part of project POC.

Designed and Developed pre-session, post-session routines and batch execution routines using Informatica Server to run sessions.

Worked extensively on Mappings, Mapplets, Sessions and Workflows.

Interacted with Project Manager, IT architects and SME’s to get a better understanding of the Business Processes.

Responsible for Unit Testing and Integration testing of mappings and workflows

Held walk-through with team members and QA teams and communicated interface requirements.

Hands on experience with Production support for running/monitoring Informatica jobs based on SLA using Autosys.

Responsible for validating Target data after applying different Informatica Transformations on the Source Data.

Worked on SSIS Integrations.

Worked as Lead with Implementation Team Members and performed ETL code reviews.

Prepared Test Strategy and Test Plans for Unit, UAT and Performance testing.

Coordinated and lead the end-to-end system testing effort – includes setting up the environment, code migration, running the test cycles and resolving the issues.

Environment: Informatica Power Center 10.2, Oracle 11g, SQL, B2B, MDM, Data quality, Data Masking, Unix, Autosys, Windows server, MS Access, Informatica EDC and Axon

Client: World Bank, Washington, DC Dec 2012- Nov 2013

Role: Sr ETL Developer

Responsibilities:

Worked with Business analysts for requirement gathering, business analysis, and testing and project coordination.

Analyzed source data and gathered requirements from the business users.

Worked on understanding and creating ETL Design documents and specifications.

Prepared technical specifications to develop ETL mappings to load data into various tables confirming to the business rules.

Extensively used ETL to load data using Power Center/from source systems like Flat Files and Excel Files into staging tables and load the data into the target database Oracle.

Expertise in implementing complex Business rules by creating robust Mappings, Mapplets, shortcuts and reusable transformations.

Analyzed the existing systems and made a Feasibility Study.

Worked with various Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, Stored procedure, Router and Normalizer etc.

Worked with Connected and Unconnected Stored Procedure for pre & post load sessions.

Automated the processes from existing Manual processes.

Prepared technical specification to load data into various tables in Data Marts.

Designed and Developed pre-session, post-session routines and batch execution routines using Informatica Server to run sessions.

Documented the complete Mappings.

Worked extensively on Mappings, Mapplets, Sessions and Workflows.

Used PMCMD command to start, stop and ping server from UNIX and created Shell scripts to automate the process.

Interacted with Project Manager, IT architects and SME’s to get a better understanding of the Business Processes.

Responsible for Unit Testing and Integration testing of mappings and workflows

Held walk-through with team members and QA teams and communicated interface requirements.

Responsible for validating Target data after applying different Informatica Transformations on the Source Data.

Prepared Test Strategy and Test Plans for Unit, UAT and Performance testing.

Coordinated and lead the end-to-end system testing effort – includes setting up the environment, code migration, running the test cycles and resolving the issues.

Environment: Informatica Power Center 9.1 (Repository Manager, Designer, Workflow Manager, and Workflow Monitor, Source Analyzer, Target Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Workflow Designer, Task Developer), Oracle 11g, SQL, Flat files, Unix, Informatica Schedulers, Windows server, MS Access.

Client: Lowe’s, NC June 2012 – Dec 2012

Role: Informatica Developer

Responsibilities:

Worked with Business analysts for requirement gathering, business analysis, and testing and project coordination.

Analyzed source data and gathered requirements from the business users.

Worked on understanding and creating ETL Design documents and specifications.

Prepared technical specifications to develop Informatica ETL mappings to load data into various tables confirming to the business rules.

Extensively used ETL to load data using Power Center/from source systems like Flat Files and Excel Files into staging tables and load the data into the target database Oracle.

Analyzed the existing systems and made a Feasibility Study.

Extracted Mainframe files using Informatica Power Exchange and transformed them to be loaded in Operation Data Store (ODS) tables.

Worked with various Informatica Transformations like Joiner, Expression, Lookup, Aggregate, Filter, Update Strategy, Stored procedure, Router and Normalizer etc.

Worked with Connected and Unconnected Stored Procedure for pre & post load sessions.

Automated the processes from existing Manual processes.

Prepared technical specification to load data into various tables in Data Marts.

Designed and Developed pre-session, post-session routines and batch execution routines using Informatica Server to run Informatica sessions.

Documented the complete Mappings.

Discussions with Architect for creating the Dimensions and fact tables.

Worked extensively on Mappings, Mapplets, Sessions and Workflows.

Scheduled and monitored the jobs using Tivoli Systems.

Used PMCMD command to start, stop and ping server from UNIX and created Shell scripts to automate the process.

Involved in PROD support for various SQL Server DTS jobs to load the SQL tables from one server to another.

Interacted with Project Manager, IT architects and SME’s to get a better understanding of the Business Processes.

Held walk-through with team members and QA teams and communicated interface requirements.

Responsible for validating Target data after applying different Informatica Transformations on the Source Data.

Worked on production tickets to resolve the issues in a timely manner.

Prepared Test Strategy and Test Plans for Unit, SIT, UAT and Performance testing.

Coordinated and lead the end-to-end system testing effort – includes setting up the environment, code migration, running the test cycles and resolving the issues.

Extensively worked on tuning Informatica mappings to increase performance.

Worked with different Source Systems to perform transformations and load to different Target Tables, Flat Files.

Assisted & Collaborated in generation of a complete set of reports using Business Objects to target different user segments.

Documented all mappings and workflows.

Worked onsite and coordinated with offshore resources and assisted for production stage.

Environment: Informatica Power Center 9.0, Oracle 11g, Db2, Flat files, Unix, Control M, Windows server, MS Access.

Client: SNL Financial LC, NJ Nov 2011 – April 2012

Role: ETL Developer

Responsibilities:

Requirement gathering from the end users and preparation of the BRDs

Implemented ETL Informatica designs and processes for the load of data from the sources to the target warehouse

Handled the documentation of entire ETL Process from the ODS, Staging, to the MDW warehouse environment

Used all the Informatica client components like Designer, workflow Manger, Workflow Monitor, Repository Manger, and Repository Admin Console.

Created repositories, folders, and users for the development, staging, and production environment

Worked with various active transformations in Informatica PowerCenter like Filter Transformation, Aggregator Transformation, Joiner Transformation, Normalizer Transformation, Rank Transformation, Router Transformation, Sorter Transformation, Source Qualifier, and Update Strategy Transformation.

Designed mappings from the scratch and did performance tuning of the mappings that were previously implemented

Extensively worked with SCDs slowly changing dimensions Type 1, Type 2, and Type 3

Extensively worked with incremental aggregation

Responsible for performance tuning at various levels like mapping level, session level, and database level

Worked with various kinds of partitions like Round Robin Partitioning, Hash Partitioning, Key Range Partitioning, and Pass-through Partitioning.

Extensively worked with various re-usable tasks, workflows, worklets, mapplets, and re-usable transformations

Extensively worked with Connected and Un Connected Look up Transformations in the Designer of Informatica PowerCenter.

Extensively worked with various Look up Caches like Static, Dynamic, Persistent, and Shared Caches.

Scheduled and ran the informatica mappings according the business logic

Environment: Informatica Power Center 8.1, Oracle 9.2.0.6, Linux

Contact this candidate