SUMMARY:

• Experienced Informatica Developer with over 6+ years of IT experience in various phases of business applications such as analysis, design, deployment and testing in the field of Data Warehousing using Informatica (ETL) in an OLAP and OLTP environment. Have worked within the Banking, Insurance and Healthcare domain.
• Extensive experience on Informatica Power Center (9.x, 8x, 7x) with strong business understanding and knowledge of ETL of data from heterogeneous source systems like Flat files, Excel, XML, Oracle, SQL Server.
• Worked on all phases of data warehouse development lifecycle, from gathering requirements, ETL design and implementation, and support or new and existing applications.
• Strong ETL data integration experience using Informatica Powercenter, Repository Admin Console, Repository Manager, Designer, Workflow Manager, Workflow Monitor, Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet Designer, Mapping Designer, Task Developer, Worklet Designer, Workflow Designer, Task View, Mapplets.
• Created Mapplets, reusable transformations, look - ups for better usability and performance.
• Experience in implementing the complex business rules by creating transformations (Expression, Aggregator, Unconnected and Connected Lookups, Dynamic Lookup, XML Parser, XML Generator, Router, Rank, Update Strategy, Union, Sorter, Joiner, Filter, Normalizer, Sequence Generator), and developing complex Mapplets and Mappings.
• Extensive experience in implementation of Data Warehousing, Data Marts, Star and Snowflake Schema, Dimensional Modeling on OLTP and OLAP concepts
• Experience in Slowly Changing Dimensions Types, OLAP, Data Reports and Surrogate keys, Normalization/De normalization.
• Good knowledge in data warehousing techniques for Data Cleansing, S urrogate Key Assignment and Change Data Capture (CDC)
• Used UNIX Shell scripting for automation of the process, invoking Informatica sessions
• Good understanding of Business Intelligence (BI)
• Have created basic reports using SQL Server Reporting Service(SSRS)
• Expertise in QA Methodologies, Quality Assurance Life Cycle, Test Strategy, Test metrics.
• Extensive experience in testing system in various phases Integration, System, User Acceptance Testing, and Regression testing.
• Have created basic reports using SQL Server Reporting Service(SSRS)
• Validated several SSRS reports to verify that they are working according to BRS.
• Exposure to SQL Server Integration Service (SSIS)
• Experience in testing tool JIRA.
• Involved in Preparing Test Plans, Test Cases, Test Strategy, and Test Scenario’s, Test data, Test log and Defect Reports
• Extensively worked on Batch scheduling tools Autosys to run and monitor ETL jobs.
• Knowledge on the phases of agile and waterfall methodology.
• Excellent communication skills, good organizational skills, self-motivated, hardworking, ability to work independently or cooperatively in a team, ability to grasp quickly and learn fast and open to new technologies.

TECHNICAL SKILLS:

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

DBMS/Query Tools: TOAD, SQL Developer, SQL Navigator

Languages: SQL, HTML, XML

Databases: Oracle11/g/10g, SQL Server 2008/2005/2000, DB2,Teradata

BI / Reporting Tools: SQL Server Reporting Service (SSRS) basic.

Operating Systems: Microsoft Windows - Vista, XP, 98, 2000, NT 4.0, UNIX

Scheduling tools: Autosys, Control M

PROFESSIONAL EXPERIENCE:

Confidential, KY

Informatica Developer

Responsibilities:

• Worked with business analysts for requirement gathering (BRD), business analysis, and translated the business requirements into technical specifications to build the Enterprise data mart.
• Interacted with both Technical, functional and business audiences across different phases of the project life cycle.
• Developed mappings for fact and dimension tables using the various transformations to extract data from different source databases Oracle, SQL Server.
• Designed and developed complex ETL mappings by making use of transformations like Source Qualifier, Joiner, Update Strategy, Connected Lookup and unconnected Lookup, Rank, Expression, Router, Filter, Aggregator and Sequence Generator transformations.
• Created Workflows using various tasks like sessions, events raise, event wait, decision, e-mail, command, worklets, Assignment and worked on scheduling of the workflows.
• Used mapping parameters and variables.
• Prepared mapping specification document, which gives the data flow and transformation logic for populating each column in the data warehouse table.
• Used debugger to analyze the data flow between source and target to fix the data issues.
• Implemented audit and reconcile process to ensure Data warehouse is matching with the source systems in all reporting perspectives.
• Prepared the Standard Operating Procedure (Knowledge Transfer) document, which provides necessary information, required for the Maintenance and Operation of the application.
• Created the release requests for QA Builds to include all the release requirements and involved in the implementation of QA, UAT and Production releases.
• Provided data loading, monitoring, System support and worked on data issues raised by end user during its production support phase.

