Results 1 to 5 of 5
  1. #1
    Join Date
    Nov 2003
    Location
    MA,USA
    Posts
    18

    Unanswered: Data conversion programmer interview

    Hi Everyone,
    I have been selected for in person interview for the position-
    Data Conversion Programmer
    I am expected to write a couple of SQL statements before appearing in the interview.Can you please help me in guiding what areas do I need to brush up especially for the above mentioned position? The database being used is Oracle9i.
    Any help would be greatly appreciated.
    Thanks in advance

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    what type of conversion? Is it database migration, converting from one db to another, importing data, exporting data? what?
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  3. #3
    Join Date
    Nov 2003
    Location
    MA,USA
    Posts
    18
    Hi Bill,
    The job requirements are as follows:

    1 Ensure that all data from a variety of legacy systems is migrated into the new system
    2 To create detailed mapping between old data elements and new data elements
    3 Analyzing legacy data and identifying problems and issues with respect to the new system
    4 Prepare Time Estimates and Conversion Quotes
    5 Working with the Project coordinators/Customers to develop business rules of resolving data issues, and developing conversion rules to transform the data for the new system
    6 Develop standardized ETL methods for a variety of source systems using combinations of Utilities, SQL scripts and conversion programs.
    7 Develop/Maintain Utility programs/Scripts to automate common pre/post conversion tasks
    8 Perform unit tests for front-end interfaces and reports.
    9 Review Customer feedback on First iteration conversion and Determine Actions
    10 Implement Second iteration Data Conversion
    11 Install the converted data on Customer's database

    If anyone can provide tips based on the above requirements
    Thanks
    lucy

  4. #4
    Join Date
    Nov 2002
    Posts
    833
    keep in mind:

    every migration projects differs from any other and it is always a "singleton"
    the dealing with sometimes fourfold logic is necessary
    true - false - unknown - n.a.
    Joe Celko mentioned in his first ed. of sql for smarties that the DOD had already detected 14 or somthing flavors of missing, invalid or corrupt data
    & my experience is a couple of shops had even more ...

    the mapping rule may vary from plain moves : move legasy.field to future.field
    you possibly need to map, split up charfields and transfer them to numeric fields
    others my require writing complex functions doing some stuff
    old key fields may be required to transfer also in some remark fields because to customers are familiar with them
    how to handle fields in the target environment you cannot support, because the legasy system has no clue about it - is a simple default sufficient
    and still to mention different or even more checkconstraints in the target environment for which the legasy system didn't care about it ...

  5. #5
    Join Date
    Jul 2003
    Posts
    2,296
    sounds like you will need to write many scripts to MONITOR the migration
    process as it occurs. This way you will be able to verify what migrated and
    what failed.

    If a failure occurs, what needs to be done? Is one process dependent upon
    another? These things need to be taken into account and considered.

    How do you verify ALL data was transfered? A script is needed for this which
    could possibly just be the sqllloader logs, etc.
    - The_Duck
    you can lead someone to something but they will never learn anything ...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •