SUMMARY

• Over nine (9) years of IT experience with extensive Data Warehousing implementations across Insurance and Financial Industries.
• Over seven (9) years of ETL and data integration experience in developing ETL mappings and scripts using Informatica PowerCenter 9.x/8.x.
• 8 Months of experience in Hadoop cluster development.
• Experience in all the phases of Data warehouse life cycle involving Requirement Analysis, Design, Coding, Testing, and Deployment.
• Experience in working with business analysts to identify, study and understand requirements and translated them into ETL code in Requirement Analysis phase.
• Experience in creating High Level Design and Detailed Design in the Design phase.
• 7 Years of experience in database programming using Oracle11g,10g,9i,8i, Teradata, XML Files,SQL, PL/SQL, SQL*Plus, SQL*Loader.
• Strong Working knowledge in Oracle and PL/SQL Writing Stored Procedures, Packages, Functions, exception handling and Triggers.
• 2 years of experience using Utility scripts like BTEQ, FastLoad, MultiLoad to load data from various source systems to Teradata Enterprise Data warehouse and Good Understanding in protection concepts like Fallback and Journals.
• Data Processing Experience in Designing and implementing Data Mart applications, mainly transformation Process using ETL tools like Informatica.
• Worked with Metadata Definitions, Import and Export of Datastage jobs using Data stage Manager.
• Extensively worked on Extraction Transformation and Loading (ETL) using Informatica 9.6/9.5/9.0/8.6 (Power Center).
• Expertise in Business Model development with Dimensions, Hierarchies, Measures, Partitioning, Aggregation Rules, Cache Management.
• Extensively worked on the ETL mappings, analysis and documentation of OLAP reports requirements. Solid understanding of OLAP concepts and challenges, especially with large data sets.
• Well versed in OLTP Data Modeling, Data warehousing concepts.
• Strong knowledge of Entity - Relationship concept, Facts and dimensions tables, slowly changing dimensions and Dimensional Modeling (Star Schema and Snow Flake Schema).
• Experience in integration of various data sources like Oracle, Netezza and non-relational sources like flat files into staging area.
• Experience in creating Reusable Transformations (Joiner, Sorter, Aggregator, Expression, Lookup, Router, Filter, Update Strategy, Sequence Generator, Normalizer and Rank) and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Experience in creating Reusable Tasks (Sessions, Command and Email) and Non-Reusable Tasks.
• Experienced in UNIX work environment, file transfers, job scheduling and error handling.
• Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.
• Worked on Performance Tuning, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Experience in writing, testing and implementation of the Complex SQL Queries and PL/SQL scripts.
• Expert in using debugger in Informatica Designer tool to test and fix errors in the mappings.
• Proficient in using schedulers like ESP, Autosys to schedule sessions and batches.
• Good Understanding knowledge of Ralph Kimball & Bill Inman Methodologies.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate.
• Experience in support and knowledge transfer to the production team.
• Proficient in interaction with the business users by conducting meetings with the clients in Requirements Analysis phase.
• Good understanding of Software Development Life Cycle (SDLC) and Project Life Cycle.
• Assign work and provide technical oversight to onshore and offshore developers
• Excellent analytical/ communication skills and good team player.

TECHNICAL SKILLS

Data Warehouse: ETL, Star Schema, Snow Flake Schema, Dimensions and Facts.

ETL Tools: Informatica (Power Centre) 9.x/8.x, Data Stage, SSIS

Databases: Netezza, Oracle, Teradata V2R5 (Fast-Load, Multi-Load, Fast Export, BTEQ), SQL Server

Scripting Languages: SQL, PL/SQL, UNIX/LINUX and Job Information Language (JIL).

Database Tools: SQL Plus, TOAD, AQT and SQL Developer.

Scheduler: Autosys, ESP (CA Work Station), Control-M

Version Control Tools: SVN and CA Version Control tools.

