ETL/Database tester Resume

SUMMARY

Experience Summary

5 year of experience in IT Industry .

Having Valid H1B Visa till August 2014

Having 1+ year of experience in DWH/ETL/Database testing

Good knowledge on SDLC (software development life cycle),STLC(software test life cycle)life cycle

Involved in Functional and System testing

Worked in Informatica Power Center 8.6.1.

Worked in Oracle 9i and 10g

Strong Analytical and Design skills.

Solid team player, excellent interpersonal skills, strong communication and presentation skills, committed to work and quality.

Work Experience:

Presently working as ETL/Database tester for Confidential,Michigan,US from Jan 2011 to till date.

Worked as Senior Software Engineer in Confidential,Bangalore. (Apr 2008-Oct 2010)

Worked as Engineer ‘A’ in Confidential,

Bangalore (Apr 2007-Apr 2008)

IT Skills;

ETL Tool:

Informatica 8.6.1

Operating System :

Windows 9X/2K/NT/XP, UNIX/Linux

Script :

PL/Sql

RDBMS:

Oracle 9i/10g ,Inter Base 7.0,MS Access

Tools:

Rapid SQL

Programming Language:

Language:

German

OPERATING SYSTEM:

WINDOWS XP

DEFECT TRACKING TOOL:

HP Quality Centre, Rational Clear quest (IBM),

PROJECT MANAGEMENT TOOLS:

PRIME, PC2

Qualification:

Bachelor Of Engineering In Electronics and Communication

Trainings Undergone:

Course:

Diploma in Real Time Operating Systems

Projects:

Project name: Confidential,at Indus
Team size: 4
Environment: Informatica 8.6.1,Oracle 10g, Windows,Autosys,unix
Role: ETL Tester

Description:
This project involves data integration from different sources and to produce reports. The client is a major bank in Karnataka state which provides loans to many customers and maintains accounts of huge number of customers, it also provides internet banking, SMS banking and ATM facilities around the major cities in state, so it’s very difficult for the client company to maintain and integrate the records coming for different places, this cause them to implement BI system, where The data from the above all utilities are called from OLTP. The data from different source is first populated in staging database which is cleared at regular intervals and from staging the date is populated in to the DATA MART.

Roles and Responsibilities:

Worked as core member of Onsite DWH testing team

Involved in analyzing SRD\'s for different dimensions and facts

Written test cases for integration and end to end testing

Involved in validating mappings and workflows

Involved in writing test cases for various SRD\'s (includes Dimensions and Facts)

Involved in understanding and updating review comments

Involved in peer review of Test case document

Given valuable technical suggestions to improve the process

Involved in discussions and interactions with Client

2. VOLVO GASOLINE PROJECT at Bosch

Responsibility:

Involved in Functional and system testing

Written and executed test cases

Main line integrator

Integration of software packages to complete program Versions

Creation and delivery to internal customers of test, development and series (1) versions

Creation of software containers for the plant and delivery to the calibration

Formal checking of program versions including documentation of the results (analysis of make log files)

2. Software Sharing (Complete Vehicle Control)

Engine control module (ECM) is a type of electronic control unit (ECU) that determines the amount of fuel, ignition timing and other parameters an internal combustion engine needs to keep running. It does this by reading values from multidimensional performance maps (so called LUTs), using input values (e.g. engine speed) calculated from signals coming from sensor devices or from other ECUs within the network. Mapping of the signals to/from ECM ECU to the other ECU connected within the network is called as Software Sharing

Responsibility:

Involved in Functional and system testing

Written and executed test cases

Analysis of requirement

Involved in preparation of DLD (Detail Level Design)

Involved in Design review with SME’s(system engineers) and peer review.

Coding and implementation

4. Testing and Evaluation of Integrated Flight Control System Confidential,

Description:
The Onboard Digital Flight Control Computer (DFCC) is an integral part of the Fly-By-Wire Control System of Light Combat aircraft (LCA). The functional testing of flight software in DFCC is the most critical and rigorous testing in the entire project life cycle of design and development of LCA. This testing is conducted at a unique and dedicated test facility called Iron Bird, which is developed for this specific purpose at Aircraft Research and Design Centre of Hindustan Aeronautics Limited (HAL). This is, basically a black box testing of the DFCC software, involves its functional test and evaluation. Various evaluation tests are carried out to verify the Control Law software of DFCC namely.
1. Sub System and System Integration Verification of various DFCC interfaces
2. Verification of Failure Monitoring Systems
3. Verification of Trimmer Path, Event Setting and Mode Transition for CLAW
4. Characterization of Failure Transients and its validation against Requirement Specification
5. Performance Verification of Air Data System
6. End – to – End Open Loop Static and Dynamic Tests of CLAW
7. Pilot – in – the Loop Normal and Failure Mode Tests
8. Fault Free Tests
During all these tests, data is acquired in various data acquisition systems such as Flight Test Instrumentation FTI – RS422. After thorough analysis if any ambiguity is faced, problem reports are generated and the problem is fixed through document/software updates. The same is again tested for verification and clearance.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship