We provide IT Staff Augmentation Services!

Etl Qa Consultant Resume

MN

PROFESSIONAL SUMMARY:

  • Over 7+ years of IT experience as a Data Analyst/QA Tester with solid understanding of Data Modeling, Evaluating Data Sources and strong understanding of Data Warehouse/Data Mart Design, ETL, BI, OLAP, Client/Server applications.
  • Currently working at Confidential (Minneapolis) as ETL QA Analyst.
  • Major Job responsibilities have been Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
  • Extensive ETL testing experience using Informatica 8.6.1/9.1 (Power Center)(Designer, Workflow Manager, Workflow Monitor and Repository Manager)
  • Good experience of Unit, Functional, System and Integration testing for informatica and data warehousing projects.
  • Excellent in creating various artifacts for projects which include specification documents, data mapping and data analysis documents.
  • Experience in creating Test Readiness Review (TRR ), Requirement Traceability Matrix (RTM) documents.
  • Good experience in building test cases and test scripts using HP Quality Centre (QC) and HP ALM.
  • Experience in working with Software Development team in resolving Defects, presenting the Defect Status reports, resolving requirement, and observed design inconsistencies.
  • Expertise in querying and testing RDBMS such as Oracle, MS SQL Server using SQL, PL/SQL for data integrity.
  • Experience in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables.
  • Extensive experience with Banking, HealthCare, Energy and retail domains.
  • Worked for clients like TCF, Confidential , TARGET and AVIVA .
  • Good understanding of configuring and using Informatica Powercenter.
  • Ability to understand and/or create functional requirements working with client and also have Good experience in requirement analysis and generating test artifacts from requirements documents.
  • Expert in writing SQL queries and optimizing the queries in Oracle 12c, SQL Server 2012.
  • Experience in managing testing teams working on ETL and Data Quality.
  • Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and SQL Server.
  • Worked with multiple stakeholders (Application Owners, Architects, QA, and Business Analysts & external vendors) and participated in the requirements and process meetings with them.
  • Part of the QA review team during the design of Data warehouse.
  • Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star - Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
  • Tested and Implemented Slowly Changing Dimensions - Type I &II in Dimension tables as per the requirements.
  • Knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.
  • Excellent experience in analysis huge volumes of data in industries such as Finance, Healthcare & Retail.
  • Excellent knowledge in preparing required project documentation and tracking and reporting regularly on the status of projects to all project stakeholders
  • Good understanding and experience of Data Warehousing, Data Modelling and dimensional modelling.
  • Experience in Unit Testing, System Testing, Functional Testing, Regression Testing.
  • Tracking Defects and preparing defect report using Defect Tracking tool HP ALM & QC .
  • Team player with good communication, interpersonal, analytical and problem solving skills.
  • Certified with IBM Certified Database Associate - DB2 Universal Database V8.1 Family.
  • Certified with CII level 1 from Chartered Insurance Institute based in UK.
  • Good experience of onsite and offshore model and experience in handling global teams.
  • Good experience of 24*7 Production suppor t environments.
  • Worked with various geographical teams and time zones.
  • Extensive team leading experience and capabilities.
  • Good organization, communication and interpersonal skills.
  • Strong problem solving, troubleshooting and analytical skills.
  • Ability to quickly learn new technologies in a dynamic environment.
  • Good knowledge of current trends in data warehousing and business analytics technologies.
  • Good Knowledge of Informatica (Power Centre 9.1.0), CA7, HP QC and HP ALM, Platinum, expeditor, abend-aid, Endevor, SPUFI, File-Aid, Assyst, SQL server 2008, Service Now, Oracle 9i, UC4 scheduler, SQL Server Management Studio.

TECHNICAL SKILLS:

ETL: Informatica 8.6, Informatica 9.1.0, Data Warehousing

Programming Language: SQL, PL/SQL, COBOL, JCL, REXX, Informatica (Power Center)

Databases: Oracle 12c, SQL Server 2012, IBM DB2

Methodologies: Software Development Life Cycle, Scrum Agile Methodology

Testing Tools: Informatica Power Center, WinScp, Filezilla, Autosys, UC4, Toad, SPUFI, DVO, SQL Developer, SQL server 2012, HP QC, HP ALM

Environment: Windows 7, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, MN

ETL QA Consultant

Responsibilities:

  • Worked with Business Analysts to define testing requirements to satisfy the business objectives.
  • Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
  • Experience in SDLC and Agile methodologies such as SCRUM.
  • Analyzing requirements and creating and executing test cases.
  • Test Case Execution and Adhoc testing.
  • Performed Integration, End-to-End, system testing.
  • Involved in Functional Testing & Regression Testing.
  • Involving in writing complex SQL queries to verify data from Source to Target.
  • Performed data validation testing writing SQL queries.
  • Used Quality Center QC/ALM for creating and documenting Test Plans and Test Cases and register the expected results.
  • Using HP Quality Center/ALM for storing, maintaining the test repository, bug tracking and reporting Implementation of error handling and logging process.
  • Tuned and improved the performance of Informatica mappings after validating the mapping functionality.
  • Experienced in retest the existing test cases with the different kind of source systems for different periods of data.
  • Preparing documentation for some of the recurring defects and resolutions and business comments for those defects.
  • Created technical design documents and Data Mapping documents as per the Business requirement.