Software Methodology: Agile and Waterfall.

Domain Experience: Insurance, Banking, Entertainment

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Sr. ETL Developer

Responsibilities:

• Coordinated with Business Users to understand business needs and implement the same into a functional Data warehouse design.
• Responsible in designing and introducing new (Dimension Tables) to the existing Star Schema model.
• Developed various Mappings & Mapplets to load data from ODS using different transformations
• Used Informatica as an ETL tool to extract data from Oracle source systems and aggregate the data and Load into the Netezza database.
• UsedTeradata utilities fast load, multiplied, tpumpto load data and wrote BTEQ scripts to transform the data
• Used Data Stage Manager to manage the Metadata repository and for import/export of jobs.
• Developed UNIX scripts to format the source files and to extract the information from error logs.
• Developed Mapplets and Reusable Transformations.
• Developed and tested all the backend programs, Error Handling Strategies and update processes.
• Created and Monitored Batches and Sessions using Informatica Power Center Server.
• Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
• Designed and developed mappings using Source Qualifier, Expression, Lookup, Router, Aggregator, Filter, Sequence Generator, Stored Procedure, Update Strategy, joiner and Rank transformations.
• Responsible to tune ETL procedures and schemas to optimize load and query Performance.
• Implemented Change Data Capture (CDC) to maintain historical data of Source Systems.
• Worked in setting up Scheduling jobs using CA Workstation tool (ESP)
• Involved with the Architecture group to develop ETL metadata strategies and Informatica objects reuse policies
• Developed Scripts to automate the Data Load processes to target Data warehouse.
• Part of the Production Support team.
• Performed activities such as Query Optimization, Database Consistency Monitoring

Environment: Informatica Power Center 9.6/9.5, Netezza, Oracle 11G/10G, PL/SQL, SQL*Plus, UNIX, ESP Scheduler and CA Version Control tools, Teradata.

Confidential, Richmond, VA

Sr. Informatica developer

Responsibilities:

• Collaborated with Business analysts for requirements gathering, business analysis and designing of the Enterprise Data warehouse
• Experience in usingSSIStools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
• Involved in requirement analysis, ETL design and development for extracting data from the heterogeneous source systems like Oracle, flat files and loading into Staging and Data Ware House Star Schema.
• Involved in massive data cleansing prior to data staging.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Designed Type1 and Type2 mappings
• Transformed data from one server to other servers using tools likeSQL Server Integration Services(SSIS) (2005/2008).
• Extensively used Informatica client tools Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, Transformation Developer, Informatica Repository Manager and Informatica Workflow Manager.
• Design and Development of ETL routines, using Informatica Power Center within the Informatica Mappings, usage of Lookups, Aggregator, Ranking, connected and unconnected Lookups, SQL overrides usage in Lookups and source filter usage in Source qualifiers and data flow management into multiple targets using Routers were extensively done.
• Created complex mappings with shared objects/Reusable Transformations/Mapplets using mapping/mapplet Parameters/Variables.
• Configured workflows with Email Task, which would send mail with session, log for Failure of a sessions and for Target Failed Rows.
• Used Server Manager to create schedules and monitor sessions. And to send the error messages to the concerned personal in case of process failures.
• Created sequential/concurrent Sessions/ Batches for data loading process and used Pre & Post Session SQL Script to meet business logic.
• Extensively used pmcmd commands on command prompt and executed Unix Shell scripts to automate workflows and to populate parameter files.
• Created Stored Procedures to transform the Data and worked extensively in PL/SQL for various needs of the transformations while loading the data into Oracle database.
• Worked with UNIX scripts extensively for job execution and automation.
• Scheduled Informatica workflows using Autosys to run at regular intervals.
• Used SQL tools like Query Analyzer and TOAD to run SQL queries and validate the data.
• Tuning the Mappings for Optimum Performance, Dependencies and Batch Design.
• Designed and developed the logic for handling slowly changing dimension table’s load by flagging the record using update strategy for populating the desired.
• Documented ETL test plans, test cases, test scripts, test procedures, assumptions, and validations based on design specifications for unit testing, system testing, expected results, preparing test data and loading for testing, error handling and analysis.
• Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements.

