SUMMARY

• 8+ years of experience in the Industry wif wide range of skill sets on ETL, Oracle, Unix
• Expertise includes Data Loading, Data Analysis, Data Cleansing, Transformation and Data Integration using Informatica PowerCenter 9.x/8.x from various sources and targets including SAP,Oracle, MySql,XML and Flat files
• Experience in System Analysis, Design, coding and testing of Data Warehousing implementations across Life Sciences, Insurance, Networks and Communications Industries.
• Complete noledge of data ware house methodologies (Ralph Kimball, Inmon), ODS, EDW.
• Good Experience in implementing CDC in multiple projects.
• Experience wif Setmaxvariable and Parameter file approach CDC implementations.
• Worked extensively on Informatica’s Power Center Designer (Source Analyzer, Target Designer, Transformation Developer, Mapplet and Mapping Designer), Workflow Manager, Workflow Monitor, and Repository Manager.
• Experienced in working wif Project Management, Analysts and BI & Business Teams in Project deliverables.
• Involved in design meeting and low level design preparations.x
• Extensive experience maintaining Standards, Best Practices, Data Definitions…
• Extensive experience in RDBMS technologies using Oracle 11g/10g/9i, SQL Server, Toad 9.7, SQL*Plus and Database Querying using SQL and PL/SQL programming constructs.
• Proficient in Oracle PL/SQL including writing stored procedures, functions, triggers and packages.
• Identified and Populated Fact and Dimension tables according to Business Rules implementing Type 1 and Type 2 Slowly Changing Dimensions. Used different dimensional modeling techniques like Star and Snowflake Schema Modeling.
• Exposure to Informatica Data Quality IDQ.
• Actively involved in performance tuning techniques related to Informatica and Oracle.
• Extensive experience in error handling and problem fixing in Informatica.
• Proficient in UNIX platform wif respect to Informatica ETL environment. Wrote UNIX Shell Scripts to enhance functionality in Fetching, Loading and Scheduling Source files from the Source System, External and Internal Audit by generating Email Notification.
• Extensively work on the performance tuning of Informatica PowerCenter Mappings as well as the tuning of the sessions by creating multiple sessions on primary key values by using partition query.
• Excellent skills in fine tuning the ETL mappings in Informatica.
• Good noledge on Java.
• Experience in Data Modeling tool - Erwin and Data Warehousing Concepts
• Extensive experience using database tool such as SQL *Plus, SQL * Loader and TOAD
• Knowledge of business intelligence tool Cognos.
• Exposure to Teradata.
• Excellent technical and communication skills and ability to work TEMPeffectively and efficiently in teams.
• Experienced in Conducting daily Status meetings to monitor the state of the project
• Exceptional analytical and problem solving skills. Team player wif the ability to communicate TEMPeffectively at all levels of the development process.
• Experience in preparing Sop documents for the projects.

TECHNICAL SKILLS

ETL Tool: Informatica Power Center 9.x/8.x/7.x

DB Tools: SQL*Plus, TOAD 9.7

Development Languages: SQL, PL/SQL, Unix Shell Scripting

Data Bases: Oracle 11g/10g/9i, MySQL, SQL Server

Operating Systems: Windows 98/2000/NT/XP/7/8, UNIX, LinuxBI Tools: Cognos

Scheduling: WLM, Informatica Scheduler, Autosys

Web Technologies: Java, HTML, XML, DHTML, Eclipse

Data Modeling Tools: Erwin 7.3, Rational Rose

Others: Toad, PL/SQL Developer, PVCS, RFT, MS Office, Quality Center, Remedy

PROFESSIONAL EXPERIENCE

Confidential, Chicago, IL

Senior ETL Developer

Responsibilities:

• Interacted wif Business analysts to collect the Business requirements and understand the Usage of the project.
• Resolving user queries before the SLA wif accurate solutions.
• Coordinating wif various source teams regarding any data issues in production.
• Developed Mappings/Workflows/Scheduling ETL process.
• Used most of the transformations such as the Source qualifier, Application Source Qualifier, Router, Filter, Sequence Generator, Stored Procedure, Expression and Lookup as per the business requirement.
• Worked on enhancements like developing new mapping or changes to the existing code.
• Created SOP for the team purpose in order to face any challenges
• Implemented performance tuning and optimization techniques.
• Developed Coding Standards and Best Practices, Technical Specification Templates,
• Provide central point for questions/response between technical resources and business area
• Create clear concise documentation of requirements to review between the technical and business group.
• Production implementation coordination between the users and technology area Analyzed defined and managed Business needs.
• Analyzing the queries in case of any long running jobs and collecting the stats for the tables involved in it.
• Implemented Join conditions between tables at the Database level.
• Created ETL (Extract Transform and Load) specification documents based on the business Requirements.
• Mentor for the team in guiding wif production issues.
• Handling the monthly release activities on time to cope up the work.
• Developed Source to Target data mapping documents, inclusive of all the transformation and business rules, logical and physical column names, data types, data flow diagrams used for ETL Design and development.
• Created Source to Target (ETL) Mapping documents which included the fields, data type, definitions from both source and target systems. A business/transformation rule was also documented based on the business requirement or formatting needs of data.
• Created Data Flow Diagram which depicts the flow of data from the source system to the target system.
• Provided strategic support in development of detailed project plans, work assignments, target dates etc.

