SUMMARY

• 7+ years of experience in Analysis, Development, and Implementation of business applications including Development and Design of ETL methodologies using Informatica Power Center in various domains like with strong business understanding of Insurance, Finance and Telecom Sectors.
• 7+ years of Data Warehousing experience using Informatica Power Center 9.5.1/9.1.0/8.6
• Strong experience with business requirement analysis, source system analysis, Data Analysis
• Designed and developed Complex mappings from various Transformations like re - usable transformations, and Mappings/Mapplets, Unconnected / Connected lookups, Router, Filter, Expression, Aggregator, Joiner, Update Strategy and more, mappings using Stored Procedure’s.
• Good knowledge on SDLC (software development life cycle) and good experience with unit testing and integration testing.
• Data modeling experience in dimensional modeling using star and snowflake schema across the Data Warehouse requirement. Strong knowledge in logical and physical data modeling.
• 7+ years of experience in dealing with various Data sources like Oracle, SQL Server, Excel, Flat files.
• Exposure working knowledge of UNIX shell scripting and job scheduling.
• Maintained outstanding relationship with Business Analysts and Business Users to identify information needs as per the business requirement.
• Excellent problem solving, analytical, written and communication skills with ability to work both in team as well as an individual.
• Preparing the High level Design Specifications for ETL Coding and mapping standards.
• Experience in Performance tuning of targets, sources, mappings and sessions.
• Experience in Ralph Kimball Methodology, Logical Modeling, Physical Modeling, Dimensional Data Modeling, Star Schema, Snowflake Schema, FACT tables, Dimension tables
• Performed ETL procedure to load data from different sources into data marts and Data Warehouse using Power Center.
• Strong expertise in Relational data base systems like Oracle 8i/9i/10g, SQL Server 2000/2005, MS Access, design and database development using SQL, PL/SQL, SQL PLUS, TOAD,SQL LOADER.
• Expertise in writing Oracle PL/SQL Stored Procedures/Functions/Packages and cursors Triggers.
• SQL Tuning and creation of indexes for faster database access, better query performance in Informatica by creating Explain Plan, SQL hints for query and indexing the required columns.
• Develop, execute ETL test plans, Document ETL processing and generate required metadata.
• Develop a transformation by marking the relevant data directly on a sample of the data source, and mapping that data to a chosen XML schema
• Outstanding communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high compliance to new technologies and tools.
• Have sound knowledge in life cycle development of Data Warehouse: Data Analysis, Design, Development, Implementation and Testing using Data Extraction, Data Transformation and Data Loading (ETL) using Informatica.
• Hands on experience in tuning mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Good experience in migrating the code across various environment and maintain the code in production
• Good understanding of relational database management systems like Oracle, and SQL Server.
• Expert level experience in designing and developing code for queries, stored procedures using triggers, cursors and other utilities provided by Oracle.
• In-depth knowledge of PL/SQL with the experience in constructing the triggers, functions, user defined datatype, procedures.

PROFESSIONAL EXPERIENCE

Confidential, Horsham, PA

Informatica Developer

Responsibilities:

• Extensively used ETL to transfer data from different source system and load the data into the target database.
• Extracted the data from the flat files and other RDBMS databases into staging area and populated onto Data Warehouse.
• Involved in full project life cycle - from analysis to production implementation and support
• Created pre and post session Stored procedures to drop, recreate the indexes and keys of source and target tables
• Analyzed the different source system interfaces data from Relational DB in scope for the project based on which wrote the Integration & technical Source-Target Data Mapping rules to be loaded to the Data Warehouse.
• Identified Data Elements & Attributes both from the system requirements and reporting stand point along with the Hierarchy, Relationship between the different Dimensions & Facts.
• Created and maintained the Parameter files in UNIX for the proper execution of Informatica workflows in different environments.
• Identified the bottlenecks in the sources, targets, mappings, sessions and resolved the problems.
• Attended production implementation calls and co-ordinated with the build engineers during migration of the code and was highly acknowledged.
• Performed complex defect fixes in various environments like UAT to ensure the proper delivery of the developed jobs into the production environment.
• Handled some of the data issues in the jobs, during the release of the project to send the correct data to the business users.
• Develop the source to target mapping document for ETL development in Informatica.
• Perform system testing and enter test cases in Quality Center to ensure data is loaded and mapped correctly to Data warehouse/ Data mart models according to the source to target mapping document
• Assist business analysts/users in identifying data gap and data variances
• Work with source system SMEs to identify the source data to be brought down to the Data mart
• Developed ETL procedures to transform the data in the intermediate tables according to the business rules and functionality requirements.
• Create and execute unit test plans based on system and validation requirements Troubleshoot, optimize, and tune ETL processes
• Used Informatica Designer to design transformations, reusable transformation, mappings and Mapplets.
• Update the data dictionary on system data and mapping information
• Responsible to create interactive Dash board reports as per the Business requirements.
• Documented and maintained and ensured the process and quality of the system.
• Weekly status report with the stakeholders.
• Involved in post production support worked with support team in resolving issues.
• KT to support team.

Environment: Informatica Power Center 9.5.1, SQL Server, Oracle, Toad, CVS, UNIX

Confidential, Chicago, IL

Informatica Developer

Responsibilities:

• Responsible for requirements gathering, analyzed the functional specs provided by the data architect and created technical specs documents for all the enhancements.
• Involved in design and development complex ETL mappings and stored procedures in an optimized manner.
• Developed Informatica SCD type-I, Type-II mappings and tuned them for better performance.
• Act as data liaison between web interface team and reporting team.
• Develop the ETL to process the flat file data from the standard location.
• Enable the flat file processing the standard location at regular intervals of time.
• Establish the rules in ETL for data attributes validation to match with predefined format set.
• Establish the rules in ETL to track the total records processed successfully loaded, rejections.
• Did migration of the code between environments having all the components in sync.
• Design and development of UNIX Shell Scripts to handle pre and post session processes.
• Used reusable transformation objects such as mapplets to avoid duplication of metadata, reducing the development time.
• Worked with the testers closely in determining both medium and high severity defects, that would potentially affect the downstream systems before the release of the project, and also fixed the defects before moving the jobs into production.
• Performed testing, knowledge transfer and provide technical support and hands-on mentoring in the use of Informatica.
• Unit, System Integration testing across the groups
• Attended production implementation calls and co-ordinated with the build engineers during migration of the code and was highly acknowledged.
• Handled some of the data issues in the jobs, during the release of the project to send the correct data to the business users.
• Weekly status report with the stakeholders.
• Involved in post production support worked with support team in resolving issues.
• Knowledge Transfer to the support team for ongoing maintenance responsibility

Environment: Informatica Power Center 9.1.0, Oracle, Toad, UNIX Shell Scripting, Flat Files, .Net, OBIEE.

Confidential, TX

Informatica Developer

Responsibilities:

• Involved in Major / Small / Emergency projects which comes as an enhancements or project request.
• Prepared the customer requirements and functional requirements.
• Involved in translating business requirements to Technical specifications. Also performed Column Mapping & identifying the Business Rules for some of the requirements.
• Involved in the Preparation of Detail Design Document (DDD).
• Performed various transformations, aggregations and ranking routines on the data to be stored in the Data Provisioning Mart.
• Documented the mappings and workflows & periodically updated the status of the work assigned to the system Owners.
• Documented and maintained and ensured the process and quality of the system
• Worked with mapping parameters and variables to load data from different sources to corresponding partition of the database table
• Involved in all web interfaces changes.
• Identify the bugs in the system and fixed those bugs by enhance the Scripts.
• Trouble shooting implementation / post implementation issues.
• Handling Service and incident requests reported by users.
• Monitor the whole Reporting and Information Management System and ensure that the reports are available to Users.
• Frequent communication with the customers to ensure the data integrity.
• Writing Unit and System Test Plan / Test Cases as per the requirements from the client.
• Provide weekly status report to managers describing the status of work and progress.
• Maintain project related documents and Client tool Clear Case.

Environment: UNIX, Windows2007 server,UNIX Shell Programming, PL/SQL, Toad, PL/SQL Developer, OBIEE, Informatica Powercenter 9.1.0 and.Net

Confidential, Charlotte, NC

ETL Informatica Developer

Responsibilities:

• Analyzed the data coming from different sources and their relationships.
• Interacted with business community and gathered requirements based on changing needs.
• Analyzed the architecture for Data Warehouse - star schema/snowflake model.
• Developed mapplets and re-usable transformations to prevent redundancy of transformation usage and maintainability.
• Monitor, troubleshoot batches and sessions for weekly and monthly extracts from various data sources across all platforms to the target database.
• Coordinated with the technical lead and aided in production support.
• Involved in writing Unix shell scripting, for automation of ETL process using Autosys for running the Batches and Sessions and scheduling them to run at specified time.
• Developed .sql files in unix box for creating and dropping staging tables.
• Prepared estimates and tracked each and every tasks and strictly adhered to the estimated deadlines.
• Extensive knowledge in promoting packages (code) across development, test, preproduction and production environment using tools like Computer Associate Harvest package.
• Responsible for unit testing of mappings developed.
• Provided production support by running the jobs and fixing the bugs.

Environment: Informatica Power Center 8.6, Oracle10g/9i, PL/SQL, UNIX, Win XP, Flat file, Unix Shell Scripting, TOAD, Microsoft Office.

Confidential, CA 

Informatica Developer

Responsibilities:

• Analyzed the data coming from different sources and their relationships.
• Interacted with business community and gathered requirements based on changing needs.
• Analyzed the architecture for Data Warehouse - star schema/snowflake model.
• Created various documents such as ETL technical design documents, test documents.
• Creation of Informatica mappings for Dimensions and fact.
• Developed mapplets and re-usable transformations to prevent redundancy of transformation usage and maintainability.
• Monitor; troubleshoot batches and sessions for weekly and monthly extracts from various data sources across all platforms to the target database.
• Identify the opportunities of performance improvement in the Informatica loads.
• Involved in writing Unix shell scripting, for automation of ETL process using Autosys for running the Batches and Sessions and scheduling them to run at specified time.
• Prepared estimates and tracked each and every tasks and strictly adhered to the estimated deadlines.
• Unit tested the developed code, created test SQLs, and handled UAT issues.
• Responsible for unit testing of mappings developed.

Environment: Informatica Power Center 8.6, Oracle 10g, PL/SQL, Shell Scripting, PL/SQL Developer, TOAD, ClearQuest