1. A computer-implemented method for extract transform load (ETL) input suggestion for an ETL system in which a current job is being created, comprising: determining, by a computer processor, when a new input is made in the current job in the ETL system and dynamically receiving the new input, the new input a connection between stages input; updating stored information relating to the current job with the new input; accessing rules which apply to creating the current job, the rules including one or more next stage rules and one or more optimization rules for optimizing the current job; analyzing and applying, by the computer processor, the rules based on the new input and the current job stored information to generate one or more suggested next inputs in the current job, the one or more suggested next inputs selected from the group consisting of a new stage input, a connection between stages input, and a property of a stage input; providing a weighting for the one or more suggested next inputs based on the analysis and application of the rules; providing a prompt in the current job in the ETL system with the suggested one or more next inputs and their weightings; and monitoring the current job to determine when a new input is made in the current job in the ETL system and iterating the updating, accessing, analyzing and applying, providing a weighting, and providing a prompt for each new input, wherein updating stored information relating to the current job with the new input includes updating a dynamic set of rules which apply to the current job, wherein the dynamic set of rules are one or both of next stage rules and optimization rules, and wherein the current job is executed in a first sequence prior to receiving the first input and in a second sequence subsequent to receiving the first input.
4. The method of claim 1 , wherein the optimization rules are selected from the group consisting of constraint simplification, column import or export, lookup with multiple tables, inconsistent sort keys, aggregation in a transformer, parallel export, and metadata of input data.