Environment: & Tools: Informatica Power Center 9.1, Oracle 12c, SQL Server 2012, WINDOWS 7, HP QC/ALM.

Confidential, Missouri (MO)

Informatica ETL Consultant

Responsibilities:

  • Requirements gathering and application programming based on the requirements.
  • Data modeling experience using Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling.
  • Using Informatica Power Center Designer analyzed the source data to Extract & Transform from various source systems (DB2 and flat files) by incorporating business rules using different objects and functions that the tool supports.
  • Expertise in the extraction process to combine data from various sources to develop a unified source of data for reporting.
  • Working with DVO data validation tool to validate the data accurately.
  • Worked on dimensional modeling for creating and maintaining SCD type 2 dimensions like customer, product and time.
  • Performed data analysis and data validation as part of unit testing and coordinated with business users for UAT approval based upon the data accuracy, consistency And correct implementation of business requirements.
  • Developed and tested ETL interfaces which involved complex transformations to populate data and implementation of business logic.
  • Extensively used all major Informatica transformations like Lookup, Aggregator, Expression, Joiner, Router, Filter, Update Strategy etc.
  • Responsible for creating the mappings, workflows, sessions, and also other tasks like event wait, event raise, command and email etc.
  • Designed and developed pre and post session SQL scripts.
  • Used debugger and breakpoints to debug the Informatica mappings.
  • Implementation of error handling and logging process.
  • Good experience in interaction with Teradata database.
  • Tuned and improved the performance of Informatica mappings after validating the mapping functionality.
  • Created technical design documents and Data Mapping documents as per the Business requirement.
  • Maintenance and support of the ETL interfaces and jobs in production.

Environment: & Tools: Informatica Power Center 9.1, DB2 v8.1, PL-SQL Developer, Autosys, WINDOWS 2000/ XP, UNIX, WINscp.

Confidential

Informatica ETL Consultant

Responsibilities:

  • Design, development and testing of Informatica ETL mappings and programs.
  • Validate and review data model, design and develop (Technical Design) ETL interfaces.
  • Development of Mappings, Mapplets, Workflows and other Informatica Power Center components.
  • Extracted data from Flat files, DB2, SQL and Oracle to build an Operation Data Source. Applied business logic to load the data into Global Data Warehouse.
  • Experience in using SSIS tools like Import and Export Wizard, Package Installation, and SSIS Package Designer.
  • Experience in importing/exporting data between different sources like Oracle/Access/Excel etc. using SSIS/DTS utility.
  • Worked on Dimension modeling and maintained dimensions like Claims, Policies etc.
  • Worked on the high priority user issues/tickets as part of production support.
  • Worked on creation of complex SQL queries and programs.
  • Actively involved in Unit testing, system testing and code reviews of the application and creation of test cases and test plans.
  • Worked on STAR schema modeling as part of Data modeling, FACTS and DIMENSION TABLES.
  • Tracking of insurance policy and Claims status.
  • Involved in weekly reports and ad-hoc reports generation.
  • Analyze and understand detailed business requirements and create Informatica mappings as per the requirements.
  • Provide recommendations for software developments and implementations.
  • Worked on performance improvement of existing mappings and ETL jobs.
  • Performed Data Analysis as part of Unit testing of the policies and claims workflows.
  • Execute program modifications and change requests as per the change management process.
  • Interface with clients, software professionals and business analysts to develop required applications.
  • Review and evaluate technical design and technical quality issues and processes.
  • Develop highly functional qualitative modifications and system changes.
  • Assist development teams to maintain all data sources and data storage options.
  • Coordinate with business users/analysts to develop Informatica mappings as per the business requirements.
  • Perform all day to day data warehouse related maintenance activities.
  • Involved in 24*7 production support and monitoring of ETL jobs and schedules.
  • Writing Testing cases & scenarios based on Functional & Business requirements and solution design
  • Creation of design documents, validating requirements, perform code review, performance tuning.
  • Administer all requests and analyze issues and provide efficient and on time resolution for the same.
  • Monitor all day to day data related production issues and inquiries and provide efficient resolution for the same.
  • Collaborate with application groups to prepare effective solutions for all Informatica programs. Document all technical specifications and associated project deliverables.
  • Job scheduling and monitoring using UC4 scheduler tool.

Environment: & Tools: Informatica Power Center 8.6, DB2, PL/SQL, Mainframes, TOAD, WINDOWS 2000/ XP, UNIX.

Confidential

Informatica ETL Developer

Responsibilities:

  • Involved in the overall system analysis/design/development/performance optimization and Documentation as a Team Member for Informatica and mainframe programs.
  • Extensively worked on Informatica Power Center mappings and Oracle 9i programs.
  • Extensively worked on mainframe programming and development.
  • Worked on dimensional modeling and maintained dimensions like Product, Customer, and Region as a part of Snowflake schema and loaded the data in the Sales fact tables.
  • Involved in the Business meetings and requirement gathering.
  • Involved in resolving high priority tickets and issues related to the support system.
  • Actively participated in testing of the application by writing test cases, testing scripts for the Unit, System and Performance testing.
  • Various ad-hoc Reports generation.

Environment: & Tools: Informatica Power Center 8.6, Oracle 9i, Mainframes, TOAD, PL/SQL Developer

Hire Now