SUMMARY:

• 7+ years of IT professional experience in designing, analysis, programming and testing using Informatica Power Center 9.x/8.x/7.x/6.x.
• Extensive experience in design, development and implementation of Data marts, Enterprise Data Warehouses and Business Intelligence Solutions.
• Extensive experience in Developing Informatica complex mappings/ Mapplets using various Transformations for Extraction, Transformation and Loading of data from multiple sources of data warehouses and creating workflows with worklets& tasks and scheduling using workflow manager.
• Extensive experience of gathering requirement, Proof of concept, gap analysis, design, development, and Implementation of the ETL/Data warehouse projects.
• Intelligent Gathering of Business requirements to map legacy and other sources to integrate into the Warehouse.
• Experience in providing end - to-end business intelligence solution by dimensional modeling design, development, and loading, building business models, configuring metadata and validation dashboard reports.
• Proficient in designing and developing the various transformation logics by utilizing the expression, filter, joiner, lookup, router and rank.
• Hands on experience in tuning mappings, identify and resolve performance bottlenecks in various levels like source, target, mappings and session.
• Proficient in writing complex Oracle SQL, Views, for database applications.
• Very good exposure to Oracle 11g,10g, 9i, 8.x, MS SQL Server 2000/2005, IBM DB2, Teradata databases
• Hands on experience working in UNIX and Windows environments.
• Experience on Business Requirements Analysis, Application Design, Development, testing, implementation and maintenance of client/server Data Warehouse and Data Mart systems in the Industrial, Insurance, Pharmaceutical industries
• Ability to meet deadlines and handle multiple tasks, decisive with strong leadership qualities, flexible in work schedules and possess good communication skills.
• Team player, Motivated, able to grasp things quickly with analytical and problem solving skills.
• Excellent Verbal and Written Communication Skills. Have proven to be highly effective in interfacing across business and technical groups.

TECHNICAL SKILLS:

ETL/DW Tools: Informatica Power Center 9.5.1/9.1/9.0/8.6.1/8.6/8.5.1/8.1/ 7.1.3/7.1.1/6.2

Data Modeling Tools and others: Erwin

DBMS: Oracle 11g/10g/9i/8i, Sql Server 2000, 2005, Teradata, TOAD

Languages: SQL, PL/SQL, SQL*PLUS, C.

Operating Systems: Unix, MS Windows NT/95/98/2000/XP.

WORK EXPERIENCE:

Confidential, NC

Informatica Developer

Roles & Responsibilities:

• Responsible for Extraction, Transformation and Loading the data into Data warehouse by using Informatica Power center 9.1.1
• Supported and executed the job run cycles manually through the workflow process setup for each release.
• Validated and monitored daily job runs.
• Migrated ETL codes from Development to Test environment another lower environments using udeploy process
• Created Parmfiles for the automation of the workflows.
• Worked on scripts and Parmfiles to schedule the weekly tasks automated
• Scheduled batch jobs using CA-ESP and spring batch monitor to run the workflows.
• Used SQL, PL/SQL, and TOAD to validate the Data going in to the Data Ware House.
• Extensively involved in ETL testing, Created Unit test plan and Integration test plan to test the mappings, created test data. Use of debugging tools to resolve problems.
• Used workflow monitor to monitor the jobs, reviewed error logs that were generated for each session, and rectified any cause of failure.
• Worked on several transformations such as Filter Transformations, Joiner Transformations, Rank Transformations, Sequence Generator Transformations, Stored Procedure Transformations, Lookup, Expression Transformations, Update Strategy and Aggregator Transformation in Informatica.
• Automated all the production jobs to reduce the manual intervention.
• Analyzed the compatibility of the current code base and determined the impacts of new data mart (CDM) over the existing system.
• Worked on the issues occurring on the scheduled mappings and workflows.
• Worked to support during the releases with production team
• Worked in delivery and support teams
• Prepared reverse KT document of the project and presented it
• Worked on creating change mangement ticket in HP service for release in agile process to deploy the code

Environment: Informatica 9.1.1, TOAD, UNIX, CA-ESP, Spring batch monitoring,udeploy, Harvest, Winscp, Teradata

Informatica Developer

Roles & Responsibilities:

