Post Job Free

Resume

Sign in

ETL/DB tester

Location:
Jersey City, NJ, 07302
Salary:
negotiable
Posted:
February 27, 2012

Contact this candidate

Resume:

Download the original attachment

ASHA L P Email:o087hx@r.postjobfree.com

Contact number: 971-***-****

Experience Summary

* **** ** ********** ** 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 Indus-USA Inc,Michigan,US from Jan 2011 to till date.

Worked as Senior Software Engineer in Robert Bosch Engineering And Business Solutions limited, Bangalore. (Apr 2008-Oct 2010)

Worked as Engineer 'A' in Aeronautical Development Agency

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 C

Language German

OPERATING SYSTEM WINDOWS XP

DEFECT TRACKING TOOL HP Quality Centre, Rational Clear quest (IBM),

PROJECT MANAGEMENT TOOLS PRIME, PC2

Qualification:

Course Bachelor Of Engineering In Electronics and Communication- (2002-06)

College Bapuji Institute Of Engineering And Technology, Davanagere.

University VTU Belgaum, Karnataka, India.

Trainings Undergone:

Course Diploma in Real Time Operating Systems

Institute Cranes Varsity, Bangalore

Duration 6 months ( September 2006-April 2007)

Projects:

Project name: Customer analysis 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 of Tejas Aircraft

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.



Contact this candidate