Environment: Informatica Power Center 9.5.0, S, Oracle 11g, SQL Server 2008, Flat Files, UNIX, TOAD.

Confidential, Danville, PA

ETL Developer

Responsibilities:

• Developed ETL programs using Informatica to implement the business requirements.
• Communicated with business customers to discuss the issues and requirements.
• Created shell scripts to fine tune the ETL flow of the Informatica workflows.
• Used Informatica file watch events to pole the FTP sites for the external mainframe files.
• Production Support has been done to resolve the ongoing issues and troubleshoot the problems.
• Performance tuning was done at the functional level and map level. Used relational SQL wherever possible to minimize the data transfer over the network.
• Effectively used Informatica parameter files for defining mapping variables, workflow variables, FTP connections and relational connections.
• Effectively worked in Informatica version based environment and used deployment groups to migrate the objects.
• Used debugger in identifying bugs in existing mappings by analyzing data flow, evaluating transformations.
• Effectively worked on Onsite and Offshore work model.
• Pre and post session assignment variables were used to pass the variable values from one session to other.
• Designed workflows with many sessions with decision, assignment task, event wait, and event raise tasks, used informatica scheduler to schedule jobs.
• Reviewed and analyzed functional requirements, mapping documents, problem solving and trouble shooting.
• Performed unit testing at various levels of the ETL and actively involved in team code reviews.
• Identified problems in existing production data and developed one time scripts to correct them.
• Fixed the invalid mappings and troubleshoot the technical problems of the database.

Environment: Informatica 9.1, Oracle SQL Server 2008 R2, Unix

Confidential, Chicago, IL

Jr ETL Developer

Responsibilities:

• Involved in all phases of SDLC from requirement gathering, design, development, testing, Production, user training and support for production environment.
• Create new mapping designs using various tools in Informatica Designer like Source Analyzer, Warehouse Designer, Mapplet Designer and Mapping Designer.
• Develop the mappings using needed Transformations in Informatica tool according to technical specifications
• Created complex mappings that involved implementation of Business Logic to load data in to staging area.
• Used Informatica reusability at various levels of development.
• Developed mappings/sessions using Informatica Power Center 8.6 for data loading.
• Performed data manipulations using various Informatica Transformations like Filter, Expression, Lookup (Connected and Un-Connected), Aggregate, Update Strategy, Normalizer, Joiner, Router, Sorter and Union.
• Developed Workflows using task developer, Worklet designer and workflow designer in Workflow manager and monitored the results using workflow monitor.
• Extracted data from Oracle and SQL Server then used Teradata for data warehousing.
• Implemented slowly changing dimension methodology for accessing the full history of accounts.
• Optimizing performance tuning at source, target, mapping and session level
• Participated in weekly status meetings, and conducting internal and external reviews as well as formal walk through among various teams and documenting the proceedings.

Environment: Informatica 8.6 .1, Oracle 10g, SQL Server 2005, Unix, Control M

Confidential, Madison, WI

ETL/Data Warehouse Tester

Responsibilities:

• Involved in Developing test plans based on BRDs and Technical Specifications.
• Created and executed test cases based on test strategy and test plans based on business requirement documents and ETL design documents.
• Written complex SQL queries for querying data against different data bases for data verification process.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Applications.
• Extensively used Informatica Workflow Manager to run the workflows.
• Preparation of technical specifications and Source to Target mappings.
• Verified the Data completeness, Data Migrations, Data transformations and Data Quality
• Defects identified in testing environment where communicated to the developers using defect tracking tool Mercury Test Director.
• Wrote SQL scripts using TOAD and Oracle SQL Developer to query DBs and analyzed the results.
• Tested a number of complex ETL mappings and reusable transformations for daily data loads.
• Creating test cases for ETL mappings and design documents for production support.
• Extensively used Informatica for extraction, transformation and loading process.
• Worked with ETL group for understating mappings for dimensions and facts.
• Tested the different sources such as Flat files, Mainframes Legacy Flat Files, DB2 and Oracle to load into the Oracle data warehouse.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Extensively tested several Crystal Reports and Hyperion reports for data quality, fonts, headers & cosmetic.
• Participated in review meetings for defect status, priority and information exchange.

Environment: Informatica, Mercury Test Director 6.5, Oracle 9i, SQL Server 2003, Teradata, SQL Assistant, XML, SSIS, TOAD, UNIX.