Environment: Informatica Power Center 9.0, Oracle10g/11g, SQL, PL/SQL, SQL*Plus, TOAD, WinSCP, Flat files, Putty, Autosys and UNIX.

Confidential, El Segundo, CA

Sr. Informatica Developer

Responsibilities:

• Interacted with business community and gathered requirements based on changing needs.
• Incorporated identified factors into Informatica mappings to build Data Warehouse.
• Knowledge of working with Hadoop as a source system
• Developed mappings to extract data from Oracle, Flat files and load into Oracle 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.
• Conducted Database testing to check Constrains, field size, Indexes, Stored Procedures, etc.
• UsedTeradata utilities fast load, multiplied, tpumpto load data and wrote BTEQ scripts to transform the data
• Implemented various Performance Tuning techniques on Sources, Targets, Mappings, and Workflows.
• Written complex SQL queries in Oracle for testing the Informatica mappings.
• 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.
• Executed Multi-Load scripts for daily batch jobs.
• Identified sources, targets, mappings and sessions and tuned them to improve performance
• Collected the Stats in Oracle for all the queries after every refresh of the DB for improving the query performance.
• 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.
• Scheduled Informatica jobs through Autosys Scheduler for UAT and Production.
• Actively participated in data base testing like checking the constraints, correctness of the data, stored procedures, field size validation, etc.
• Used command line mode to embed pmcmd commands in to shell scripts and used pmcmd, pmrep commands in Interactive mode to access repository and workflows.
• Worked closely with the business analyst’s team in order to solve the Problem Tickets, Service Requests by giving 24/7 Production Support.

Environment: Informatica Power Center 8.6, Oracle10g/11g, SQL, PL/SQL, SQL*Plus, TOAD, Ultra Edit, Flat files, Putty, Autosys and UNIX, Teradata

Confidential, Newark, DE

Informatica Developer

Responsibilities:

• Analyzed the source data, Coordinated with Data Warehouse team in developing Relational Model. Designed and developed logical and physical models to store data retrieved from other sources including legacy systems.
• Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
• Developed complex Informatica mappings to load the data from various sources using different transformations like source qualifier, connected and unconnected look up, expression, aggregator, joiner, filter, normalize, rank and router transformations.
• Worked on Informatica power center tools like source analyzer, mapping designer, mapplet and transformations.
• Developed Informatica mappings and also tuned for better performance.
• Extensively used Informatica to load data from flat files, Oracle database.
• Developed views in Oracle and using lookup, expression and router implemented the Change Data Capture (CDC) process.
• Maintained warehouse metadata, naming standards and warehouse standards for future application development.
• Created and Monitored Workflows using Workflow Manager and Workflow Monitor.
• Load balancing of ETL processes, database performance tuning and capacity monitoring.
• Involved in Unit testing and System testing of the individual.
• Analyzed existing system and developed business documentation on changes required.
• Used UNIX to create Parameter files and for real time applications.
• Extensively involved in testing the system from beginning to end to ensure the quality if the adjustments made to oblige the source system up-gradation.
• Worked with many existing Informatica mappings to produce correct output.
• Prepared Detail design documentation thoroughly for production support department to use as hand guide for future production runs before code gets migrated.
• Prepared Unit Test plan and efficient unit test documentation was created along with Unit test cases for the developed code.
• Detail system defects are created to inform the project team about the status throughout the process.

Environment: Informatica Power Center 8.6, Oracle10g/11g, SQL, PL/SQL, SQL*Plus, TOAD, Ultra Edit, Flat files, Putty, Autosys and UNIX.

Confidential, Washington, DC

ETL Specialist

