SUMMARY:

• Experienced informatica developer with 8+ years of experience in the IT industry in data warehousing, involving analysis, development and both Manual and Automation testing.
• Experience of working extensively in Agile Environment (Agile /scrum model) and good expertise in attending Scrum calls, Sprint Planning, Reviews and retrospective meetings. extensive knowledge in SDLC: Data Analysis, Design, Development, Implementation and Testing using Data Extraction, Data Transformation and Data Loading (ETL) using Informatica Power center 9.6/9.5/9.1.1/8.6
• Possess specific experience in the hospitality, insurance, Banking, and Financial Domains.
• Extensive experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams using multiple data modeling like star schema and snowflake schema
• Strong SQL query skills using an enterprise wide RDBMS (Oracle, MS SQL Server & MS Access) and strong with concepts of SQL queries ranging from DML, DDL and TCL
• Experience in developing stored procedures and triggers.
• Strong experience in Informatica tools Repository manager, Designer, Workflow manager, Workflow monitor.Ability to Work with complex mappings using different transformations like Source Qualifier, Lookup, Filter, Expression, Router, Normalizer, Joiner, Update Strategy, Rank, Aggregator, Stored Procedure, Sorter, and Sequence Generator
• Experience in developing the mappings, mapplets, reusable transformations in designer and scheduling the workflows and sessions in work flow manager.
• Strong knowledge in debugging mappings and using mapping parameters and variables for incremental loading of data and session parameters for migrating workflows.
• Performed various data cleansing activities using informatica data quality (IDQ)
• Performed data profiling, data cleansing, data parsing, datastandardization using IDQ
• Experience in BI / Data warehouse projects involving Informatica and BO suite of products.
• Understanding & Working knowledge of Informatica CDC (Change Data Capture).
• Experience with Teradata tools fast export, multiload, parallel transporter
• Worked with Data Warehouse Administration Console (DAC) to schedule and run full and Incremental ETL
• Knowledge in identifying Bottlenecks in ETL Processes, improving the Performance of the production applications using Database Tuning, Partitioning, Index Usage, Aggregate Tables, and Normalization / Denormalization strategies experience in UNIX and Shell Scripting, knowledge of coding ETL Tasks in UNIX Shell scripts to interact with INF server using PMCMD command
• Very strong in designing mapping document
• Experience in generating web intelligence reports using business objects
• Expertise in unit testing at various levels of the ETL as well as SQL.
• Experience in designing Test Plans, Test Scenarios, Test cases and Test summary reports
• Proficient in writing Test Strategies, Test Plans, Test Cases, Test Scripts, Test Scenarios and Test Summary Reports for both Manual and Automated Testing.
• Expertise in unit testing at various levels of the ETL as well as SQL, UNIX
• Worked on Query Surge to perform ETL testing.
• Proficient in HPQuality Center and ALM for Test Designing, Requirement Mapping, Reports, Test Execution and Defect Tracking
• Have great knowledge on INFORMATICA DATA VALIDATOR
• Expert working with Databases like Teradata, Oracle 11g, SQL Server.
• Maintained outstanding relationship with Business Analysts and Business Users to identify information needs as per the business requirement Experience working with Onside - Offshore model.
• Ability to work independently or in a team environment or in a rapid pace environment.
• Possess strong interpersonal skills, communication and presentation skills with the ability to interact with people at all levels

TECHNICAL SKILLS:

ETL/BI Tools: Informatica Power Center 9.6/9.1/8.6.1.1, Informatica data quality, DATASTAGE,, AUTOSYS

Database Tools: SQL developer, Toad

Environment: Windows XP/2000/NT/98/95, Windows 2003 server, Unix

Programming Languages: SQL, PL/SQL, SQL*Loader, Unix, Shell Scripting, CJava BI Tools Business Objects XIR3/XIR2, Cognos testing: HP Quality Center and HP ALM, Query Surge

Databases: Oracle 11g/10g/, MS-SQL Server 2012/2008/2005, Teradata 10 amp

Business Applications: Word, Excel, Access, Project, PowerPoint

PROFESSIONAL EXPERIENCE:

INFORMATICA DEVELOPER

Confidential,Richmond, VA

• Having involved in full life cycle design and development of Data warehouse.
• Interacted with business analysts, architects and application developer to analyze the data model and gathered the requirements.
• Designed, developed and tested mappings to move data from source to staging load followed with data cleansing.
• Analyzed system documentation like Requirements documents, Gap analysis user interface specifications to develop technical document of the business flow to design, develop, and execute the mappings.
• Worked on identifying Mapping Bottlenecks in Mappings and improved session performanceand mapping performanceby including partition points, modifying target load order and emphasizing more on SQL override in Lookup, Source Qualifier, Filter, and Update strategy, functions in expression transformations.
• Used Workflow Manager for creating, validating, testing and running the sequential and concurrent sessions and scheduling them to run at specified time and as well to read data from different sources and write it to target databases
• Executed pre and post session commands on source and target database using UNIX shell scripting.
• Proficient experience in working on conceptual, physical and logical data models(3NF) using various schemas
• Reviewed, analyzed, and ensured the quality of data loaded into the database system by utilizing IDQ imported, sorted, cleaned, and transformed data according to business objectives
• Created reference tables to perform standardization, parsing, cleansing, of data
• Involved in quality assurance of data, automation of processes.
• Documented and maintained technical documentation regarding the extract, transformation and load process.
• Investigated and fixed problems encountered in the production environment on a day to day basis.