• Single handedly developed the module by dumping the data from source to a staging area, the staging data was then cleansed and validated against the specified business rules and loaded into Intermediate layer.
• The cleansed data from the Intermediate layer was then loaded into Data Repository after applying the required transformation rules.
• Created materialized views for the better performance in reporting.
• Responsible for Extraction, Transformation and Loading the data into Data warehouse by using Informatica Power center 9.5.
• Worked on several transformations such as Filter Transformations, Joiner Transformations, Rank Transformations, Sequence Generator Transformations, Stored Procedure Transformations, Lookup, Expression Transformations, Update Strategy and Aggregator Transformation in Informatica.
• Designed and developed SCD1 and SCD2 mappings as per business requirements.
• Created staging tables from the legacy database along with the auditing information.
• Involved in Analysis Phase to gather the requirement provided by user and prepare the functional document.
• Performed performance tuning of mappings and sessions and decreased the execution time.
• Interacting with BA’s and downstream end users to understand the requirements clearly.
• Involved in creating the data model and specs for the ETL development.
• Developed Informatica mappings. Unit test ETL mapping codes and validated the result set data.
• Load the data from various File systems to the DWH and DM.
• Maintain the Versioning for the objects by using VSS.
• Analyzed the compatibility of the current code base and determined the impacts of new data mart (CDM) over the existing system.
• Designed and documented the technical and functional specification of the module.
• Documented validation rules, exception processing and test strategy of the mappings
• Migrated ETL codes from Development to Test to Production.
• Supported and executed the job run cycles manually through the workflow process setup for each release.
• Performed unit testing for the developed mappings.
• Created Source to Target Mappings (STTMs) document.
• Validated and monitored daily job runs.
• Studied and analyzed existing mappings/sessions and identified performance bottlenecks.
• Translate data transfer requirements into ETL solutions.
• Design, develop, test, and maintain ETL processes.

Environment: Informatica 9.5.1, Share point, System navigator, TOAD, IBM DB2, AS400.

ETL Developer

Responsibilities:

• Worked with Business Analyst and Analyzed specifications and identified source data needs to be moved to data warehouse, Participated in the Design Team and user requirement gathering meetings.
• Worked on Informatica - Repository Manager, Designer, Workflow Manager & Workflow Monitor.
• Involved in discussing Requirement Clarifications with multiple technical and Business teams.
• Created Technical Design Document from the functional specification documents.
• Worked on Informatica tools such as Source Analyzer, Data Warehouse Designer, Transformation Designer, Mapplet Designer and Mapping Designer to design, develop and test complex mappings and mapplets to load data from external flat files and RDBMS.
• Used InformaticaPowerCenter 9.1 for extracting Oracle, flat files for Data Extraction Involved in the development of Informatica mappings and also tuned them for better performance.
• Extensively used various transformations like Source Qualifier, Joiner, Aggregators, Connected & Unconnected lookups, Filters, Router, Expression, Rank, Union, Normalizer, and Update Strategy & Sequence Generator.
• Used SQL, PL/SQL, and TOAD to validate the Data going in to the Data Ware House.
• Worked with BA in the QA phase of testing.
• Worked on Informatica Schedulers to schedule the workflows.
• Scheduled batch jobs using Autosys to run the workflows.
• Extensively involved in ETL testing, Created Unit test plan and Integration test plan to test the mappings, created test data. Use of debugging tools to resolve problems.
• Used workflow monitor to monitor the jobs, reviewed error logs that were generated for each session, and rectified any cause of failure.

Environment: Informatica Power Center 9.1/8.6, Oracle 11g, PL/SQL, Autosys, SQL, Teradata, SQL* LOADER, TOAD, Shell Scripting

Confidential

ETL Developer

Roles & Responsibilities:

• Extensively involved in enhancing and managing Unix Shell Scripts.
• Understand the business rules completely based on High Level document specifications and implements the data transformation methodologies.
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
• Effectively worked on Onsite and Offshore work model.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.
• Created and scheduled Sessions, Jobs based on demand, run on time and run only once.
• Wrote Unix scripts, perl scripts for the business needs.
• Created Universes and generated reports on using Star Schema.

Environment: SSIS, SQL Server 2008 Oracle 10g, SQL, PL/SQL, Quality Center, IDQ, Windows 2003.

ETL Developer

Roles & Responsibilities:

• Responsible for the creating stored procedures and database triggers.
• Wrote SQL scripts to create staging tables and developed SQL*Loader control files to load the data from data files into the staging tables.
• Assists other members in project team in domain or application functionality to complete project design and build phase activities as required project.
• Understand the Business requirements and estimate the effort for the new requirements.
• Trend analysis of defects/logs for identification of problem areas and to improve productivity.
• Customization/Creation of ETL components.
• Handled complete configuration of customized/new tasks and loading process through DAC.
• Understand the Business requirements and estimate the effort for the new requirements.
• With Technical and functional expertise of the system helping other teams to understand and develop new systems that would make the business more productive and efficient.
• Take care of CR (Change Request).
• With Technical and functional expertise of the system helping other teams to understand and develop new systems that would make the business more productive and efficient.
• Creation of Unit Test Cases for testing purpose.
• Performance tuning of the application wherever required
• Preparing the estimation for new CR and bug fixes.
• Doing the System improvement plan wherever required.

Environment: InformaticaPowerCenter 8.x (Repository Manger, Designer, Workflow Monitor, Workflow Manager), Flat files, Oracle, MS SQL Server 2005, Windows NT, PL/SQL, Erwin 4.0,Toad, UNIX, SQL*Plus, PL/SQL, Flat files, MS-Access, Control-M.