Environment: Informatica, Oracle, SAP, WLM, SQL, Stored Procedures (PL/SQL), Toad

Confidential, HollySprings, NC

Sr. ETL Developer

Responsibilities:

• Developed Informatica Mappings to transform and load into Oracle.
• Worked closely wif the ETL Lead, Data Modeler, Business Analysts to understand business requirements, providing expert noledge and solutions on Data Warehousing
• Developed source-target mappings and documented the same.
• Workflow development based on the order of data to be loaded.
• Implementing performance tuning and optimization techniques.
• Creation of SOP’s.
• Involved as the Key player in design and delivering the above projects.
• Interacted wif Business analysts to collect the Business requirements and understand the usage.
• Involved in the architecture of multiple stages of enterprise data warehouse .
• Involved in all phases of ETL i.e. from Source to target.
• Implemented Pl/SQL logic using Triggers, Stored Procedures, Sequences etc.
• Developed Coding Standards and Best Practices, Technical Specification Templates, Source to Target Mapping Templates, Initial and Incremental load strategies.
• Involved in designing the data mart as per the reporting requirements wif Type2 and Junk as dimension tables along wif fact tables.
• Acted as a mentor for the team and participated in code reviews and task assignments.
• Took care of quality procedures for analysis, program specifications, exhaustive test plans, defect tracking, change procedures etc.
• Managed and also actively worked on QA, UAT and Bug Fixing for the entire set of ETL jobs.
• Managed and also actively worked onday to day Production support activities.

Environment: Informatica, Oracle, SQL, Stored Procedures (PL/SQL), Toad

Confidential, Dayton, OH

ETL Developer

Responsibilities:

• Monitoring activities for all the Production related jobs.
• Abend resolution and tracking.
• Resolving the issures on adhoc basis by running the workflows through breakfix area in case of failures.
• Handling the daily and weekly status calls for the project.
• Handling meeting related to Production Handover and internal.
• Monitoring by checking logs and load details
• Resolving issues related to long running jobs
• Implementing the performance tuning techniques in case of long running jobs.
• Handling the weekly, monthly release activities.
• Extensively work on triggers, Stored Procedures, Joins, sequences in SQL/PLSQL.
• Worked wif DB team in order to modify any table and working in parallel for the related ETL changes.
• Coordinating wif differnet source teams during the release schedules for a smooth run.
• Analysis and Resolution of abends.
• Implementing the standard SLA procedures when ever required in the case of any failures.
• Ongoing Loads Support - Analyze aborts and resolve them on timing bases.
• Provide daily overrides to WLM jobs.
• Adhoc job schedule analysis requests, Adhoc issue analysis requests, Load status reporting
• Adhoc meetings wif Development team and Lights On team to resolve unexpected scheduling or data issues

Environment: Informatica, Oracle, SQL, Stored Procedures (PL/SQL), WLM, Toad, Remedy

Confidential

ETL Developer

Responsibilities:

• Proficiently managed for ETL development using the Informatica power center module 8.1.1.
• Worked wif Source Analyzer, Data Mappings, Transformations, Informatica Repository Manager, Workflow Manager and Monitor.
• Used most of the transformations such as the Source qualifier, Router, Filter, Sequence Generator, Stored Procedure and Expression as per the business requirement.
• Developed complex aggregate, joiner, look up transformation rules (business rules) to generate consolidated data.
• Created the Email task notifications in the workflow manager and also used the command task to run the batch scripts to execute the different applications.
• Tested all the Informatica mappings individually as well as wif the entire process, Tested Workflows
• Used Workflow Manager for creating and maintaining the Sessions. Also used Workflow Monitor to Monitor, edit, schedule, copy, aborts and delete sessions.
• Used various transformations like Source Qualifiers, Unconnected lookup, connected lookups, Expressions, Joiners, Filters, Routers, Update Strategy, Procedure etc.
• Administrated Workflow Manager to run Tasks and Worklets.
• Worked wif the Business analysts and the DBA for requirements gathering, business analysis, testing, and project coordination.
• Setup Workflow & Tasks to schedule the loads at required frequency using Workflow Manager.
• Done extensive testing and wrote queries in SQL to ensure the loading of the data.
• Tested the data and data integrity among various sources and targets. Associated wif Production support team in various performances related issues.

Environment: Informatica, SQL Server, Autosys, Unix.

Confidential

Informatica Developer

Responsibilities:

• Communicating wif Source and Target Vendors for Co-ordination.
• Resolved all types of Technical Issues in Informatica, Monitoring the loads.
• Reviewing the Documentation wif latest updates and Writing New Technical documents for new CRs and enhancements.
• Extensively worked on data Extraction, Transformation and Loading from source to target system using Informatica.
• Having good noledge in trouble shooting by studying Informatica logs and error codes
• Preparing Technical Design documents, Checking whether all the functionalities are met or not.
• Maintained LDS (Legacy Data store) application.
• Worked wif Informatica Admin team during code migration from Development to testing and Prod environments.

Environment: Informatica, MySQL,XML, Oracle SQL, Stored Procedures (PL/SQL), Unix.