Responsibilities:

• Developed and supported the Extraction, Transformation, and load process (ETL) for data migration using Informatica power center.
• Responsible for developing Source to Target Mappings.
• Extensively used Informatica Client tools- Source Analyzer, Warehouse Designer, Mapping Designer.
• Developed Informatica mappings for data extraction and loading worked with Expression, Lookup, Filter and Sequence generator and Aggregator Transformations to load the data from source to target.
• Conceptualized and developed initial and incremental data loads in Informatica using Update strategy transformation.
• Developed mappings, sessions for relation and flat source and targets.
• Imported data from various source (Oracle, Flat file) and transformed and loaded into targets using Informatica.
• Created and scheduled Session, jobs based on demand, run on time.
• Monitored Workflows and Sessions
• Developed Unit test cases for the jobs.
• Identified the facts and dimensions and designed the relevant dimension and fact tables.

Environment: Informatica 8.6, Oracle 9i, SQL, PL/SQL and UNIX.

Confidential, Virginia Beach, VA

ETL Developer

Responsibilities:

• Understanding Business Processes.
• Coordinated with Business-users to get specific requirements.
• Interactions with the client to capture the requirements of the Clients Business so as to transform the Business Requirements into data elements as per the functionality requirements.
• Developed Complex mappings by extensively using Informatica.
• Transformations like Source Qualifier, Lookup, Filter, Expression, Aggregator etc.
• Checking the Mappings and responsible for Performance tuning and Error handling of Informatica mappings.
• Worked on Informatica tools like Source Analyzer, warehouse designer, Mapping Designer & Mapplet, and Transformations.
• Tested the data extracts to check if they conform to the business rules.
• Perform regression and integration testing as required.
• Supported User Acceptance Testing

Environment: Informatica Power center 8.1, DB2, SQL server, Business Objects, Control M

Confidential, CA

ETL Developer

Responsibilities:

• Developed Informatica mappings and mapplets to implement the business rules as per table specification documents.
• Worked on developing reusable transformations, mappings and sessions, custom session variables and workflow scheduling.
• Extensively worked on Informatica performance tuning involving source level, target level and mapping level bottlenecks.
• Worked on ETL optimization, troubleshooting and debugging Informatica mappings.
• Worked on database performance tuning, troubleshooting and capacity estimation.
• Work with System Testing and UAT teams to analyze and resolve opened defects.
• Acted as a subject matter expert for the applications in my area.
• Development standards are closely followed and adhere to the team’s SDLC process to ensure all technical solutions have the best quality in mind and prevent any impact to our production systems
• Provide operational support on complex/escalated issues to diagnose and resolve incidents in production systems.
• Worked on scheduling jobs in control-m scheduler tool.
• Provide 24/7 support during the warranty period for projects that have been deployed to production.

Environment: Informatica Power Center 8.6, Oracle 9i, PL/SQL Developer, SQL*Plus, UNIX Shell Script, Control-M

Confidential, Columbus, OH

ETL Developer

Responsibilities:

• Developed Mapping by using various transformations to suit the business user requirements and business rules to load
• Worked on Source Analyzer, Warehouse Designer, Mapping Designer, and Mapplet Designer to Extract Sources, transform Data and load into Target. Used Informatica Workflow manager to create Workflows and Sessions
• Responsible for administration and development withInformaticaPower Exchange tool for CDC,
• Involved in the designing of Star and Snow Flake Schemas, Physical and Logical models, ER diagrams, Data Flow Diagrams/Process Diagrams.
• Involved in Performance Tuning and optimizing ETL process and coming up with the best design to
• Obtain superior performance.
• Worked on creating UNIX shell scripts to automate the ETL process.
• Writing PL/SQL procedures, functions, triggers and other database components.

Environment: Informatica Power Center 9.1, Oracle 10i, PL/SQL Developer, SQL*Plus, UNIX Shell Script