Environment: Informatica Power Center9.5.1/9.1, SQL Server 2008,Control M, Oracle 10g, PL/SQL, Business Objects XIR3, Toad, UNIX Shell Scripts.

INFORMATICA DEVELOPER

Confidential,Baltimore, MD

• Involved in understanding Business Process and coordinated with Business Analysts to understand specific user requirements.
• Involved in Code reviews and determining Informatica standards for Mappings/Sessions/ Workflows.
• Created reusable transformations and mapplets and used them in mappings.
• Implemented the slowly changing dimensions (SCD) type1 and type2 to maintain current information and history information in the dimension tables.
• Used Informatica Power Center Workflow manager to create sessions, batches to run with the logic embedded in the mappings.
• Created complex mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator, Update Strategy, SQL, Union, Lookup, Joiner, XML Source Qualifier, Unconnected lookup transformations.
• Created shell scripts to kick off Informatica workflow/s and PL/SQL procedures.
• Created Database Triggers, Stored Procedure, Functions and Packages.
• Extensively used debugger to trace the errors.
• Extensively tested the code and documented the Unit Test Cases.
• Assisted the testers in system and integration testing and preparing the test cases and test plan.
• Extensively used UNIX scripts for automation of ETL process.
• Extensively worked on tuning mappings and reducing processing times.
• Worked with DBA to identify source and target bottle necks.
• Analyzed existing requirements and consolidated the reports for effective and efficient reporting.
• Involved in production support for the data warehouse Informatica jobs.
• Involved in bug fixing. Debugged the issues during QA level.

Environment: Informatica 9.1, Oracle 10g/11g, Business Objects, IBM DB2, Quality Center, MYSQL, SQL, TOAD, PL/SQL, Teradata, AutoSys, Windows, UNIX (Sun Solaris)

ETL TESTER

Confidential

• Involved in understanding Business Process and coordinated with Business Analysts to understand specific user requirements.
• Tested the extracted the data from heterogeneous sources like .data file, Excel file, .csv file, flat files, Oracle.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Involved in developing detailed Test strategy, Test plan, Test cases and Test procedures using Quality Center for Functional and Regression Testing
• Conducted Smoke testing, data completeness testing and Data validation testing.
• Performed Verification, Validation, and Transformations on the Input data (Text files) before loading into target database.
• Responsible for validation of Target data in Data Warehouse and Data Marts.
• Validated data in between source and target after running Mappings by the developer team.
• Collected the statistics after creating the tables in Teradata.
• Developed complex SQL queries for data validation and data verification based on data mapping document.
• Communicated and documented test results and defect resolution during all phases of testing.
• Focused on data quality issues / problems that include completeness, conformity, consistency, accuracy, duplicates and integrity
• Ran SQL queries to verify the number of records and validated the referential integrity rules as per the design specifications.
• Worked on query surge for ETL automation testing.
• Coordinated execution of User Acceptance Testing, regression and integration testing with multiple departments.
• Identified appropriate test data in relevant source systems and incorporated this data into test scripts.
• Used HPALM to keep track of the testing activities and keep track of bugs
• Maintained requirements and created Traceability between Requirements and Test Cases.
• Involved in documentation in order to maintain and run scripts for future enhancements.
• Responsible for sending a Data Warehouse Quality report to the QA manger on weekly basis

Environment: Informatica Power Center 8.6/9.1, HP ALM, Query Surge, Oracle10g/11g, PL/SQL, PL/SQL, Toad, DAC, Windows NT, UNIX Shell Scripts.

SQL DEVELOPER

Confidential

• Analyzing different user requirements and coming up with specifications for the various database applications
• Worked with internal and external clients for import and normalization of third-party data.
• Plan, design, and implement application database code objects, such as stored procedures and views.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Developing RDBMS using STAR and SNOWFLAKE SCHEMA
• Monitored the performance of the database and checked on the execution time
• Wrote SQL Queries, Triggers and Shell Scripts to apply and maintain the Business Rules.
• Created views to ensure the data security by providing limited data to users based on requirement.
• Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.
• Performed SQL query performance tuning by creating and modifying indexes and changing the query structures.
• Used Informatica Designer to create basic mappings using different transformations like Source Qualifier, Expression, Lookup, Aggregator, and Update Strategy, Joiner, Filter and Router transformations to pipeline data to Data Warehouse/Data Marts

Environment: Informatica Power Center 8.6.1, Oracle 10g, SQL DEVELOPER, PL/SQL, Windows NT, UNIX Shell Scripts.