We provide IT Staff Augmentation Services!

Etl Tester Resume

Vernonhills, Il

PROFESSIONAL SUMMARY:

  • Qualifications include possessing Master degree and 9 years of IT experience with seven years of testing and two years of software development and support experience.
  • Worked as a Senior QA Test Lead. Experience in full system development lifecycle, including designing, developing, and implementing test plans, test cases and test processes. Highly analytical and detailed and has Strong knowledge of STLC and SDLC and is well versed in writing & executing test cases and test scenarios.
  • As an ETL tester has solid experience with data models, source and target identification, target mapping and testing schemas. Possesses extensive knowledge of transformation rules, verification processes and data sample comparisons
  • Involved in major Data warehousing projects as an ETL Tester / Developer. Hands on expertise in Data warehousing concepts and tools as well as engaged in the ETL processes where in the organizations were using Datastage, Informatica and Abinitio ETL tools.

TECHNICAL SKILLS:

Testing tools: Test Director 8.0, Quality Center, Clear Quest

Operating Systems: UNIX, MS - DOS, Windows-95/98 and Windows NT

Languages: C, C++

Production Planning Tools: Autosys, Control - M, CVS, PVCS, XML, Clear case, Clear Quest

Sql: Oracle 9i, SQL SERVER,PL/SQL, SQL

DW tools: Informatics Power Center 9.1 & 5.0, and Power Mart 5.0, Ab-Initio (GDE Version 1.14) Co>OS:V2-14

PROFESSIONAL EXPERIENCE:

ETL Tester

Confidential, Vernonhills, IL.

Responsibilities:

  • Involved in gathering requirements from Business users and technical teams.
  • Used Informatica Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into data warehouse database.
  • Involved in testing Informatica maps which are developed to load data to various dimensions and fact tables.
  • Validated the data movement and transformations are done correctly
  • Worked with Data Warehousing developers who extensively used Informatica to design mapping to move data from source to target database using transformers to do the functionality.
  • Loaded data to different databases using SQL scripts and maintained a repository for data loading scripts
  • Used Shell scripts extensively for automation of file manipulation and data loading procedures.
  • Develop parameter driven ETL process to map source systems to target data warehouse with Informatica complete source system profiling.
  • Execute batch processing and verify the jobs status and data in database tables
  • Involved in Finding bugs and logging the bugs in defect tracking tool(JIRA) and reporting Test Results to Development team and Production team
  • Experience testing on XML documents.
  • Attending Team (Scrum) Meetings Bi-weekly, Product Meetings and technical discussions.
  • Sending Build/sprint results and bug report documents to Test manger, Development Manager and Project Manager.
  • Responsibilities include GUI testing, Functional testing, Integration testing, System testing and UAT
  • Worked on onsite & offshore model and involved in Analysis of requirements, coordinating with offshore team on a daily basis to let the team understand the business needs.
  • Involved in debugging, Error handling and verifying logs in case of job failures and Implements the recovery from restart mechanism.

Environment: Informatica 9.1, UNIX, Oracle 11G, PL/SQL IE, JIRA, QC, MS-Word, MS-Excel.

ETL Test Lead / Developer

Confidential, Chicago, IL.

Responsibilities:

  • Involved in gathering requirements and analysis for applications.
  • Used Informatica as an ETL Tool for Developing the Data Warehouse for MBI
  • Developed mappings using transformations like Expression, lookup, filter, join, union and aggregate transformations.
  • Worked on developing reusable maplets which are common to all Map object types of Confidential .
  • Developed Region wise sessions and workflows which can be processed in sequence and for all map object types to be processed in parallel as part of Batch processing.
  • Developed parameter driven ETL process to map source systems to target data warehouse with Informatica complete source system profiling
  • Handled two applications like POI (points of Interests) and Node which are some of the map objectives.
  • Involved in back end testing and writing SQL queries to derive the expected results (like number of changes in POI and Node objects
  • Reported test data issues that were encountered during test data analysis after validation against production data Involved in writing complex SQL queries to analyze the test data which is copied from the production to dev and test environments.
  • Involved in testing UNIX scripts which generates param files and executes the automated jobs

Environment: Quality Center 10, JIRA, Informatica 9.1, UNIX, Oracle 11G, PL/SQL IE, MS-Word, MS-Excel.

ETL Test Lead

Confidential, Hoffman Estates, IL

Responsibilities:

  • Involved in gathering requirements from Business users and technical teams
  • Involved in testing the POS systems by ringing up various transactions per business requirements.
  • Analysis of requirements and coordinating with offshore team on a daily basis to let the team understand the business needs.
  • Processing set of Informatica batch jobs which can be processed in sequence to generates the daily batch files that get transferred to AS400.
  • Involved in debugging the UNIX scripts in case of any defect encountered to provide the accurate information while logging a defect.
  • Involved In writing SQL queries to judge the test results by comparing the batch files data that’s generated due to Informatica batch jobs.
  • Involved in preparing Decomp and Traceability matrix based on BRD and TTD(Technical design document)
  • Involved in writing and implementing the Test plan, Test cases, Test Procedures, Test sets using Use cases and requirement specifications.
  • Involved in Finding the bugs and logging the bugs by defect tracking tool(JIRA) and reporting Test Results to Development team and Production team
  • Involved in Test case reviews and Review meetings on Test case documents prepared from off-Shore
  • Validating the back end systems for the corresponding transactions performed on POS.

Environment: Quality Center 10, Informatica9.1, Oracle 11g, UNIX, JIRA, Retail QA tool, Quick Test Professional 10, IE, MS-Word, MS-Excel

ETL Test Lead

Confidential, Linconshire, IL

Responsibilities:

  • Involved in Design and development of test plans based on high-level documents(BRD & FRS)
  • Involved in writing and implementing the Test plan, Test cases, Test Procedures, Test sets using Use cases and requirement specifications.
  • Involved in Change Request (CR) meetings with Business users of Retail, Pharmacy and Photo sections of Confidential .
  • Used Informatica as Integration service between Pos server and As400 to generate and deliver the batch files like daily Item movement, Hourly item movements, Depart polling, Age restricted trans and Coupon maintenance files.
  • Responsible for Processing Informatica End of the day batch jobs from UNIX operating system after successfully ringing transactions on POS system.
  • Worked on Mainframe files
  • Used Mainframes for the daily item movement files from the production to AS400 environments.
  • Involved in Testing End of the Day process from POS end and verifying Nightly Job execution and the success nightly batch files and Reports
  • Involved in Validating the Nightly Files and reports

Environment: Quality Center 10, Informatica 9.1, Oracle 11g, Pl/SQL, Bugzilla, Quick Test Professional 10.Java, J2ee, SQL server, UNIX,, XML,Tuxedo, IE,.MS-Word, MS-Excel, Confidential in house tools Jump server .

Tester & Support Analyst

Confidential, Irving, Texas

Responsibilities:

  • Actively involved in resolving the Incident tickets to support the Business users with their day to day activities.
  • Monitoring the Batch Jobs and providing timely support for any batch abends.
  • Working with problem management issues to give permanent fix for the repetitive tickets that will be reported by business users.
  • Involved in improving the performance of Batch jobs by implementing Multi threading concept and tuning the SQL queries.
  • Coordinating with client in understanding the requirements.
  • Analysis of requirements and coordinating with offshore team on a daily basis to let the team understand the business needs.
  • Developing, testing and validating the old version of code with re-engineered version for bug fixes and performance tuning.

Environment: Pro* C, Oracle 10g forms and Reports, UNIX Shell Scripting, Pl/SQL, Control-M, Heat, Serena, MQ, Applications like RMS12, Retek6.6 and RPM.

ETL Test Lead

Confidential

Responsibilities:

  • Involved in Design and development of test plans based on high-level documents(BRD & FRS)
  • Involve in writing and implementing the Test plan, Test cases, Test Procedures, Test sets using Use cases and requirement specifications.
  • Involved in Change Request(CR) meetings with Business users of Retail, Pharmacy and Photo
  • Extensively involved in testing the application developed in Agile Methodology.
  • Involved in defining Test Scenarios for the applications and performed manual testing in HP Quality Center

Environment: AbInitio, UNIX, Oracle, Retek Applications like ORMS, ORPM, RIB and Rational testing tools.

ETL Developer

Confidential

Responsibilities:

  • The project involved in extracting data from various sources, transforming the data from these sources before loading the data in to target (warehousing) Oracle tables.
  • Created the mappings using transformations such as the Source qualifier, Aggregator, Expressions, Lookup, Router, Filter, and Update Strategy.
  • Implemented slowly changing strategy to manage the data in the dimension tables.
  • Responsible of business requirement and analysis from business users.
  • Involved in development of optimized AbInitio graphs for High Volume transformations.
  • Involved in Wide usage of Lookup Files while getting data from multiple sources and size of the data is limited.
  • Developed Complex AbInitio XFR s to derive new fields and solves rigorous business requirements.
  • Implemented Data Parallelism through graphs, which deals with data, divided into segments and operates on each segment simultaneously through the AbInitio partition components to segment data.

Environment: Abinitio, Oracle 8i, SQL, PL/SQL.

Hire Now